MySQL(总)MySQL主从

MGR搭建实践

2018-07-20  本文已影响0人  飞翔的Tallgeese

架构

主:172.17.100.101

从①:172.17.100.103

从②:172.17.100.104

MySQL版本:5.7.22

MGR配置

#MGR

server-id = 1

master_info_repository=TABLE

relay_log_info_repository=TABLE

binlog_checksum=NONE

transaction_write_set_extraction=XXHASH64

loose-group_replication_group_name="3db33b36-0e51-409f-a61d-c99756e90155"

loose-group_replication_start_on_boot=off

loose-group_replication_local_address= "172.17.100.101:23306"

loose-group_replication_group_seeds= "172.17.100.101:23306,172.17.100.103:23306,172.17.100.104:23306"

loose-group_replication_bootstrap_group= off

loose-group_replication_single_primary_mode=true

loose-group_replication_enforce_update_everywhere_checks=false

上一篇下一篇

猜你喜欢

热点阅读