betterjava commented on issue #2931: MasterSlave can not work well URL: https://github.com/apache/incubator-shardingsphere/issues/2931#issuecomment-526985351 Here is the sql for craete table. CREATE TABLE `user_0` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `ex_id` int(11) DEFAULT NULL, `pre_name` varchar(100) DEFAULT NULL, `name_assisted` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `user_1` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `ex_id` int(11) DEFAULT NULL, `pre_name` varchar(100) DEFAULT NULL, `name_assisted` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE DATABASE IF NOT EXISTS demo_ds_master_0 default charset utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS demo_ds_master_0_slave_0 default charset utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS demo_ds_master_0_slave_1 default charset utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS demo_ds_master_1 default charset utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS demo_ds_master_1_slave_0 default charset utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS demo_ds_master_1_slave_1 default charset utf8 COLLATE utf8_general_ci;
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
