## 基于mycat搭建mysql读写分离,mycat-web控制台,及mysql性能优化
1.搭建过程
1.1搭建好两台虚拟机test01(192.168.18.128),test02(192.168.18.129)
1.2安装好mysql
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
sudo yum install mysql-server
启动mysql systemctl start mysqld.service
查看mysql 状态service mysqld status
关闭防火墙systemctl stop firewalld 查看防火墙状态systemctl status firewalld
授权远程连接use mysql grant all privileges on . to ‘root’@’%’ identified by ‘Zdl@123456’;
重启mysql服务 service mysqld restart
1.3做主从复制
1.3.1配置主my.cnf
server_id=(ip结尾) 服务器id
log-bin=mysql-bin 开启日志文件
重启mysql服务器
service mysqld restart
service mysqld status
show variables like ‘%server_id%’; 与my.cnf 配置129一样
Show master status master日志显示
1.3.2配置从服务器
配置my.cnf
server_id=(ip结尾) 服务器id
log-bin=mysql-bin 开启日志文件
binlog_do_db=mysql
重启mysql服务器
执行
change master to
master_host=‘192.168.18.128’,master_user=‘root’,master_pass