来我的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 node110.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=ONbinlog_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=ONbinlog_checksum=NONE
log_bin=binlog
log_slave_updates=ON
binlog_format=ROW