mysql+mycat实现读写分离
centos7master
slave
mycat1.6
client
192.168.41.10
192.168.41.11
192.168.41.12
192.168.41.13 实验环境关闭自己的防火墙
配置所有主机hosts文件：
1、master（41.10）：
vim /etc/my.cnf
systemctl restart mysqld\重启服务读取配置文件参数
1)配置复制用户以及root用户权限
2、slave（41.11）
配置/etc/my.cnf配置文件
systemctl restart mysqld
mysql> change master to master_host='192.168.41.10',master_user='myslave',master_password='123.com',master_log_file='mysql-bin.000002',master_log_pos=1334;
mysql> start slave ;
mysql> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
mysql> grant all on . to root@'%' > mysql> flush privileges;
回到master主机创建test库
mysql> create database test;
3、配置mycat（41.12）
1）部署mycat
wget http://dl.mycat.io/1.6-RELEASE/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz
# tar zxf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local
2）加载环境变量
# vi /etc/profile
.....
export PATH=$PATH:/usr/local/java/bin
export JAVA_HOME=/usr/local/java
export MYCAT_HOME=/usr/local/mycat
export PATH=$PATH:/usr/local/mycat/bin
# source /etc/profile
3）配置serve.xml
# cd /usr/local/mycat/conf/
# vim server.xml
......
123.com
test
<!-- 表级 DML 权限设置 --> <!--
<privileges check="false">
<schema name="TESTDB" dml="0110" >
<table name="tb01" dml="0000"></table>
<table name="tb02" dml="1111"></table>
</schema>
</privileges>
-->
</user>
<user name="user">
<property name="password">user</property>
<property name="schemas">test</property>
<property name="readOnly">true</property>
</user>
4）配置schema.xml
# vim schema.xml
页:
[1]