MyCat sub-library sub-table-- actual combat 03muri-global table
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.
1. Configure schema.xml
Select user () select user () select user ()
2. Configure server.xml
Mysql mycatdb
Third, create a test library
Node1
Create database testdb01;create database testdb02;create database testdb03
Node2
Create database testdb13;create database testdb14;create database testdb15
Node3
Create database testdb25;create database testdb26;create database testdb27
4. Start mycat
/ usr/local/mycat/bin/mycat start
View mycat Log
STATUS | wrapper | 10:58:17 on 2018-11-22 |-- > Wrapper Started as DaemonSTATUS | wrapper | 10:58:18 on 2018-11-22 | Launching a JVM...INFO | jvm 1 | 10:58:18 on 2018-11-22 | OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=64M Support was removed in 8.0INFO | jvm 1 | 10:58:20 on 2018-11-22 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.orgINFO | jvm 1 | 10:58:20 on 2018-11-22 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.INFO | jvm 1 | 10:58:20 on 2018-11-22 | INFO | jvm 1 | 10:58:24 on 2018-11-22 | MyCAT Server startup successfully. See logs in logs/mycat.log
Log in to MySQL to view the global table
Mysql-uroot-pmysql-P8066-h292.168.8.30mysql > use mycatdbReading 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 | +-+ | user01 | | user02 | +-+ 2 rows in set (sec) mysql > drop table user02;ERROR 1105 (HY000): Unknown table 'testdb11.user02'mysql > select * from user02 ERROR 1146 (HY000): Table 'testdb01.user02' doesn't existmysql > drop table if exists user02;Query OK, 0 rows affected, 1 warning (0.40 sec
Create a table user02 and insert three records
Mysql > create table user02 (- > id INT (10) NOT NULL AUTO_INCREMENT,-> name varchar (30),-> PRIMARY KEY (id)->); Query OK, 0 rows affected (1.74 sec) mysql > insert into user02 (name) values ('steven'); Query OK, 1 row affected (0.29 sec) mysql > insert into user02 (name) values (' steven'); Query OK, 1 row affected (0.33 sec) mysql > insert into user02 (name) values ('steven') Query OK, 1 row affected (0.31 sec)
VI. Data verification
Node1
Mysql > select * from testdb01.user02;+----+-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+ 3 rows in set (0.00 sec) mysql > select * from testdb05.user02 +-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+-- + 3 rows in set (0.01sec) mysql > select * from testdb12.user02 +-+-- +-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+-+ 3 rows in set (0.00 sec)
Node2
Mysql > select * from testdb16.user02;+----+-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+ 3 rows in set (0.00 sec) mysql > select * from testdb19.user02 +-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+ 3 rows in set (0.00 sec) mysql > select * from testdb22.user02 +-+-- +-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+-+ 3 rows in set (0.00 sec)
Node3
Mysql > select * from testdb25.user02;+----+-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+ 3 rows in set (0.00 sec) mysql > select * from testdb30.user02 +-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+ 3 rows in set (0.00 sec) mysql > select * from testdb33.user02 +-+-+ | id | name | +-+-+ | 1 | steven | | 2 | steven | | 3 | steven | +-+-+
You can see that the data stored in each node is exactly the same for each database, and the global table is validated.
