因为MYSQL需要5.5以上,所以在192.168.168.243上单独装了一个MYSQL
Mycat 数据库分库分表中间件
192.168.168.243
user : root
pwd :123456
port: 8066
1.schema.xml 定义tabe
2.rule.xml 定义 规则
测试SQL
DROP TABLE cct_dba_cct_memberbymobile
CREATE TABLE cct_dba_cct_memberbymobile
(
MEMB_MOBILE bigint,
MEMB_ID VARCHAR (36)
)
SELECT * FROM cct_dba_cct_memberbymobile
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(1, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(2, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(3, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(4, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(5, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(6, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(7, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(8, uuid()) ;
CREATE TABLE cct_dba_cct_memberbymobile
(
MEMB_MOBILE bigint,
MEMB_ID VARCHAR (36)
)
SELECT * FROM cct_dba_cct_memberbymobile
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(1, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(2, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(3, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(4, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(5, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(6, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(7, uuid()) ;
INSERT INTO cct_dba_cct_memberbymobile(MEMB_MOBILE,MEMB_ID) VALUES(8, uuid()) ;
真实的mysql 数据,请去查看
192.168.168.243
user : root
pwd :123456
port: 3066 ,