K8S-Demo集群实践21:MySQL5.7.35高可用架构(两主、主主、多主)双主多从GTID配置方案测试
一、测试方案
- 在一台虚拟机中测试(先验证方案和配置,下一步部署到K8S中)
- Master1,端口3310,名称mysqlm1,配置文件 /opt/mysql/conf/mysqlm1.cnf,数据库目录 /opt/mysql/m1databases,REPLICATION用户名m1slave,密码123456
- Master2,端口3311,名称mysqlm2,配置文件 /opt/mysql/conf/mysqlm2.cnf,数据库目录 /opt/mysql/m2databases,REPLICATION用户名m2slave,密码123456
- Slave1,端口3320,名称mysqls1,配置文件 /opt/mysql/conf/mysqls1.cnf,数据库目录 /opt/mysql/s1databases
- Slave2,端口3321,名称mysqls2,配置文件 /opt/mysql/conf/mysqls2.cnf,数据库目录 /opt/mysql/s2databases
二、准备配置文件
1、master1配置文件:/opt/mysql/conf/mysqlm1.cnf
[mysqld]
server-id=1
auto_increment_offset=1
auto_increment_increment = 2
gtid_mode=on
enforce-gtid-consistency=1
log-bin=m1-bin-log
max_binlog_size=1024M
binlog-format=MIXED
relay-log=m1-relay-log
character-set-server=UTF8MB4
symbolic-links=0
2、master2配置文件:/opt/mysql/conf/mysqlm2.cnf
[mysqld]
server-id=2
auto_increment_offset=2
auto_increment_increment = 2
gtid_mode=on
enforce-gtid-consistency=1
log-bin=m2-bin-log
max_binlog_size=1024M
binlog-format=MIXED
relay-log=m2-relay-log
character-set-server=UTF8MB4
symbolic-links=0
3、slave1配置文件:/opt/mysql/conf/mysqls1.cnf
[mysqld]
server-id=3
master_info_repository=table
relay_log_info_repository=table
read_only=on
gtid_mode=on
enforce-gtid-consistency=1
log-bin=m1-bin-log
max_binlog_size=1024M
binlog-format=MIXED
relay-log=m1-relay-log
character-set-server=UTF8MB4
symbolic-links=0
4、slave2配置文件:/opt/mysql/conf/mysqls2.cnf