用cobar搭建分布式数据库

最新推荐文章于 2024-06-13 09:00:30 发布
最新推荐文章于 2024-06-13 09:00:30 发布
阅读量129 收藏
点赞数
文章标签： 数据库 大数据 后端
原文链接：https://my.oschina.net/abcijkxyz/blog/722133
版权

周末针对最新的项目需求进行cobar的搭建并针对实际状况做了demo演示

一、需求

1、大数据量，邮件发送记录需要记录，一年可能累计4亿的数据

2、需要按照邮箱进行邮件发送明细的查询以及发送记录的查询


二、问题

1、单库分表分区已经解决不了存储以及查询问题

2、只能进行一致性hash的策略进行数据存储以及查询，放弃了一些便利性查询统计


三、实施方案，数据库采用mysql，使用cobar针对分区库和主库进行整合

整合步骤如图，看不清可以下载附件看


四、相关配置文件以及工具文件如下

1、操作指南：edm-cobar操作指南.txt

1、mysql -h192.168.20.65 -uroot -p1q2w3e -P8066
2、show databases;
3、use edm;
4、show tables;



note:
1、cobar server作为代理，安装在20.65上，并且以root/1q2w3e为口令，8066为服务端口提供了数据库代理服务
具体路径/usr/local/cobar***
2、我们的数据库可以以这个代理服务器为访问端口，按照email这个字符串进行水平的hash路由到各个水平节点上
3、对于不需要水平拆分的表，我们也可以直接通过20.65提供的这个edm服务访问

warning：
1、直接用sqlyog软件访问这个代理数据库可能会报错，因为获取数据问题。不过我们可以直接通过cmd来查询。
2、我们的数据校验，可以通过直接访问各个节点进行数据校验
 


2、实施策略图片：EDM分布式数据库策略之Cobar.jpeg


3、cobar的相关配置文件：rule.xml,schema.xml,server.xml

<?xml version="1.0" encoding="UTF-8"?>
<!--
 - Copyright 1999-2012 Alibaba Group.
 -  
 - Licensed under the Apache License, Version 2.0 (the "License");
 - you may not use this file except in compliance with the License.
 - You may obtain a copy of the License at
 -  
 -      http://www.apache.org/licenses/LICENSE-2.0
 -  
 - Unless required by applicable law or agreed to in writing, software
 - distributed under the License is distributed on an "AS IS" BASIS,
 - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 - See the License for the specific language governing permissions and
 - limitations under the License.
-->
<!DOCTYPE cobar:schema SYSTEM "schema.dtd">
<cobar:schema xmlns:cobar="http://cobar.alibaba.com/">

  <!-- schema定义 -->
  <schema name="edm" dataNode="dnEdm">
    <table name="email_info" dataNode="dn_shardx$0-7,dn_shardy$0-7" rule="email_rule" />
	<table name="email_info_detail" dataNode="dn_shardx$0-7,dn_shardy$0-7" rule="email_rule" />
  </schema>

  <!-- 数据节点定义，数据节点由数据源和其他一些参数组织而成。-->
  <dataNode name="dnEdm">
    <property name="dataSource">
      <dataSourceRef>db_edmx[0]</dataSourceRef>
    </property>
  </dataNode>

  <dataNode name="dn_shardx">
    <property name="dataSource">
      <dataSourceRef>db_edmx$1-8</dataSourceRef>
    </property>
  </dataNode>

  <dataNode name="dn_shardy">
    <property name="dataSource">
      <dataSourceRef>db_edmy$0-7</dataSourceRef>
    </property>
  </dataNode>

  <!-- 数据源定义，数据源是一个具体的后端数据连接的表示。-->
  <dataSource name="db_edmx" type="mysql">
    <property name="location">
	  <!--edm  总库-->
	  <location>192.168.20.182:3306/edm_hd</location>

      <location>192.168.20.182:3306/edmshard$1-8</location>

    </property>
    <property name="user">root</property>
    <property name="password">your_password</property>
    <property name="sqlMode">STRICT_TRANS_TABLES</property>
  </dataSource>

  <dataSource name="db_edmy" type="mysql">
    <property name="location">
      <location>192.168.119.158:3306/edmshard$9-16</location>
    </property>
    <property name="user">root</property>
    <property name="password">your_password</property>
    <property name="sqlMode">STRICT_TRANS_TABLES</property>
  </dataSource>
</cobar:schema>

<!DOCTYPE cobar:rule SYSTEM "rule.dtd">
<cobar:rule xmlns:cobar="http://cobar.alibaba.com/">

  <!-- 路由规则定义，定义什么表，什么字段，采用什么路由算法 -->
  <tableRule name="email_rule">
    <rule>
      <columns>email</columns>
      <algorithm><![CDATA[ efunc(${email}) ]]></algorithm>
    </rule>
  </tableRule>

  <!-- 路由函数定义 -->
  <function name="efunc" class="com.alibaba.cobar.route.function.PartitionByString">
    <property name="partitionCount">16</property>
    <property name="partitionLength">64</property>
  </function>

