admin管理员组

文章数量:1609966

序号 主机 系统 作用 备注
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/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'

 

本文标签： MyCatmysqlrouter

版权声明：本文标题：mysqlrouter、mycat+mysql8.0.30实现读写分离 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/xitong/1728587320a1165042.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。