Centos7安装Mycat

1、101和102分别安装mysql

centos7安装mysql网址：

CentOS7安装MySql5.7完整教程_长头发的程序猿的博客-CSDN博客_centos7 mysql5.7安装

2、解压安装包

cd /opt

tar -zxvf Mycat-server-1.6.7.1-release-20190627191042-linux.tar.gz

cp -r mycat /usr/local/

cd /usr/local/mycat/conf/

3、修改“server.xml”

vim server.xml

修改name=“mycat”：

4、修改“schema.xml”

vim schema.xml

模板：

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"></schema>
<dataNode name="dn1" dataHost="host1" database="testdb" />
<dataHost name="host1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
 	<heartbeat>select user()</heartbeat>
 	<!-- can have multi write hosts -->
 	<writeHost host="hostM1" url=":3306" user="root" password="">
 		<!-- can have multi read hosts -->
	 	<readHost host="hostS1" url=":3306" user="root" password="" />
	</writeHost>
</dataHost>

注意：

blance=“0”代表不开启mycat读写分离

因为mycat读写分离必须要基于mysql主从复制，mysql主从复制又分为主一从一、双主双从

mysql主一从一的话就配置blance=“3”

mysql双主双从的话就配置blance=“1”

5、101和102分别开通mysql远程服务器访问权限

mysql -uroot -pok

grant all privileges on *.* to 'user'@'%' identified by 'ok' with grant option;

flush privileges;

6、验证是否可以远程连接mysql

mysql -uroot -p密码 -h ip -P 3306

7、启动mycat（要保证机器有jdk环境）

cd /usr/local/mycat/bin/

./mycat start

8、登录mycat

mysql -umycat -p123456 -h 192.168.11.101 -P 8066