</cobar:rule>

<?xml version="1.0" encoding="UTF-8"?>
<!--
 - Copyright 1999-2012 Alibaba Group.
 -  
 - Licensed under the Apache License, Version 2.0 (the "License");
 - you may not use this file except in compliance with the License.
 - You may obtain a copy of the License at
 -  
 -      http://www.apache.org/licenses/LICENSE-2.0
 -  
 - Unless required by applicable law or agreed to in writing, software
 - distributed under the License is distributed on an "AS IS" BASIS,
 - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 - See the License for the specific language governing permissions and
 - limitations under the License.
-->
<!DOCTYPE cobar:server SYSTEM "server.dtd">
<cobar:server xmlns:cobar="http://cobar.alibaba.com/">
  
  <!-- 系统参数定义，服务端口、管理端口，处理器个数、线程池等。 -->
  <!--
  <system>
    <property name="serverPort">8066</property>
    <property name="managerPort">9066</property>
    <property name="initExecutor">16</property>
    <property name="timerExecutor">4</property>
    <property name="managerExecutor">4</property>
    <property name="processors">4</property>
    <property name="processorHandler">8</property>
    <property name="processorExecutor">8</property>
    <property name="clusterHeartbeatUser">_HEARTBEAT_USER_</property>
    <property name="clusterHeartbeatPass">_HEARTBEAT_PASS_</property>
  </system>
  -->

  <!-- 用户访问定义，用户名、密码、schema等信息。 -->
  <user name="root">
    <property name="password">1q2w3e</property>
    <property name="schemas">edm</property>
  </user>
  <!--
  <user name="root">
    <property name="password"></property>
  </user>
  -->

  <!-- 集群列表定义，指定集群节点的主机和权重，用于集群间的心跳和客户端负载均衡。 -->
  <!-- 
  <cluster>
    <node name="cobar1">
      <property name="host">127.0.0.1</property>
      <property name="weight">1</property>
    </node>
  </cluster>
   -->
   
  <!-- 隔离区定义，可以限定某个主机上只允许某个用户登录。 -->
  <!--
  <quarantine>
    <host name="1.2.3.4">
      <property name="user">test</property>
    </host>
  </quarantine>
  -->

</cobar:server>


4、测试数据文件：edm_demo.sql

