mysql的组复制

Bertha 。 2021-11-11 11:58 294阅读 0赞

## 1.配置server1 ##

1.关闭server1的mysqld并删除数据，查看uuid

[root@server1 mysql]# systemctl stop mysqld
    [root@server1 mysql]# rm -fr  *
    [root@server1 mysql]# cat auto.cnf 
    [auto]
    server-uuid=ad3a5dd5-b76f-11e9-bb9b-5254004772f0

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]2.编辑mysql配置文件，并重启数据库

[root@server1 mysql]# vim /etc/my.cnf
    master_info_repository=TABLE
    relay_log_info_repository=TABLE
    binlog_checksum=NONE
    log_slave_updates=ON
    log_bin=binlog
    binlog_format=ROW
    
    transaction_write_set_extraction=XXHASH64		##指示server必须为每个事务收集写集合，并使用XXHASH64哈希算法将其编码为散列
    loose-group_replication_group_name="3f7d3133-b4fb-11e9-a23a-52540039676f"		##告知插件，正在加入或创建的组要命名
    loose-group_replication_start_on_boot=off		##指示插件在server启动时不自动启动组复制
    loose-group_replication_local_address= "172.25.16.1:33061"		##告诉插件使用IP地址本地主机，端口33061用于接收来自组中其他成员的传入连接
    loose-group_replication_group_seeds= "172.25.16.1:33061,172.25.16.2:33061,172.25.16.3:33061"
    loose-group_replication_bootstrap_group=off		##配置是否自动引导组
    loose-group_replication_ip_whitelist="127.0.0.1,172.25.16.0/24"		##用户白名单
    		loose-group_replication_enforce_update_everywhere_checks=ON			##多主模式下为多主更新启用或禁用严格一致性检查	
    loose-group_replication_single_primary_mode=OFF		##设置组自动选择一个server来处理读/写工作
    
    [root@server1 mysql]# systemctl start mysqld
    [root@server1 mysql]# systemctl restart mysqld

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]3.获取初始密码，并登陆数据库修改密码

[root@server1 mysql]# cat /var/log/mysql.log | grep password
    2019-08-05T10:56:28.716457Z 1 [Note] A temporary password is generated for root@localhost: QllupXywe3;b
    [root@server1 mysql]# mysql -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.24-log
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> alter user root@localhost identified by 'Szy+123en';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]4.在server1上启动组复制

mysql> show databases;  
    mysql> SET SQL_LOG_BIN=0;	#禁用二进制日至
    mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'Bgg+2019';	#创建用户
    mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';	#加用户权限
    mysql> FLUSH PRIVILEGES;	#刷新数据
    mysql> SET SQL_LOG_BIN=1;	#启用二进制日至
    mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='Szy+123en' FOR CHANNEL 'group_replication_recovery';	#当配置了用户，使用CHANGE MASTER TO语句将服务器为下一次需要从其他成员恢复状态时使SET SQL_LOG_BIN=0;用group_replication_recovery复制通道的给定凭证，发出以下命令，用创建用户时直接使用的值替换rpl_user和密码
    mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';	#安装组插件
    mysql> SHOW PLUGINS; 
    mysql> SET GLOBAL group_replication_bootstrap_group=ON;		#master上要先打开，等打开组复制之后再开启（slave上不用进行）
    mysql> START GROUP_REPLICATION; #打开组复制
    mysql>  SET GLOBAL group_replication_bootstrap_group=OFF;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]5.在server1上创建表，便于测试

mysql> create database test;
    Query OK, 1 row affected (0.02 sec)
    
    mysql> use test;
    Database changed
    mysql> create table class (name int primary key,grades text not null);
    Query OK, 0 rows affected (0.06 sec)
    mysql> insert into class values (1,'tom');
    Query OK, 1 row affected (0.02 sec)
    
    mysql> select * from class
        -> ;
    +------+--------+
    | name | grades |
    +------+--------+
    |    1 | tom    |
    +------+--------+
    1 row in set (0.00 sec)

6.查看server1是否加入组复制群组

mysql> SELECT * FROM performance_schema.replication_group_members;
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | group_replication_applier | ad3a5dd5-b76f-11e9-bb9b-5254004772f0 | server1     |        3306 | ONLINE       |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    1 row in set (0.00 sec)

## 2.配置server2 ##

1.清空数据库数据

[root@server2 ~]# systemctl stop mysqld
    [root@server2 ~]# cd /var/lib/mysql
    [root@server2 mysql]# ls
    [root@server2 mysql]# rm -rf *

2.修改数据库配置文件

