详解 Mycat 2 分库分表（一）绑定资源

# drop old table, and delete old data record drop table if exists db_not_tb__city; delete from mycat_sequence where name = 'sharding_db_not_tb__city'; # create sequence.json # 故意创建一个矛盾的由 MySQL 生辰的序列 # 其实没必要，使用 MySQL 生成序列时，感觉 Mycat 不会创建、维护全局序列，需要数据库设计者自行设计。 insert into mycat_sequence values('sharding_db_not_tb__city',0,1); /*+ mycat:setSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; # 会报错，不支持 # drop sequence sharding_db_not_tb111; /*+ mycat:setSequence{"name":"sharding_db_not_tb__city","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; /*+ mycat:dropSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; # create table and insert data /*+ mycat:createTable{ "schemaName":"sharding",# drop old table, and delete old data record drop table if exists db_not_tb__city; delete from mycat_sequence where name = 'sharding_db_not_tb__city'; # create sequence.json # 故意创建一个矛盾的由 MySQL 生辰的序列 # 其实没必要，使用 MySQL 生成序列时，感觉 Mycat 不会创建、维护全局序列，需要数据库设计者自行设计。 insert into mycat_sequence values('sharding_db_not_tb__city',0,1); /*+ mycat:setSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; # 会报错，不支持 # drop sequence sharding_db_not_tb111; /*+ mycat:setSequence{"name":"sharding_db_not_tb__city","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; /*+ mycat:dropSequence{"name":"sharding_db_not_tb111","clazz":"io.mycat.plug.sequence.SequenceMySQLGenerator"} */; # create table and insert data /*+ mycat:createTable{ "schemaName":"sharding", "shardingTable":{ "createTableSQL":"create table db_not_tb__city(id int auto_increment primary key,name varchar(10),city varchar(10)) dbpartition by MOD_HASH(city) dbpartitions 2", "function":{ "properties":{ "dbNum":2, "dbMethod":"mod_hash(city)", "mappingFormat":"cls${targetIndex}/sharding/db_not_tb__city", "storeNum":2 } } }, "tableName":"db_not_tb__city" } */; insert into db_not_tb__city(name,city) values('a','sh'),('b','sh'),('c','bj'),('d','sh'),('e','sz'),('f','bj'),('g','bj'),('h','sz'); # check data select t.*,@@hostname from db_not_tb__city t order by id;