use edm;
/**=====================在cobar server的schema(edm)的root账号下，直接清理数据=============================**/
delete from edm_users;
delete from email_info;
delete from email_info_detail;
/**======================在cobar server的schema(edm)的root账号下，直接写入非分区库edm_hd中的edm_users 100条数据============================**/
use edm;
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd0','edm_hd0@hc360.com','psw0','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd1','edm_hd1@hc360.com','psw1','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd2','edm_hd2@hc360.com','psw2','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd3','edm_hd3@hc360.com','psw3','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd4','edm_hd4@hc360.com','psw4','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd5','edm_hd5@hc360.com','psw5','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd6','edm_hd6@hc360.com','psw6','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd7','edm_hd7@hc360.com','psw7','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd8','edm_hd8@hc360.com','psw8','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd9','edm_hd9@hc360.com','psw9','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd10','edm_hd10@hc360.com','psw10','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd11','edm_hd11@hc360.com','psw11','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd12','edm_hd12@hc360.com','psw12','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd13','edm_hd13@hc360.com','psw13','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd14','edm_hd14@hc360.com','psw14','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd15','edm_hd15@hc360.com','psw15','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd16','edm_hd16@hc360.com','psw16','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd17','edm_hd17@hc360.com','psw17','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd18','edm_hd18@hc360.com','psw18','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd19','edm_hd19@hc360.com','psw19','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd20','edm_hd20@hc360.com','psw20','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd21','edm_hd21@hc360.com','psw21','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd22','edm_hd22@hc360.com','psw22','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd23','edm_hd23@hc360.com','psw23','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd24','edm_hd24@hc360.com','psw24','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd25','edm_hd25@hc360.com','psw25','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd26','edm_hd26@hc360.com','psw26','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd27','edm_hd27@hc360.com','psw27','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd28','edm_hd28@hc360.com','psw28','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd29','edm_hd29@hc360.com','psw29','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd30','edm_hd30@hc360.com','psw30','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd31','edm_hd31@hc360.com','psw31','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd32','edm_hd32@hc360.com','psw32','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd33','edm_hd33@hc360.com','psw33','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd34','edm_hd34@hc360.com','psw34','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd35','edm_hd35@hc360.com','psw35','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd36','edm_hd36@hc360.com','psw36','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd37','edm_hd37@hc360.com','psw37','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd38','edm_hd38@hc360.com','psw38','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd39','edm_hd39@hc360.com','psw39','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd40','edm_hd40@hc360.com','psw40','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd41','edm_hd41@hc360.com','psw41','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd42','edm_hd42@hc360.com','psw42','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd43','edm_hd43@hc360.com','psw43','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd44','edm_hd44@hc360.com','psw44','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd45','edm_hd45@hc360.com','psw45','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd46','edm_hd46@hc360.com','psw46','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd47','edm_hd47@hc360.com','psw47','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd48','edm_hd48@hc360.com','psw48','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd49','edm_hd49@hc360.com','psw49','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd50','edm_hd50@hc360.com','psw50','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd51','edm_hd51@hc360.com','psw51','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd52','edm_hd52@hc360.com','psw52','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd53','edm_hd53@hc360.com','psw53','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd54','edm_hd54@hc360.com','psw54','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd55','edm_hd55@hc360.com','psw55','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd56','edm_hd56@hc360.com','psw56','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd57','edm_hd57@hc360.com','psw57','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd58','edm_hd58@hc360.com','psw58','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd59','edm_hd59@hc360.com','psw59','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd60','edm_hd60@hc360.com','psw60','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd61','edm_hd61@hc360.com','psw61','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd62','edm_hd62@hc360.com','psw62','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd63','edm_hd63@hc360.com','psw63','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd64','edm_hd64@hc360.com','psw64','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd65','edm_hd65@hc360.com','psw65','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd66','edm_hd66@hc360.com','psw66','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd67','edm_hd67@hc360.com','psw67','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd68','edm_hd68@hc360.com','psw68','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd69','edm_hd69@hc360.com','psw69','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd70','edm_hd70@hc360.com','psw70','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd71','edm_hd71@hc360.com','psw71','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd72','edm_hd72@hc360.com','psw72','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd73','edm_hd73@hc360.com','psw73','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd74','edm_hd74@hc360.com','psw74','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd75','edm_hd75@hc360.com','psw75','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd76','edm_hd76@hc360.com','psw76','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd77','edm_hd77@hc360.com','psw77','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd78','edm_hd78@hc360.com','psw78','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd79','edm_hd79@hc360.com','psw79','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd80','edm_hd80@hc360.com','psw80','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd81','edm_hd81@hc360.com','psw81','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd82','edm_hd82@hc360.com','psw82','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd83','edm_hd83@hc360.com','psw83','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd84','edm_hd84@hc360.com','psw84','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd85','edm_hd85@hc360.com','psw85','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd86','edm_hd86@hc360.com','psw86','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd87','edm_hd87@hc360.com','psw87','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd88','edm_hd88@hc360.com','psw88','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd89','edm_hd89@hc360.com','psw89','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd90','edm_hd90@hc360.com','psw90','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd91','edm_hd91@hc360.com','psw91','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd92','edm_hd92@hc360.com','psw92','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd93','edm_hd93@hc360.com','psw93','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd94','edm_hd94@hc360.com','psw94','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd95','edm_hd95@hc360.com','psw95','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd96','edm_hd96@hc360.com','psw96','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd97','edm_hd97@hc360.com','psw97','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd98','edm_hd98@hc360.com','psw98','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));
insert into edm_users(name,email,password,grouptype,dateline) values ('edm_hd99','edm_hd99@hc360.com','psw99','1',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));