[root@server2 ~]# vim /etc/my.cnf
    enforce-gtid-consistency=true
    master_info_repository=TABLE
    relay_log_info_repository=TABLE
    binlog_checksum=NONE
    log_slave_updates=ON
    log_bin=binlog
    binlog_format=ROW
    
    transaction_write_set_extraction=XXHASH64
    loose-group_replication_group_name="3f7d3133-b4fb-11e9-a23a-52540039676f"
    loose-group_replication_start_on_boot=off
    loose-group_replication_local_address= "172.25.16.2:33061"
    loose-group_replication_group_seeds= "172.25.16.1:33061,172.25.16.2:33061,172.25.16.3:33061"
    loose-group_replication_bootstrap_group=off
    loose-group_replication_ip_whitelist="127.0.0.1,172.25.16.0/24"
    loose-group_replication_enforce_update_everywhere_checks=ON
    loose-group_replication_single_primary_mode=OFF
    
    [root@server2 ~]# systemctl start  mysqld

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]3.获取临时密码，进入数据库修改密码

[root@server2 mysql]# cat /var/log/mysqld.log | grep password
    2019-08-05T11:51:03.681848Z 1 [Note] A temporary password is generated for root@localhost: >NuN6,w2sEq(
    [root@server2 mysql]# mysql -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.24-log
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> alter user root@localhost identified by 'Szy+123en';
    Query OK, 0 rows affected (0.02 sec)

4.启动server2的组复制

mysql> SET SQL_LOG_BIN=0;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'Szy+123en';
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> SET SQL_LOG_BIN=1;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='Szy+123en' FOR CHANNE
    Query OK, 0 rows affected, 2 warnings (0.09 sec)
    
    mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
    Query OK, 0 rows affected (0.24 sec)
    
    mysql> set global group_replication_allow_local_disjoint_gtids_join=on;
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> START GROUP_REPLICATION;
    Query OK, 0 rows affected, 1 warning (5.90 sec)

测试：在server1上查看server2是否加入组复制群组，是否在线

mysql> SELECT * FROM performance_schema.replication_group_members;
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | group_replication_applier | 4d41bf26-b777-11e9-aa93-52540039676f | server2     |        3306 | ONLINE       |
    | group_replication_applier | ad3a5dd5-b76f-11e9-bb9b-5254004772f0 | server1     |        3306 | ONLINE       |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    2 rows in set (0.00 sec)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 8]  
在server1的class表插入的数据，看server2是否同步成功  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 9]

## 3.配置server3 ##

1.将server2的安装包传给server3  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 10]2.安装所有包  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 11]3.编辑mysql配置文件

[root@server3 ~]# vim /etc/my.cnf
    server-id=3
    gtid_mode=ON
    enforce-gtid-consistency=true
    master_info_repository=TABLE
    relay_log_info_repository=TABLE
    binlog_checksum=NONE
    log_slave_updates=ON
    log_bin=binlog
    binlog_format=ROW
    
    transaction_write_set_extraction=XXHASH64
    loose-group_replication_group_name="3f7d3133-b4fb-11e9-a23a-52540039676f"
    loose-group_replication_start_on_boot=off
    loose-group_replication_local_address= "172.25.16.3:33061"
    
    [root@server3 ~]# systemctl start mysqld

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 12]

4.获取临时密码，进入数据库并修改密码

[root@server3 ~]# cat /var/log/mysqld.log | grep password
    2019-08-05T12:29:43.983430Z 1 [Note] A temporary password is generated for root@localhost: bcj(gD>Uk6oF
    [root@server3 ~]# mysql -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.24-log
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> alter user root@localhost identified by 'Szy+123en';
    Query OK, 0 rows affected (0.02 sec)

5.在server3开启组复制

mysql> SET SQL_LOG_BIN=0;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'Szy+123en';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> SET SQL_LOG_BIN=1;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='Szy+123en' FOR CHANNEL 'group_replication_recovery';
    Query OK, 0 rows affected, 2 warnings (0.08 sec)
    
    mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
    Query OK, 0 rows affected (0.20 sec)
    
    mysql> set global group_replication_allow_local_disjoint_gtids_join=on;
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> START GROUP_REPLICATION;
    Query OK, 0 rows affected, 1 warning (3.50 sec)

测试：  
在server1上查看server3是否加入，并在线

mysql> SELECT * FROM performance_schema.replication_group_members;
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    | group_replication_applier | 4d41bf26-b777-11e9-aa93-52540039676f | server2     |        3306 | ONLINE       |
    | group_replication_applier | ad3a5dd5-b76f-11e9-bb9b-5254004772f0 | server1     |        3306 | ONLINE       |
    | group_replication_applier | b4443ef0-b77c-11e9-98b7-52540046c65d | server3     |        3306 | ONLINE       |
    +---------------------------+--------------------------------------+-------------+-------------+--------------+
    3 rows in set (0.08 sec)

server3是否能够查看class表里的数据  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 13]

