MyCat sub-library sub-table-actual combat 01-vertical sub-library

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 test data

Node1

Create database testdb1;create table testdb1.t01 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb1.t01 values (@ @ hostname,@@hostname,@@hostname); create database testdb2;create table testdb2.t02 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb2.t02 values (@ @ hostname,@@hostname,@@hostname); create database testdb3;create table testdb3.t03 (name1 varchar (40), name2 varchar (40), name3 varchar (40)) Insert into testdb3.t03 values (@ @ hostname,@@hostname,@@hostname)

Node2

Create database testdb4;create table testdb4.t04 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb4.t04 values (@ @ hostname,@@hostname,@@hostname); create database testdb5;create table testdb5.t05 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb5.t05 values (@ @ hostname,@@hostname,@@hostname); create database testdb6;create table testdb6.t06 (name1 varchar (40), name2 varchar (40), name3 varchar (40)) Insert into testdb6.t06 values (@ @ hostname,@@hostname,@@hostname)

Node3

Create database testdb7;create table testdb7.t07 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb7.t07 values (@ @ hostname,@@hostname,@@hostname); create database testdb8;create table testdb8.t08 (name1 varchar (40), name2 varchar (40), name3 varchar (40)); insert into testdb8.t08 values (@ @ hostname,@@hostname,@@hostname); create database testdb9;create table testdb9.t09 (name1 varchar (40), name2 varchar (40), name3 varchar (40)) Insert into testdb9.t09 values (@ @ hostname,@@hostname,@@hostname)

2. Configure schema.xml

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

3. Configure server.xml

Mysql mycatdb1,mycatdb2,mycatdb3,mycatdb4,mycatdb5,mycatdb6,mycatdb7,mycatdb8,mycatdb9

4. Start mycat

/ usr/local/mycat/bin/mycat start

View mycat Log

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

Access port 8066 to view data

[root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb1.t01" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | node1 | node1 | node1 | +-- -+-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb2.t02" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | Node1 | node1 | node1 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb3.t03" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +- -+-+ | node1 | node1 | node1 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb4.t04" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | Name1 | name2 | name3 | +-+ | node2 | node2 | node2 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb5.t05" mysql: [Warning] Using a password on the command line interface can be insecure.+-+- -+-+ | name1 | name2 | name3 | +-+ | node2 | node2 | node2 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb6.t06" mysql: [Warning] Using a password on the command line Interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | node2 | node2 | node2 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.8.30-e "select * from mycatdb7. T07 "mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | node3 | node3 | node3 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066- H292.168.8.30-e "select * from mycatdb8.t08" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | node3 | node3 | node3 | +-+ [root@mycat conf] # mysql-uroot-pmysql-P8066-h292.168.30-e "select * from mycatdb9.t09" mysql: [Warning] Using a password on the command line interface can be insecure.+-+ | name1 | name2 | name3 | +-+ | node3 | node3 | node3 | +-- -+

The data view is normal, and nine libraries are distributed on three machines.