/**=====================在cobar server的schema(edm)的root账号下，向水平分区的email_info写入100条数据=============================**/
insert  into email_info(email,num,note) values ('hdedm0@hc360.com',0,'aa');
insert  into email_info(email,num,note) values ('hdedm1@hc360.com',1,'aa');
insert  into email_info(email,num,note) values ('hdedm2@hc360.com',2,'aa');
insert  into email_info(email,num,note) values ('hdedm3@hc360.com',3,'aa');
insert  into email_info(email,num,note) values ('hdedm4@hc360.com',4,'aa');
insert  into email_info(email,num,note) values ('hdedm5@hc360.com',5,'aa');
insert  into email_info(email,num,note) values ('hdedm6@hc360.com',6,'aa');
insert  into email_info(email,num,note) values ('hdedm7@hc360.com',7,'aa');
insert  into email_info(email,num,note) values ('hdedm8@hc360.com',8,'aa');
insert  into email_info(email,num,note) values ('hdedm9@hc360.com',9,'aa');
insert  into email_info(email,num,note) values ('hdedm10@hc360.com',10,'aa');
insert  into email_info(email,num,note) values ('hdedm11@hc360.com',11,'aa');
insert  into email_info(email,num,note) values ('hdedm12@hc360.com',12,'aa');
insert  into email_info(email,num,note) values ('hdedm13@hc360.com',13,'aa');
insert  into email_info(email,num,note) values ('hdedm14@hc360.com',14,'aa');
insert  into email_info(email,num,note) values ('hdedm15@hc360.com',15,'aa');
insert  into email_info(email,num,note) values ('hdedm16@hc360.com',16,'aa');
insert  into email_info(email,num,note) values ('hdedm17@hc360.com',17,'aa');
insert  into email_info(email,num,note) values ('hdedm18@hc360.com',18,'aa');
insert  into email_info(email,num,note) values ('hdedm19@hc360.com',19,'aa');
insert  into email_info(email,num,note) values ('hdedm20@hc360.com',20,'aa');
insert  into email_info(email,num,note) values ('hdedm21@hc360.com',21,'aa');
insert  into email_info(email,num,note) values ('hdedm22@hc360.com',22,'aa');
insert  into email_info(email,num,note) values ('hdedm23@hc360.com',23,'aa');
insert  into email_info(email,num,note) values ('hdedm24@hc360.com',24,'aa');
insert  into email_info(email,num,note) values ('hdedm25@hc360.com',25,'aa');
insert  into email_info(email,num,note) values ('hdedm26@hc360.com',26,'aa');
insert  into email_info(email,num,note) values ('hdedm27@hc360.com',27,'aa');
insert  into email_info(email,num,note) values ('hdedm28@hc360.com',28,'aa');
insert  into email_info(email,num,note) values ('hdedm29@hc360.com',29,'aa');
insert  into email_info(email,num,note) values ('hdedm30@hc360.com',30,'aa');
insert  into email_info(email,num,note) values ('hdedm31@hc360.com',31,'aa');
insert  into email_info(email,num,note) values ('hdedm32@hc360.com',32,'aa');
insert  into email_info(email,num,note) values ('hdedm33@hc360.com',33,'aa');
insert  into email_info(email,num,note) values ('hdedm34@hc360.com',34,'aa');
insert  into email_info(email,num,note) values ('hdedm35@hc360.com',35,'aa');
insert  into email_info(email,num,note) values ('hdedm36@hc360.com',36,'aa');
insert  into email_info(email,num,note) values ('hdedm37@hc360.com',37,'aa');
insert  into email_info(email,num,note) values ('hdedm38@hc360.com',38,'aa');
insert  into email_info(email,num,note) values ('hdedm39@hc360.com',39,'aa');
insert  into email_info(email,num,note) values ('hdedm40@hc360.com',40,'aa');
insert  into email_info(email,num,note) values ('hdedm41@hc360.com',41,'aa');
insert  into email_info(email,num,note) values ('hdedm42@hc360.com',42,'aa');
insert  into email_info(email,num,note) values ('hdedm43@hc360.com',43,'aa');
insert  into email_info(email,num,note) values ('hdedm44@hc360.com',44,'aa');
insert  into email_info(email,num,note) values ('hdedm45@hc360.com',45,'aa');
insert  into email_info(email,num,note) values ('hdedm46@hc360.com',46,'aa');
insert  into email_info(email,num,note) values ('hdedm47@hc360.com',47,'aa');
insert  into email_info(email,num,note) values ('hdedm48@hc360.com',48,'aa');
insert  into email_info(email,num,note) values ('hdedm49@hc360.com',49,'aa');
insert  into email_info(email,num,note) values ('hdedm50@hc360.com',50,'aa');
insert  into email_info(email,num,note) values ('hdedm51@hc360.com',51,'aa');
insert  into email_info(email,num,note) values ('hdedm52@hc360.com',52,'aa');
insert  into email_info(email,num,note) values ('hdedm53@hc360.com',53,'aa');
insert  into email_info(email,num,note) values ('hdedm54@hc360.com',54,'aa');
insert  into email_info(email,num,note) values ('hdedm55@hc360.com',55,'aa');
insert  into email_info(email,num,note) values ('hdedm56@hc360.com',56,'aa');
insert  into email_info(email,num,note) values ('hdedm57@hc360.com',57,'aa');
insert  into email_info(email,num,note) values ('hdedm58@hc360.com',58,'aa');
insert  into email_info(email,num,note) values ('hdedm59@hc360.com',59,'aa');
insert  into email_info(email,num,note) values ('hdedm60@hc360.com',60,'aa');
insert  into email_info(email,num,note) values ('hdedm61@hc360.com',61,'aa');
insert  into email_info(email,num,note) values ('hdedm62@hc360.com',62,'aa');
insert  into email_info(email,num,note) values ('hdedm63@hc360.com',63,'aa');
insert  into email_info(email,num,note) values ('hdedm64@hc360.com',64,'aa');
insert  into email_info(email,num,note) values ('hdedm65@hc360.com',65,'aa');
insert  into email_info(email,num,note) values ('hdedm66@hc360.com',66,'aa');
insert  into email_info(email,num,note) values ('hdedm67@hc360.com',67,'aa');
insert  into email_info(email,num,note) values ('hdedm68@hc360.com',68,'aa');
insert  into email_info(email,num,note) values ('hdedm69@hc360.com',69,'aa');
insert  into email_info(email,num,note) values ('hdedm70@hc360.com',70,'aa');
insert  into email_info(email,num,note) values ('hdedm71@hc360.com',71,'aa');
insert  into email_info(email,num,note) values ('hdedm72@hc360.com',72,'aa');
insert  into email_info(email,num,note) values ('hdedm73@hc360.com',73,'aa');
insert  into email_info(email,num,note) values ('hdedm74@hc360.com',74,'aa');
insert  into email_info(email,num,note) values ('hdedm75@hc360.com',75,'aa');
insert  into email_info(email,num,note) values ('hdedm76@hc360.com',76,'aa');
insert  into email_info(email,num,note) values ('hdedm77@hc360.com',77,'aa');
insert  into email_info(email,num,note) values ('hdedm78@hc360.com',78,'aa');
insert  into email_info(email,num,note) values ('hdedm79@hc360.com',79,'aa');
insert  into email_info(email,num,note) values ('hdedm80@hc360.com',80,'aa');
insert  into email_info(email,num,note) values ('hdedm81@hc360.com',81,'aa');
insert  into email_info(email,num,note) values ('hdedm82@hc360.com',82,'aa');
insert  into email_info(email,num,note) values ('hdedm83@hc360.com',83,'aa');
insert  into email_info(email,num,note) values ('hdedm84@hc360.com',84,'aa');
insert  into email_info(email,num,note) values ('hdedm85@hc360.com',85,'aa');
insert  into email_info(email,num,note) values ('hdedm86@hc360.com',86,'aa');
insert  into email_info(email,num,note) values ('hdedm87@hc360.com',87,'aa');
insert  into email_info(email,num,note) values ('hdedm88@hc360.com',88,'aa');
insert  into email_info(email,num,note) values ('hdedm89@hc360.com',89,'aa');
insert  into email_info(email,num,note) values ('hdedm90@hc360.com',90,'aa');
insert  into email_info(email,num,note) values ('hdedm91@hc360.com',91,'aa');
insert  into email_info(email,num,note) values ('hdedm92@hc360.com',92,'aa');
insert  into email_info(email,num,note) values ('hdedm93@hc360.com',93,'aa');
insert  into email_info(email,num,note) values ('hdedm94@hc360.com',94,'aa');
insert  into email_info(email,num,note) values ('hdedm95@hc360.com',95,'aa');
insert  into email_info(email,num,note) values ('hdedm96@hc360.com',96,'aa');
insert  into email_info(email,num,note) values ('hdedm97@hc360.com',97,'aa');
insert  into email_info(email,num,note) values ('hdedm98@hc360.com',98,'aa');
insert  into email_info(email,num,note) values ('hdedm99@hc360.com',99,'aa');

