mycat安装

1.下载mycat

下载地址为：http://dl.mycat.org.cn/1.6.7.5/2020-4-10/

2.安装

2.1解压

cd /usr/local
tar -zxvf Mycat-server-1.6.7.3-release-20190828135747-linux.tar.gz

2.2 配置环境变量

vi /etc/profile
MYCAT_HOME=/usr/local/mycat

source /etc/profile

3.配置

cd /usr/local/mycat/conf

3.1 server.xml

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

3.2 schema.xml

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
        </schema>
        <dataNode name="dn1" dataHost="host1" database="test" />
        <dataHost name="host1" maxCon="1000" minCon="10" balance="1"
                          writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
                <heartbeat>select user()</heartbeat>
                <writeHost host="hostM1" url="192.168.41.75:3306" user="root"
                                   password="123456">
                        <readHost host="hostS1" url="192.168.41.76:3306" user="root" password="123456"></readHost>
                </writeHost>
        </dataHost>

​ 1、balance=0 :不开启读写分离机制，所有读操作都发送到当前可用的writehost上

​ 2、balance=1:全部的readhost和stand by writehost参与select 语句的负载均衡，简单的说，当双主双从模式下，其他的节点都参与select语句的负载均衡

​ 3、balance=2:所有读操作都随机的在writehost，readhost上分发

​ 4、balance=3:所有读请求随机的分发到readhost执行，writehost不负担读压力

4.启动

mycat console