MySQL 一主两从快速部署教程（基于 MySQL 8.0.28）

原创代野（Tank） 2022-02-24

2688

MySQL 8.0.28
CentOS 7.6

主从架构的搭建过程相对简单，MySQL 配置文件中添加 server-id 及指定日志参数配置后，在实例中做几步操作即可完成。

需提前准备好 3 个 MySQL 实例，单机部署文档可以参考 CentOS7.6 安装部署 MySQL 8.0.28一文。

修改配置文件

—Master

# /etc/my.cnf
server-id=1  
log-bin=master-bin  
log-bin-index=master-bin.index

—Slave1

# /etc/my.cnf
server-id=2  
relay-log-index=slave-relay-bin.index  
relay-log=slave-relay-bin

—Slave2

# /etc/my.cnf
server-id=3
relay-log-index=slave-relay-bin.index  
relay-log=slave-relay-bin

实例配置

—Master


CREATE USER 'slave1'@'192.168.56.104' IDENTIFIED BY 'Slave@2022';

GRANT REPLICATION SLAVE ON *.* TO 'slave1'@'192.168.56.104';

FLUSH PRIVILEGES;

CREATE USER 'slave2'@'192.168.56.105' IDENTIFIED BY 'Slave@2022';

GRANT REPLICATION SLAVE ON *.* TO 'slave2'@'192.168.56.105';

FLUSH PRIVILEGES;

show master status\G;
*************************** 1. row ***************************
             File: master-bin.000001
         Position: 2089
     Binlog_Do_DB: 
 Binlog_Ignore_DB: 
Executed_Gtid_Set: 
1 row in set (0.00 sec)

ERROR: 
No query specified

—Slave1

change master to master_host='192.168.56.103',master_port=3306, master_user='slave1',master_password='Slave@2022',master_log_file='master-bin.000001',master_log_pos=2089;

reset slave;

start slave;

show slave status\G;

select * from performance_schema.replication_applier_status_by_worker\G

mysql -uslave1 -pSlave@2022 -h192.168.56.103 -P3306

—Slave2

change master to master_host='192.168.56.103',master_port=3306, master_user='slave2',master_password='Slave@2022',master_log_file='master-bin.000001',master_log_pos=2089;

reset slave;

start slave;

show slave status\G;

select * from performance_schema.replication_applier_status_by_worker\G

mysql -uslave2 -pSlave@2022 -h192.168.56.103 -P3306

至此，1 主 2 从的架构已部署完毕。