/**====================在cobar server的schema(edm)的root账号下，对水平分区库email_info_detail写入100条数  据==============================**/
insert  into email_info_detail(email,num_a,num_b) values ('hdedm0@hc360.com',0,0);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm1@hc360.com',1,-1);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm2@hc360.com',2,-2);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm3@hc360.com',3,-3);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm4@hc360.com',4,-4);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm5@hc360.com',5,-5);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm6@hc360.com',6,-6);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm7@hc360.com',7,-7);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm8@hc360.com',8,-8);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm9@hc360.com',9,-9);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm10@hc360.com',10,-10);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm11@hc360.com',11,-11);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm12@hc360.com',12,-12);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm13@hc360.com',13,-13);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm14@hc360.com',14,-14);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm15@hc360.com',15,-15);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm16@hc360.com',16,-16);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm17@hc360.com',17,-17);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm18@hc360.com',18,-18);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm19@hc360.com',19,-19);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm20@hc360.com',20,-20);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm21@hc360.com',21,-21);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm22@hc360.com',22,-22);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm23@hc360.com',23,-23);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm24@hc360.com',24,-24);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm25@hc360.com',25,-25);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm26@hc360.com',26,-26);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm27@hc360.com',27,-27);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm28@hc360.com',28,-28);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm29@hc360.com',29,-29);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm30@hc360.com',30,-30);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm31@hc360.com',31,-31);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm32@hc360.com',32,-32);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm33@hc360.com',33,-33);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm34@hc360.com',34,-34);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm35@hc360.com',35,-35);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm36@hc360.com',36,-36);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm37@hc360.com',37,-37);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm38@hc360.com',38,-38);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm39@hc360.com',39,-39);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm40@hc360.com',40,-40);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm41@hc360.com',41,-41);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm42@hc360.com',42,-42);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm43@hc360.com',43,-43);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm44@hc360.com',44,-44);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm45@hc360.com',45,-45);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm46@hc360.com',46,-46);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm47@hc360.com',47,-47);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm48@hc360.com',48,-48);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm49@hc360.com',49,-49);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm50@hc360.com',50,-50);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm51@hc360.com',51,-51);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm52@hc360.com',52,-52);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm53@hc360.com',53,-53);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm54@hc360.com',54,-54);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm55@hc360.com',55,-55);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm56@hc360.com',56,-56);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm57@hc360.com',57,-57);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm58@hc360.com',58,-58);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm59@hc360.com',59,-59);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm60@hc360.com',60,-60);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm61@hc360.com',61,-61);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm62@hc360.com',62,-62);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm63@hc360.com',63,-63);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm64@hc360.com',64,-64);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm65@hc360.com',65,-65);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm66@hc360.com',66,-66);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm67@hc360.com',67,-67);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm68@hc360.com',68,-68);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm69@hc360.com',69,-69);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm70@hc360.com',70,-70);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm71@hc360.com',71,-71);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm72@hc360.com',72,-72);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm73@hc360.com',73,-73);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm74@hc360.com',74,-74);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm75@hc360.com',75,-75);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm76@hc360.com',76,-76);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm77@hc360.com',77,-77);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm78@hc360.com',78,-78);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm79@hc360.com',79,-79);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm80@hc360.com',80,-80);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm81@hc360.com',81,-81);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm82@hc360.com',82,-82);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm83@hc360.com',83,-83);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm84@hc360.com',84,-84);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm85@hc360.com',85,-85);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm86@hc360.com',86,-86);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm87@hc360.com',87,-87);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm88@hc360.com',88,-88);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm89@hc360.com',89,-89);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm90@hc360.com',90,-90);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm91@hc360.com',91,-91);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm92@hc360.com',92,-92);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm93@hc360.com',93,-93);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm94@hc360.com',94,-94);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm95@hc360.com',95,-95);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm96@hc360.com',96,-96);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm97@hc360.com',97,-97);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm98@hc360.com',98,-98);
insert  into email_info_detail(email,num_a,num_b) values ('hdedm99@hc360.com',99,-99);


