MYSQL 分表测试

来源：互联网发布：紫微排盘详批软件编辑：程序博客网时间：2024/04/29 13:08

因为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()) ;

真实的mysql 数据,请去查看

192.168.168.243

user : root

pwd :123456

port: 3066 ,

阅读全文

0 0