MyCat搭建读写分离一主一从

• MyCat安装和连接（详见以下博文）

https://blog.csdn.net/sinat_33422489/article/details/107260244

• 配置MySQL主从复制（详见以下博文）

https://blog.csdn.net/sinat_33422489/article/details/107281604

• 配置mycat用户名和逻辑库，修改conf/server.xml

# name 用户
# defaultAccount 默认账户
# password 密码
# schemas 逻辑库名称
# defaultSchema  默认逻辑库

<user name="mycat" defaultAccount="true">  
    <property name="password">12345678</property>
    <property name="schemas">TESTDB</property>
    <property name="defaultSchema">TESTDB</property>
</user>

• 修改conf/schema.xml配置mycat逻辑库和读写分离配置

  schema.xml配置详解https://blog.csdn.net/sinat_33422489/article/details/106948948

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
    <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
    </schema>
    <dataNode name="dn1" dataHost="host1" database="dbname" />
    <dataHost name="host1" maxCon="1000" minCon="10" balance="3"
                      writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
            <heartbeat>select user()</heartbeat>
            <!-- can have multi write hosts -->
            <writeHost host="hostM1" url="192.168.0.140:3306" user="root"
                               password="123456">
                    <!-- can have multi read hosts -->
                    <readHost host="hostS1" url="192.168.0.141:3306" user="shop" password="123456" />
            </writeHost>
    </dataHost>
</mycat:schema>

• 重启mycat验证读写分离是否成功