linux7 安装 mysql group replication 8.0.23

最新推荐文章于 2024-08-29 17:48:50 发布

jx_jy

最新推荐文章于 2024-08-29 17:48:50 发布

阅读量406

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/j_ychen/article/details/80420732

版权

Mysql 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

[root@mysql01 logs]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.23.103 mysql02
192.168.23.104 mysql03
192.168.23.100 mysql01

单主模式：(Server version: 8.0.23 MySQL Community Server - GPL)
mysql01:
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="f27f5312-4dac-451d-82c6-83b30b8dc572"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="192.168.23.100:33061"
loose-group_replication_group_seeds="192.168.23.100:33061,192.168.23.103:33061,192.168.23.104:33061"
loose-group_replication_bootstrap_group=OFF
report_host=192.168.23.100

mysql02:
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="f27f5312-4dac-451d-82c6-83b30b8dc572" ##uuidgen
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="192.168.23.103:33061"
loose-group_replication_group_seeds="192.168.23.100:33061,192.168.23.103:33061,192.168.23.104:33061"
loose-group_replication_bootstrap_group=OFF
report_host=192.168.23.103
report_port=3306

mysql03:
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="f27f5312-4dac-451d-82c6-83b30b8dc572"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="192.168.23.104:33061"
loose-group_replication_group_seeds="192.168.23.100:33061,192.168.23.103:33061,192.168.23.104:33061"
loose-group_replication_bootstrap_group=OFF
report_host=192.168.23.104
report_port=3306

三个实例：
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
SET SQL_LOG_BIN=0;
CREATE USER repl@'%' IDENTIFIED WITH mysql_native_password BY 'oracle';
GRANT REPLICATION SLAVE ON *.* TO repl@'%';
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='oracle' FOR CHANNEL 'group_replication_recovery';

mysql01:
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;

mysql02:
START GROUP_REPLICATION;

mysql03:
START GROUP_REPLICATION;