/**======================在cobar server的schema(edm)的root账号下，直接修改水平分区表email_info数据============================**/
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm1@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm2@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm3@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm4@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm5@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm6@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm7@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm8@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm9@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm10@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm11@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm12@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm13@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm14@hc360.com';
update email_info ei set ei.num=88888, ei.create_time=now() where ei.email='hdedm15@hc360.com';

/**=======================在cobar server的schema(edm)的root账号下，直接修改水平分区表email_info_detail数据===========================**/
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm1@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm2@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm3@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm4@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm5@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm6@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm7@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm8@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm9@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm10@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm11@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm12@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm13@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm14@hc360.com';
update email_info_detail eid set eid.num_a=88888, eid.create_time=now() where eid.email='hdedm15@hc360.com';


/**=====================创建演示分区数据库，注意不要放到一个数据库上=============================**/
create database if not exists `edmshard1`;
USE `edmshard1`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard2`;
USE `edmshard2`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard3`;
USE `edmshard3`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard4`;
USE `edmshard4`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard5`;
USE `edmshard5`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard6`;
USE `edmshard6`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard7`;
USE `edmshard7`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard8`;
USE `edmshard8`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard9`;
USE `edmshard9`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard10`;
USE `edmshard10`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard11`;
USE `edmshard11`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard12`;
USE `edmshard12`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard13`;
USE `edmshard13`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard14`;
USE `edmshard14`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard15`;
USE `edmshard15`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/
create database if not exists `edmshard16`;
USE `edmshard16`;
DROP TABLE IF EXISTS `email_info`;
CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `email_info_detail`;
CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/**==================================================**/


5、生成测试sql的java类：GenShardSql.java  你可以自己生成测试数据以及测试库了

package com.gen.sql;

public class GenShardSql {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		//通过cobar进行数据展示
		String a="use edm;";
		System.out.println(a);
		
		System.out.println("/**==================================================**/");
		GenShardSql gss=new GenShardSql();
		//清理主库以及分区库
		gss.clearDate();
		
		System.out.println("/**==================================================**/");
		//给主库增加数据
		gss.println_edm_hd(100);
		System.out.println("/**==================================================**/");
		//给分区库增加数据
		gss.println_email_info(100);
		System.out.println("/**==================================================**/");
		
		gss.println_email_info_detail(100);
		System.out.println("/**==================================================**/");
		//修改数据
		gss.modifyEmailData(1, 16, 88888);
		