在server3的class表里添加信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 14]  
server2和server1可以查看到添加的信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 15]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 16]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]: /images/20211109/cc9fb42e0af248ff8224f1c131c154ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]: /images/20211109/20831ac9fed34c56a40668a3e73f9367.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]: /images/20211109/679b5562d43940788c0cb59d5f02fb3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]: /images/20211109/ee6408c0b50748a68559fee923e27823.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]: /images/20211109/70e46d1192ee493e9016184e16bf049a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]: /images/20211109/33ae4698f8ff482db278275e3e7c2872.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]: /images/20211109/35d0524309a648f8b8d37d00896c1300.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]: /images/20211109/7ffead21152b4a4a91d1f81316155561.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 8]: /images/20211109/55e99fa6d6e24b5a94ede5ea349551b3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 9]: /images/20211109/4775f4671b2b4d348f3d020292d37468.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 10]: /images/20211109/56a66195c20f4ce8b987eed884264799.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 11]: /images/20211109/dc174044116e4a65a7576f38beef52d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 12]: /images/20211109/95f4046b6d0a4f9fad68a6c61e57423d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 13]: /images/20211109/33264154a2a7403bbdf32ca43bbed452.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 14]: /images/20211109/ba625f3e87bd414499b74a66bf78893e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20190805204913494.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 16]: /images/20211109/6c8f4cc5b564451a9b563c20e367c579.png

发表评论取消回复

表情：

评论列表（有 0 条评论，294人围观）

还没有评论，来说两句吧...

相关阅读

相关 mysql组复制脑裂_【MySQL】MySQL MGR组复制搭建（单主及多主模式）

1、背景 MGR(MySQL Group Replication)是MySQL官方在5.7.17版本引进的一个数据库高可用与高扩展的解决方案，以插件形式提供，实现了分布式下数

Love The Way You Lie/ 2023年10月05日 18:33/ 0 赞/ 10 阅读

相关 Linux企业实战---mysql的全同步复制（组复制）

一. mysql全同步复制（组复制） 1.理解组复制工作原理 MySQL组复制是一个MySQL插件，它基于常规的MySQL复制，利用了基于行格式的二进制日志和GTID

青旅半醒/ 2023年07月14日 05:59/ 0 赞/ 13 阅读

相关高性能MYSQL—MySQL的组复制(全同步复制)

文章目录 1、全同步复制（组复制）的基本概念 1.1组复制模型： 1.2组复制原理： 2.实现组复制 server1：(

￡神魔★判官ぃ/ 2023年07月13日 10:54/ 0 赞/ 12 阅读

相关 mysql数据库group_key_【MySQL】数据库复制：组复制（Group Replication）

\[root@wallet01 ~\]\ uuidgen 8d1945a5-5c74-4ba0-8240-e9d731110753 \[root@wallet01 ~\]\

灰太狼/ 2023年01月11日 03:54/ 0 赞/ 232 阅读

相关 mysql复制一行sql语句_MySQL的SQL语句 -复制语句（16）- 控制组复制的 SQL 语句

用于检查和设置组复制通信协议版本的函数以下函数能够检查和配置复制组使用的组复制通信协议版本。 ● group\_replication\_get\_communicati

本是古典何须时尚/ 2022年10月31日 12:28/ 0 赞/ 225 阅读

相关【MySQL】组复制背景

> 原文：[https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html][https_d

我会带着你远行/ 2022年03月15日 14:22/ 0 赞/ 160 阅读

相关【MySQL】监控组复制

> 原文：[https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html][https_d

爱被打了一巴掌/ 2022年03月09日 00:14/ 0 赞/ 218 阅读

相关 MySQL的主从复制、GTID复制，半同步复制，组复制

背景： MySQL是现在普遍使用的数据库，但是如果宕机了必然会造成数据丢失。为了保证MySQL数据库的可靠性。就要会一些提高可靠性的技术。因此，一般来说都是通过主从复制

我不是女神ヾ/ 2022年02月02日 05:09/ 0 赞/ 345 阅读

相关 Mysql进阶之主从复制、基于gtid的主从复制、半同步复制、组复制

前言： Mysql是现在普遍使用的数据库，但是如果宕机了必然会造成数据丢失。为了保证mysql数据库的可靠性。就要会一些提高可靠性的技术。因此，一般来说都是通过主从复制（M

小鱼儿/ 2021年11月16日 12:44/ 0 赞/ 430 阅读

相关 mysql的组复制

1.配置server1 1.关闭server1的mysqld并删除数据，查看uuid [root@server1 mysql] systemctl stop m

Bertha 。/ 2021年11月11日 11:58/ 0 赞/ 295 阅读