Centos7 搭建Mysql8.0主从参考

Mycat官网

安装过程

1、上传Centos7解压

命令： # tar -zxvf Mycat-server-1.6.7.3-release-20190828135747-linux.tar.gz

2、把解压后的文件全部移动到/usr/local

命令： # mv mycat /usr/local

3、配置mycat实现读写分离

修改mycat的server.xml
命令： # cd /usr/local/mycat/conf/
# vim server.xml

<user name="root" defaultAccount="true">
                <property name="password">Captain@1688</property>
                <property name="schemas">MYCAPDB</property>

                <!-- 表级 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="cpatainRead">
                <property name="password">Captain@1688</property>
                <property name="schemas">MYCAPDB</property>
                <property name="readOnly">true</property>
        </user>

修改 schema.xml，在最后增加以下内容

命令： # vim schema.xml

       <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
    <!-- 这里不配置，代表所有的表分片到dn1节点-->
    </schema>
    <dataNode name="dn1" dataHost="dataHost01" database="test" />
    <dataHost name="dataHost01" maxCon="1000" minCon="10" balance="1"
    writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
    <heartbeat>select user()</heartbeat>
    <!-- can have multi write hosts -->
        <writeHost host="mysql_b1" url="207.133.93.72:3306" user="captainLii" password="Captain@1689">
            <!-- can have multi read hosts -->
            <readHost host="mysql_b2" url="45.32.233.84:3306" user="captainLii" password="Captain@1689" />
        </writeHost>
    </dataHost>