		//初始化分区库
		gss.initdb(1, 16);

	}
	
	public void clearDate(){
		//清理主库
		String del="delete from edm_users;";
		System.out.println(del);
		
		//清理分区库
		del="delete from email_info;";
		System.out.println(del);
		//清理分区库
		del="delete from email_info_detail;";
		System.out.println(del);
	}
	
	public void println_email_info(int num){
		String a="";
		for(int i=0;i<num;i++){
			a="insert  into email_info(email,num,note) values (\'hdedm"+i+"@hc360.com\',"+i+",\'aa\');";
			System.out.println(a);
		}
	}
	
	public void println_email_info_detail(int num){
		String b="";
		for(int i=0;i<num;i++){
			b="insert  into email_info_detail(email,num_a,num_b) values ('hdedm"+i+"@hc360.com',"+i+","+-i+");";
			System.out.println(b);
		}
	}
	
	
	public void println_edm_hd(int num){
		String a="use edm;";
		System.out.println(a);
		String b="";
		for(int i=0;i<num;i++){
			 b="insert into edm_users(name,email,password,grouptype,dateline) values (\'edm_hd"+i+"\',\'edm_hd"+i+"@hc360.com\',\'psw"+i+"\',\'1\',UNIX_TIMESTAMP(CURRENT_TIMESTAMP));";
			 System.out.println(b);
		}
		
		
	}
	/**初始化分区DB*/
	public void initdb(int start,int end){
		for(int i=start;i<=end;i++){
			String create="create database if not exists `edmshard"+i+"`;";
			String use="USE `edmshard"+i+"`;";
			String drop1="DROP TABLE IF EXISTS `email_info`;";
			String c_t1="CREATE TABLE `email_info` (  `email` varchar(300) CHARACTER SET utf8 DEFAULT NULL, `num` int(10) DEFAULT NULL,  `note` varchar(500) CHARACTER SET utf8 DEFAULT NULL,`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
		
			String drop2="DROP TABLE IF EXISTS `email_info_detail`;";
			String c_t2="CREATE TABLE `email_info_detail` (  `email` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,  `num_a` int(10) DEFAULT 0,  `num_b` int(10) DEFAULT 0,  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
		
		
			System.out.println(create);
			System.out.println(use);
			System.out.println(drop1);
			System.out.println(c_t1);
			System.out.println(drop2);
			System.out.println(c_t2);
			
			System.out.println("/**==================================================**/");
		}

	}
	

	/**
	 * 根据邮箱更改某个分区的数据
	 * */
	public void modifyEmailData(int start,int end,int val){
		String ms="";
		for(int i=start;i<end;i++){
			ms="update email_info ei set ei.num="+val+", ei.create_time=now() where ei.email=\'hdedm"+i+"@hc360.com\';";
			System.out.println(ms);
		}
		System.out.println("/**==================================================**/");
		for(int i=start;i<end;i++){
			ms="update email_info_detail eid set eid.num_a="+val+", eid.create_time=now() where eid.email=\'hdedm"+i+"@hc360.com\';";
			System.out.println(ms);
		}
		System.out.println("/**==================================================**/");
	} 
}


转载于:https://my.oschina.net/abcijkxyz/blog/722133

chuifuhuo6864
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
阿里巴巴分布式数据库解决方案 cobar讲解
04-03
阿里巴巴分布式数据库实现原理、方案、应用，目前垮库还有较多限制，但是可以留意学习，等待他的完善，也可以学习它的原理，很有收获的
阿里巴巴　分布式数据库　Cobar
12-19
阿里巴巴　分布式数据库　Cobar． 数据库访问代理 水平分区工具．
用cobar搭建分布式数据库 .
张伟的专栏
07-30 4241
周末针对最新的项目需求进行cobar的搭建并针对实际状况做了demo演示 一、需求 1、大数据量，邮件发送记录需要记录，一年可能累计4亿的数据 2、需要按照邮箱进行邮件发送明细的查询以及发送记录的查询 二、问题 1、单库分表分区已经解决不了存储以及查询问题 2、只能进行一致性hash的策略进行数据存储以及查询，放弃了一些便利性查询统计 三、实施方案，数据库采用mysq
Cobar介绍及配置
weixin_33970449的博客
09-25 324
from：http://code.alibabatech.com/wiki/display/cobar/Home Skip to end of metadata   Page restrictions apply Attachments:1 Added by kimi Lv, last e...
cobar
xyz的博客
07-05 2156
Cobar是基于MySQL的分布式数据库服务中间件，它可以让传统的数据库得到良好的线性扩展，并看上去还是一个数据库,对应用保持透明。 产品在阿里巴巴稳定运行3年以上。 接管了3000+个MySQL数据库的schema。 集群日处理在线SQL请求50亿次以上。 集群日处理在线数据流量TB级别以上。 官方Github地址：https://github.com/alibaba/cobar C...
阿里数据库中间件Cobar环境搭建
weixin_30826095的博客
12-03 109
装了CentOS7，结果死活连不上网，一直提示没有可用的网络设备，没工夫处理，以后再说，先用之前装好的CentOS6.4，Mysql安装包又下不下来，只好翻出了之前玩Storm装的Archlinux，总共有Alpha、Beta、Delta三台虚机，里头安装了JDK、MariaDB等等。 准备 测试中有一个schema，两张表tb1、tb2，其中tb1在一个库，tb2分为两个库。 几个Cobar的...
cobar分布式数据存储系统cobar-server解析
csdn5215的博客
09-19 559
启动cobar组件服务： 1、执行startup.sh脚本，加载schema.xml，rule.xml，server.xml文件， 2、执行CobarStartup.class 一、解析startup.sh 1、判断JAVA_HOME是否存在，不存在报错 2、设置JAVA_OPTS（JVM相关运行参数的变量，即java虚拟机内存设置）， 3、开始启动
分布式数据库架构及企业实践-基于Mycat中间件
02-14
基于阿里开源的Cobar产品而研发，Cobar的稳定性、可靠性、优秀的架构和性能以及众多成熟的使用案例使得MYCAT一开始就拥有一个很好的起点，站在巨人的肩膀上，我们能看到更远。业界优秀的开源项目和创新思路被广泛...
分布式数据库架构及企业实践——基于Mycat中间件
04-25
为了解决传统数据库的分布式化这个技术难题，各种数据库中间件应运而生，从早期的Amoeba、TDDL、Cobar，到如今的Mycat，技术日新月异，发展迅猛。Mycat已经成为了一个强大的开源分布式数据库中间件产品。面对企业...
阿里巴巴分布式数据库 ——原理、实现和应用
10-15
阿里巴巴分布式数据库 ——原理、实现和应用 Cobar Solution
分布式数据库cobar
u012082367的专栏
12-02 208
     在实际的项目接触中，或多或少的都能听到一些分布式数据库，时间久了，就想着自己也学习一下 阿里的cobar算是分布式数据库中间件中比较常用的了   首先我们在github下载cobar 下载好之后发现里面只有java文件，开始的时候我直接在bin里面点startup 出错，其实  这时候我们需要给它编译，在idea里面 clean install   编译之后有一个coba...
