1.停止一个已经生效的从服务器
2.复制目录:
cp -r mysql-replica01 mysql-replica02
3.修改文件所有者:
chown -R mysql:mysql mysql-replica02
4.修改配置文件:
[mysqld@replica02]
datadir=/var/lib/mysql-replica02
socket=/var/lib/mysql-replica02/mysql.sock
port=3308
log-error=/var/log/mysqld-replica02.log
5.启动mysqld,登录数据库,生成uuid
6.进入mysql-replica02目录,修改auto.cnf的server-uuid。
7.执行命令:
systemctl start mysqld@replica02
systemctl enable mysqld@replica02