1 1.mysql使用版本
2 mysql-8.0.18-el7-x86_64.tar.gz
3
4 2.服务器
5 192.168.56.105 #node1
6 192.168.56.106 #node2
7 192.168.56.107 #node3
8
9 3.mysql安装
10 #yum
11 yum install -y wget libaio
12 #useradd
13 useradd -r -s /sbin/nologin mysql
14 #mkdir
15 mkdir -p /usr/local/mysql
16 mkdir -p /data/mysql/data
17 mkdir -p /data/mysql/logs
18 #修改权限
19 chown -R mysql:mysql /usr/local/mysql8
20 chown -R mysql:mysql /data/mysql
21 chown -R mysql:mysql /usr/local/mysql8
22 bin/mysqld --defaults-file=my3306.cnf --initialize
23 cd /usr/local/mysql8
24 mysqld_safe --defaults-file=my3306.cnf --user=mysql &
25 mysql -uroot -p123456 -S/data/mysql/mysql.sock
26 alter user root@localhost identified by "123456";
27
28 4.修改配置文件
29 binlog_format = ROW
30 binlog_checksum = NONE
31 server_id#每个服务器都不一样
32 loose-group_replication_local_address#每个服务器都不一样
33 report_host#每个服务器都不一样
34 gtid_mode=ON
35 enforce_gtid_consistency=ON
36 master_info_repository=TABLE
37 relay_log_info_repository=TABLE
38 log_slave_updates=ON
39 log_bin=binlog
40
41
42
43 5.所有节点都执行
44 CREATE USER repl@'%' IDENTIFIED BY 'repl';
45 GRANT REPLICATION SLAVE ON *.* TO repl@'%';
46 RESET MASTER;
47 CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='repl' FOR CHANNEL 'group_replication_recovery';
48
49
50
51 6.引导节点执行
52
53 任意找一节点做引导节点
54 SET GLOBAL group_replication_bootstrap_group=ON;
55 START group_replication;
56 SET GLOBAL group_replication_bootstrap_group=off;
57
58
59
60 7.其他节点执行
61 stop group_replication;
62 SET GLOBAL group_replication_bootstrap_group = OFF;
63 START group_replication;
64
65 8.查看各节点状态
66
67 SELECT * FROM performance_schema.replication_group_members;
68 ## 查看当前MGR模式(单主还是多主)
69 SELECT @@group_replication_single_primary_mode;
70
71
72
73 9.单主和多主切换
74
75 #切换多主
76 select group_replication_switch_to_multi_primary_mode();
77
78 #切换单主
79 select group_replication_switch_to_multi_primary_mode();
80