cobar mysql5.6_Cobar分布式数据库的应用与实践
weixin_31211821的博客
01-21 87
2. 安装：1). Cobar是基于Java开发的分布式数据库应用，所以安装Cobar首先要安装JAVA JRE。2). 解压，拷贝过去，运行startup.sh即可。3.配置：1)Server.xml 服务器配置mysqldata_acquisition_server连接用户名、密码配置，客户端连接登入验证。schemas 主要对应schema.xml的定义。2) Schema.xml 数据节...
[存储] Cobar使用文档（可用作MySQL大型集群解决方案）
热门推荐
石头君专栏
11-19 4万+
最近好不容易抽空研究了下Cobar，感觉这个产品确实很不错（在文档方面比Amoeba强多了），特此推荐给大家。Cobar是阿里巴巴研发的关系型数据的分布式处理系统，该产品成功替代了原先基于Oracle的数据存储方案，目前已经接管了3000+个MySQL数据库的schema，平均每天处理近50亿次的SQL执行请求。首先，使用Cobar的核心功能如下：分布式：Cobar的分布式主要是通过将表放入不同的
cobar学习总结
csdn5215的博客
09-19 611
阿里开源mysql分布式中间件 cobar源码下载地址：https://github.com/alibaba/cobar 概念： Cobar是阿里巴巴研发的关系型数据的分布式处理系统（Amoeba的升级版，该产品成功替代了原先基于Oracle的数据存储方 案，目前已经接管了3000+个MySQL数据库的schema，平均每天处理近50亿次的SQL执行请求。）（github上面的是
java cobra_java实现CORBA
weixin_32161697的博客
02-16 332
1.利用CORBA实现数据的访问，也就是通过客户端的代码，访问服务器端的代码。首先是定义一个idl文件，里面的主要类型就是定义一个接口，类容如下：2.然后利用idlj –fall DataService.idl 命令来编译idl文件，编译后得到了许多的java文件，文件如下所示：再然后，在该文件中建立一个Server文件夹，然后将生成的文件放入，并且建立一个java功能，作...
cobar搭建的简单例子
kk791159796的专栏
04-01 2284
cobar下载地址：https://github.com/alibaba/cobar 下载好了的代码是没有.project文件的，只有java文件，如果你直接运行cobar-master\server\assembly\bin目录下的startup.bat是不会成功的，应该缺少lib文件以及class文件。在MyEclipse中以maven项目形式导入，然后Update Dependencies
数据库中间件cobar调研笔记
shenjian58的博客
11-15 438
13年底负责数据库中间件设计时的调研笔记，拿出来和大家分享，轻拍。文章很长，可提前收藏，转发。一，cobar是什么阿里开源的mysql的中间件服务使用mysql协议对上游...
Cobar部署与测试
linuxlsq的博客
09-21 570
原文出自  http://www.abcdocker.com/abcdocker/84 Cobar部署与测试 一、Cobar介绍 1.1功能概述： Cobar是关系型数据的分布式处理系统，它可以在分布式的环境下看上去像传统数据库一样为您提供海量数据服务。 1.1.1 Cobar核心功能： Ø  分布式：Cobar的分布式主要是通过将表放入不同的库来实现： 1. Cobar支持将一
【redis的基本数据类型】
最新发布
m0_50116974的博客
06-13 594
压缩列表的基本信息包括压缩列表的大小，压缩列表的长度以及最后一个entry的偏移，之所以要有这个偏移，是为了找到最后一个entry,而每个entry都记录上一个元素的大小，通过计算就知道上一个entry的地址，这样方便的从后向前进行遍历。的结构，其分为两部分，8字节的Redis对象元数据信息，8字节的指针，其中Redis对象的元数据信息存储了类型的LRU信息，真正的编码格式等等，而如果字符串存储的是数字类型，则复用了8字节的指针的位置。的操作，但是当列表的元素非常少的时候，其内部使用。
数据库分库分表常用的框架
06-06
4. Cobar：Cobar 是阿里巴巴推出的分布式数据库中间件，提供分库分表、读写分离等功能。 5. Vitess：Vitess 是 YouTube 推出的分布式数据库中间件，提供分库分表、数据分片等功能。 这些框架都可以帮助开发者轻松...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值