mysql mgr部署 

 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 　　

 

posted @ 2021-07-09 14:25  东哥加油！！！  阅读(122)  评论(0)    收藏  举报