Shulou(Shulou.com)05/31 Report--

This article mainly introduces the "MyCat sub-database sub-table example tutorial", in the daily operation, I believe that many people have doubts on the MyCat sub-database sub-table example tutorial, the editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods, hoping to help you answer the "MyCat sub-database sub-table example tutorial"! Next, please follow the editor to study!

Project environment:

192.168.8.30 mycat

192.168.8.31 node1

192.168.8.32 node2

192.168.8.33 node3

The MySQL of three nodes is a single instance.

First, create a test library

Node1

Create database testdb01;create database testdb02;create database testdb03;create database testdb04;create database testdb05;create database testdb06;create database testdb07;create database testdb08;create database testdb09;create database testdb10;create database testdb11;create database testdb12

Node2

Create database testdb13;create database testdb14;create database testdb15;create database testdb16;create database testdb17;create database testdb18;create database testdb19;create database testdb20;create database testdb21;create database testdb22;create database testdb23;create database testdb24

Node3

Create database testdb25;create database testdb26;create database testdb27;create database testdb28;create database testdb29;create database testdb30;create database testdb31;create database testdb32;create database testdb33;create database testdb34;create database testdb35;create database testdb36

2. Configure schema.xml

Select user () select user () select user ()

3. Configure rule.xml

Adddate partbymonth yyyy-MM-dd 2016-01-01

4. Start mycat

/ usr/local/mycat/bin/mycat start

View mycat Log

STATUS | wrapper | 19:52:42 on 2018-11-22 |-- > Wrapper Started as DaemonSTATUS | wrapper | 19:52:42 on 2018-11-22 | Launching a JVM...INFO | jvm 1 | 19:52:42 on 2018-11-22 | OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=64M Support was removed in 8.0INFO | jvm 1 | 19:52:44 on 2018-11-22 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.orgINFO | jvm 1 | 19:52:44 on 2018-11-22 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.INFO | jvm 1 | 19:52:44 on 2018-11-22 | INFO | jvm 1 | 19:52:49 on 2018-11-22 | MyCAT Server startup successfully. See logs in logs/mycat.log

Log in to MySQL to view the logic table

Mysql-uroot-pmysql-P8066-h292.168.8.30mysql > show databases;+-+ | DATABASE | +-+ | mycatdb | +-+ 1 row in set (0.03 sec) mysql > use mycatdb;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedmysql > show tables +-+ | Tables in mycatdb | +-+ | user04 | | user05 | | user06 | +-+ 3 rows in set (0.01sec) mysql > select * from user06;ERROR 1105 (HY000): Table 'testdb36.user06' doesn't existmysql > drop table if exists user06 Query OK, 0 rows affected, 1 warning (0.38 sec) mysql > create table user06 (- > id int not null auto_increment,-> name varchar (64),-> adddate datetime,-> primary key (id)->); Query OK, 0 rows affected (1.73 sec)

Insert test data

Insert into user06 (id,name,adddate) values; insert into user06 (id,name,adddate) values Insert into user06 (id,name,adddate) values; values, 2018-05-09; insert into user06 (id,name,adddate) values. Insert into user06 (id,name,adddate) values (2009-08-09, 2018-08-09, 2018-08-09, 12); insert into user06 (id,name,adddate) values (10).

7. Validate data

Node1

Mysql > select * from testdb01.user06;Empty set (0.00 sec) mysql > select * from testdb02.user06;Empty set (0.00 sec) mysql > select * from testdb03.user06;Empty set (0.00 sec) mysql > select * from testdb04.user06;Empty set (0.01 sec) mysql > select * from testdb05.user06 +-+ | id | name | adddate | +-+ | 1 | steven | 2016-05-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) mysql > select * from testdb06.user06 Empty set (0.01 sec) mysql > select * from testdb07.user06;Empty set (0.01 sec) mysql > select * from testdb08.user06;Empty set (0.01 sec) mysql > select * from testdb09.user06 +-+ | id | name | adddate | +-+ | 2 | steven | 2016-09-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) mysql > select * from testdb10.user06 Empty set (0.00 sec) mysql > select * from testdb11.user06;Empty set (0.00 sec) mysql > select * from testdb12.user06 +-+ | id | name | adddate | +-+ | 3 | steven | 2016-12-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec)

Node2

Mysql > select * from testdb13.user06;Empty set (0.00 sec) mysql > select * from testdb14.user06;Empty set (0.00 sec) mysql > select * from testdb15.user06;Empty set (0.00 sec) mysql > select * from testdb16.user06;Empty set (0.00 sec) mysql > select * from testdb17.user06 +-+ | id | name | adddate | +-+ | 4 | steven | 2017-05-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) mysql > select * from testdb18.user06 +-+ | id | name | adddate | +-+ | 5 | steven | 2017-06-09 12:32:12 | +-+-- -+ 1 row in set (0.01sec) mysql > select * from testdb19.user06 +-+ | id | name | adddate | +-+ | 6 | steven | 2017-07-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) mysql > select * from testdb20.user06 Empty set (0.01 sec) mysql > select * from testdb21.user06;Empty set (0.00 sec) mysql > select * from testdb22.user06;Empty set (0.00 sec) mysql > select * from testdb23.user06;Empty set (0.00 sec) mysql > select * from testdb24.user06;Empty set (0.01 sec)

Node3

Mysql > select * from testdb25.user06;Empty set (0.00 sec) mysql > select * from testdb26.user06;Empty set (0.00 sec) mysql > select * from testdb27.user06;Empty set (0.00 sec) mysql > select * from testdb28.user06;Empty set (0.01 sec) mysql > select * from testdb29.user06 +-+ | id | name | adddate | +-+ | 7 | steven | 2018-05-09 12:32:12 | | 8 | steven | 2018-05-09 12:32:12 | + +-+-+ 2 rows in set (0.00 sec) mysql > select * from testdb30.user06 Empty set (0.01sec) mysql > select * from testdb31.user06;Empty set (0.01sec) mysql > select * from testdb32.user06 +-+ | id | name | adddate | +-+ | 9 | steven | 2018-08-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) mysql > select * from testdb33.user06 Empty set (0.00 sec) mysql > select * from testdb34.user06;Empty set (0.01 sec) mysql > select * from testdb35.user06;Empty set (0.01 sec) mysql > select * from testdb36.user06 +-+ | id | name | adddate | +-+ | 10 | steven | 2018-12-09 12:32:12 | +-+-- -+ 1 row in set (0.00 sec) so far On the "MyCat sub-database sub-table example tutorial" is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.