mysqlrouter、mycat+mysql8.0.30实现读写分离

序号	主机	系统	作用	备注
1	stu1:192.168.3.81	rockylinux-8.6最小化安装	mysqlrouter
2	stu2:192.168.3.72	centos7.9  最小化安装	mycat
3	stu3:192.168.3.83	rockylinux-8.6最小化安装	master
4	stu4:192.168.3.84	rockylinux-8.6最小化安装	slave
5	stu5:192.168.3.85	rockylinux-8.6最小化安装	client

一、基础环境

1、下载mysql安装包，如下：

mysql-router-commercial-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-common-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-icu-data-files-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-libs-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-server-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-client-plugins-8.0.30-1.1.el8.x86_64.rpm

mysql-commercial-client-8.0.30-1.1.el8.x86_64.rpm

2、关闭selinux及防火墙,并重启系统(五台）

sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
systemctl disable firewalld
systemctl stop firewalld
init 6

3.更新Yum源（五台）

rm -rf * /etc/yum.repos.d/*
curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
yum clean all
yum makecache

4、安装需求包（五台）

yum install -y  perl  net-tools vim wget

二、安装mysql主从

1、安装软件包stu3 stu4

rpm -e postfix;rpm -e mariadb-libs
rpm -ivh mysql-commercial-common-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-icu-data-files-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-client-plugins-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-libs-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-client-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-server-8.0.30-1.1.el8.x86_64.rpm
rpm -ivh mysql-commercial-backup-8.0.30-1.1.el8.x86_64.rpm

安装如下：

2、启动mysqld(stu3、stu4)

systemctl start mysqld
systemctl enable mysqld

3、查询mysql密码并登录mysql  (stu3、stu4)

grep password /var/log/mysqld.log

mysql -uroot -p'zJNlB<uq&9sk'