MySQL实战二：mysql主备实战配置

一主多从实战配置


MASTER配置，追加尾部
#vi /usr/local/mysql/etc/my.cnf
[mysqld]
#主从复制配置
gtid_mode=ON
server_id=1
log-bin=mysql-bin
enforce_gtid_consistency=ON


重启mysql
#systemctl restart mysqld


创建复制用户
mysql> grant replication slave,REPLICATION CLIENT on *.* to 'repl'@'192.168.31.%' identified by '123456';


-------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------

BACKUP配置,追加尾部
#vi /usr/local/mysql/etc/my.cnf
[mysqld]
#主从复制配置
gtid_mode=ON
server_id=2
log-bin=mysql-bin
enforce_gtid_consistency=ON
log_slave_updates=ON
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=2       #开启线程数量
master-info-repository=TABLE
relay-log-info-repository=TABLE


重启slave服务器
#systemctl restart mysqld

SLAVE服务器创建复制链接
mysql> change master to master_host='192.168.31.7',master_user='repl', master_password='123456',master_auto_position=1;

启动复制线程
mysql> start slave;

查看复制状态
mysql> show slave status\G;
mysql> show processlist;