MySQL8.0 MGR 部署

1. 机器

IP	角色
192.18.10.1	master
192.18.10.2	slave
192.18.10.3	slave

2. 步骤

2.1 初始化：

mgr.cnf:

# cat mgr.cnf
[mysqld]
master_info_repository = TABLE
relay_log_info_repository = TABLE
relay_log_recovery=1
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates = ON
binlog_checksum=NONE
slave_preserve_commit_order = ON 
server_id=1    
slave_parallel_type=LOGICAL_CLOCK
slave_parallel_workers=8   

transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address="192.18.10.1:23306"
loose-group_replication_group_seeds="192.18.10.1:23306,192.18.10.2:23306,192.18.10.3:23306"
loose-grup_replication_bootstrap_group=off

default_authentication_plugin=mysql_native_password
binlog-format=ROW
log-bin=mysql-bin
local_infile=on
#skip_grant_tables
innodb_buffer_pool_size= 100M 
lower_case_table_names = 1
general_log = 1

basedir=/root/tester/mysql-8.0.20
datadir=/root/tester/mysqldata/data
tmpdir=/root/tester/mysqldata/tmp
pid-file=/root/tester/mysqldata/mysql.pid
socket=/root/tester/mysqldata/mysql.sock
mysqlx_socket=/root/tester/mysqldata/mysqlx.sock


character-set-server=utf8mb4
collation-server =utf8mb4_unicode_ci
character-set-client-handshake =FALSE
default-time-zone="system"

max_connections=2000
log-output=FILE
log-error=/root/tester/mysqldata/logs/error.log



[mysql]
default-character-set = utf8mb4
socket=/root/tester/mysqldata/mysql.sock

命令：

mysqld --defaults-file=/root/tester/mgr.cnf --datadir=/root/tester/mysqldata/data  --user=root --initialize

2.2 启动

mysqld --defaults-file=/root/tester/mgr.cnf --user=root &