mycat学习

1.下载mycat : http://dl.mycat.io/1.6.5/
按照jdk : linux安装jdk8
2.解压

tar -zxvf Mycat-server-1.6.5-release-20180122220033-linux.tar.gz

3.移动或拷贝mycat文件夹到 /usr/local下

mv mycat /usr/local/mycat

4.创建组和用户

groupadd mycat
adduser -r -g mycat mycat
chown -R mycat.mycat /usr/local/mycat

5.修改配置文件 先让mycat能连接到mysql(分片,读写分离等后续…)

vi conf/schema.xml 
#修改此处
<writeHost host="hostM1" url="localhost:3306" user="root" password="root">
        <readHost host="hostS2" url="localhost:3306" user="root" password="root" />
</writeHost>

mysql默认是没有密码的,设置密码

[root@localhost mycat]# mysqladmin -uroot -p password

6.修改配置conf/server.xml

<user name="root" defaultAccount="true">
                <property name="password">123456</property>
                <property name="schemas">TESTDB</property>
.....
</user>

7.连接mycat

[root@localhost mycat]# mysql -uroot -p123456 -h127.0.0.1 -P8066 -DTESTDB

8.测试
先连接mysql创建测试库db1,db2,db3
CREATE database db1;

mysql> show databases;
+------------------------+
| Database               |
+------------------------+
| information_schema     |
| bin                    |
| data                   |
| db1                    |
| db2                    |
| db3                    |
| docs                   |
| include                |
| lib                    |
| man                    |
| mysql                  |
| #mysql50#mysql-test    |
| performance_schema     |
| scripts                |
| share                  |
| #mysql50#sql-bench     |
| #mysql50#support-files |
| test                   |
+------------------------+
18 rows in set (0.00 sec)

mysql> 

连接mycat:

[root@localhost mycat]# mysql -uroot -p123456 -h127.0.0.1 -P8066 -DTESTDB

创建一张测试表退出mycat,然后连接mysql查看db1,2,3库中都有测试表.