《童虎学习笔记》13分钟搭建单主模式MySQL MGR集群-方案2

本文章配套视频	https://www.ixigua.com/7086085500540289572?id=7083095271931904525
本专栏全部文章	https://blog.csdn.net/tonghu_note/category_11755726.html
总目录	https://blog.csdn.net/tonghu_note/article/details/124333034

来我的dou音 aa10246666， 看配套视频

---

一、实战环境

Primary 节点(node1)	mysql 8.0.28	10.211.55.9
Secondary1 节点(node2)	mysql 8.0.28	10.211.55.4
Secondary2 节点(node3)	mysql 8.0.28	10.211.55.6

所有节点的 /etc/hosts 中的配置

root@node1:/usr/local/mysql# cat /etc/hosts
10.211.55.9 node1

10.211.55.4 node2

10.211.55.6 node3

---

二、Primary 节点(node1)的部署

1、清理数据准备初始化mysql，关闭mysqld同时删除数据文件夹

root@node1:/usr/local/mysql# mysqladmin -uroot -p shutdown
Enter password: 
2022-04-05T09:48:31.149274Z mysqld_safe mysqld from pid file /usr/local/mysql/data/node1.pid ended
[1]+  Done                    mysqld_safe --user=mysql
root@node1:/usr/local/mysql# rm -rf data
root@node1:/usr/local/mysql# 

2、设置mysql 配置文件 my.cnf

root@node1:/usr/local/mysql# cat etc/my.cnf 
[mysqld]
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"

server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON

binlog_checksum=NONE

log_bin=binlog
log_slave_updates=ON
binlog_format=ROW
master_info_repository=TABLE
relay_log_info_repository=TABLE
transaction_write_set_extraction=XXHASH64

#plugin_load_add='group_replication.so'
#group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
#group_replication_start_on_boot=off
#group_replication_local_address= "10.211.55.9:33061"
#group_replication_group_seeds= "10.211.55.9:33061,10.211.55.4:33061,10.211.55.6:33061"
#group_replication_bootstrap_group=off

3、初始化mysql数据文件

mysqld --initialize-insecure --user=mysql

4、 将mysql 配置文件 my.cnf中注释的部分都放开

root@node1:/usr/local/mysql# cat etc/my.cnf 
[mysqld]
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"

server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON

binlog_checksum=NONE

log_bin=binlog
log_slave_updates=ON
binlog_format=ROW