myqsl 半同步复制与全同步复制

最新推荐文章于 2024-09-12 00:00:00 发布
最新推荐文章于 2024-09-12 00:00:00 发布
阅读量2k 收藏 8
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/love_sunshine_999/article/details/81571344
版权
myqsl 半同步与全同步

概述：

异步复制（Asynchronous replication）
MySQL默认的复制即是异步的，主库在执行完客户端提交的事务后会立即将结果返给给客户端，并不关心从库是否已经接收并处理，
这样就会有一个问题，主如果crash掉了，此时主上已经提交的事务可能并没有传到从上，如果此时，强行将从提升为主，可能导致新主上的数据不完整。
全同步复制（Fully synchronous replication）
指当主库执行完一个事务，所有的从库都执行了该事务才返回给客户端。因为需要等待所有从库执行完该事务才能返回，
所以全同步复制的性能必然会收到严重的影响。
半同步复制（Semisynchronous replication）
介于异步复制和全同步复制之间，主库在执行完客户端提交的事务后不是立刻返回给客户端，而是等待至少一个从库接收到并写到relay log中才返回给客户端。
相对于异步复制，半同步复制提高了数据的安全性，同时它也造成了一定程度的延迟，这个延迟最少是一个TCP/IP往返的时间。所以，半同步复制最好在低延时的网络中使用。

实验环境：

Master:              server3   172.25.52.3
Master/Slave:        server4   172.25.52.4
Slave:               server5   172.25.52.5
server4从server3中取数据 server5从server4中取数据
这样便减轻了server4和server5都从server3上取数据的负担
server3 ---> server4 ---> server5

安装包：

mha4mysql-node-0.56-0.el6.noarch.rpm
mha4mysql-manager-0.56-0.el6.noarch.rpm
perl-Config-Tiny-2.12-7.1.el6.noarch.rpm
perl-Email-Date-Format-1.002-5.el6.noarch.rpm
perl-Log-Dispatch-2.27-1.el6.noarch.rpm
perl-Mail-Sender-0.8.16-3.el6.noarch.rpm
perl-Mail-Sendmail-0.79-12.el6.noarch.rpm
perl-MIME-Lite-3.027-2.el6.noarch.rpm
perl-MIME-Types-1.28-2.el6.noarch.rpm
perl-Parallel-ForkManager-0.7.9-1.el6.noarch.rpm

先将server3（主）和server4（从） 基于GTID主从复制 做好

实验：
在server4中

[root@server4 ~]# vim  /etc/my.cnf
#################
添加：
log-bin=mysql-bin
log-slave-updates

这里写图片描述

[root@server4 ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
##检测：
[root@server4 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> show slave status\G

这里写图片描述

mysql> quit
Bye

在server5中：

[root@server5 ~]# ls
mysql-community-client-5.7.17-1.el6.x86_64.rpm
mysql-community-common-5.7.17-1.el6.x86_64.rpm
mysql-community-libs-5.7.17-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm
mysql-community-server-5.7.17-1.el6.x86_64.rpm
[root@server5 ~]# yum install * -y
[root@server5 ~]# /etc/init.d/mysqld start
Starting mysqld:                                           [  OK  ]

[root@server5 ~]# vim /etc/my.cnf
添加：
server-id=3
gtid_mode=ON
enforce-gtid-consistency=true

这里写图片描述

[root@server5 ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
##查看密码
[root@server5 ~]#  grep password /var/log/mysqld.log
2018-08-10T02:51:02.580277Z 1 [Note] A temporary password is generated for root@localhost: %svsRhkjy3MQ
2018-08-10T02:51:29.666576Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.H6FCiD.sql' started.
2018-08-10T02:51:29.718507Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.H6FCiD.sql' ended.
2018-08-10T02:51:31.634569Z 0 [Note] Shutting down plugin 'sha256_password'
2018-08-10T02:51:31.634574Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-08-10T02:51:33.547304Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)
2018-08-10T02:51:36.844725Z 0 [Note] Shutting down plugin 'validate_password'
2018-08-10T02:51:38.267773Z 0 [Note] Shutting down plugin 'sha256_password'
2018-08-10T02:51:38.267787Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-08-10T02:51:39.873120Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

[root@server5 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.17

Copyright (c) 2000, 2016, 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 'HYM*hyf5532';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

在server4中： 

[root@server4 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> grant replication slave on *.* to server4@'172.25.52.%' identified by 'HYM*hyf5532';
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.02 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show userlist;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'userlist' at line 1
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| userlist       |
+----------------+
1 row in set (0.00 sec)

mysql> select * from userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
+----------+----------+
2 rows in set (0.00 sec)

mysql> quit
Bye

在server5中：

##检测授权是否成功：
[root@server5 ~]# mysql -u server4 -p -h 172.25.52.4
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> quit
Bye

在server4中：

[root@server4 ~]# mysqldump -p test > test.sql
Enter password: 
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. 

[root@server4 ~]# scp test.sql server5:
The authenticity of host 'server5 (172.25.52.5)' can't be established.
RSA key fingerprint is fc:68:3f:d9:a8:07:dd:06:20:09:b5:02:fb:33:a9:99.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'server5' (RSA) to the list of known hosts.
root@server5's password: 
test.sql                                     100% 2181     2.1KB/s   00:00

在server5中

[root@server5 ~]# vim test.sql
#################
注释：
 24 -- SET @@GLOBAL.GTID_PURGED='a4176df3-9ae5-11e8-998f-525400042e83:1-5,
 25 -- abdf9b93-9ae5-11e8-9d3e-525400322e05:1-4';
添加：
  create database test;
  use test;

这里写图片描述

[root@server5 ~]# mysql -p < test.sql
Enter password: 
[root@server5 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| userlist       |
+----------------+
1 row in set (0.00 sec)

mysql> select * from  userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
+----------+----------+
2 rows in set (0.00 sec)

mysql> change master to master_host='172.25.52.4',master_user='server4',master_password='HYM*hyf5532',MASTER_AUTO_POSITION=1;
Query OK, 0 rows affected, 2 warnings (0.83 sec)

mysql> start slave;
Query OK, 0 rows affected (0.31 sec)

mysql> show slave status\G

这里写图片描述

测试：

在sever3中插入数据：
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> insert into userlist values ('user3','333');
Query OK, 1 row affected (0.08 sec)

在server5中检测：
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
| user3    | 333      |
+----------+----------+
3 rows in set (0.00 sec)

查看日志：

[root@server4 ~]# cd /var/lib/mysql
[root@server4 mysql]# ls
auto.cnf         ib_logfile0       mysqld_safe.pid     server4-relay-bin.000005
ca-key.pem       ib_logfile1       mysql.sock          server4-relay-bin.000006
ca.pem           ibtmp1            mysql.sock.lock     server4-relay-bin.index
client-cert.pem  master.info       performance_schema  server-cert.pem
client-key.pem   mysql             private_key.pem     server-key.pem
ib_buffer_pool   mysql-bin.000001  public_key.pem      sys
ibdata1          mysql-bin.index   relay-log.info      test
[root@server4 mysql]# cat relay-log.info
7
./server4-relay-bin.000006
677
mysql-bin.000007
464
0
0
1

[root@server4 mysql]# cat server4-relay-bin.index
./server4-relay-bin.000005
./server4-relay-bin.000006
[root@server4 mysql]# cat master.info
25
mysql-bin.000007
464
172.25.52.3
server3
HYM*hyf5532
3306
60
0
0
30.000
0
a4176df3-9ae5-11e8-998f-525400042e83
86400
1
[root@server4 mysql]# file mysql-bin.000001
mysql-bin.000001: MySQL replication log
##可查看到插入信息
[root@server4 mysql]# mysqlbinlog -vv --base64-output=DECODE-ROWS

这里写图片描述

[root@server4 mysql]# mysqlbinlog --help
mysqlbinlog Ver 3.4 for Linux at x86_64
[root@server4 mysql]# mysqlbinlog --start-position=663 mysql-bin.0.000002 |less
并行复制
[root@server4 mysql]# vim /etc/my.cnf
#####################
写入：
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=16
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON

这里写图片描述

[root@server5 mysql]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@server5 mysql]# vim /etc/my.cnf
#####################
写入：
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=16
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON

这里写图片描述

[root@server5 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> show slave status;
mysql> show  slave status\G

这里写图片描述
这里写图片描述
在server3中：

mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.38 sec)

mysql>  SET GLOBAL rpl_semi_sync_master_enabled = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW STATUS LIKE 'Rpl_semi_sync%';
+--------------------------------------------+-------+
| Variable_name                              | Value |
+--------------------------------------------+-------+
| Rpl_semi_sync_master_clients               | 1     |
| Rpl_semi_sync_master_net_avg_wait_time     | 0     |
| Rpl_semi_sync_master_net_wait_time         | 0     |
| Rpl_semi_sync_master_net_waits             | 0     |
| Rpl_semi_sync_master_no_times              | 0     |
| Rpl_semi_sync_master_no_tx                 | 0     |
| Rpl_semi_sync_master_status                | ON    | #
| Rpl_semi_sync_master_timefunc_failures     | 0     |
| Rpl_semi_sync_master_tx_avg_wait_time      | 0     |
| Rpl_semi_sync_master_tx_wait_time          | 0     |
| Rpl_semi_sync_master_tx_waits              | 0     |
| Rpl_semi_sync_master_wait_pos_backtraverse | 0     |
| Rpl_semi_sync_master_wait_sessions         | 0     |
| Rpl_semi_sync_master_yes_tx                | 0     |
| Rpl_semi_sync_slave_status                 | OFF   |
+--------------------------------------------+-------+
15 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%';
+-------------------------------------------+------------+
| Variable_name                             | Value      |
+-------------------------------------------+------------+
| rpl_semi_sync_master_enabled              | ON         |
| rpl_semi_sync_master_timeout              | 10000      |
| rpl_semi_sync_master_trace_level          | 32         |
| rpl_semi_sync_master_wait_for_slave_count | 1          |
| rpl_semi_sync_master_wait_no_slave        | ON         |
| rpl_semi_sync_master_wait_point           | AFTER_SYNC | #
| rpl_semi_sync_slave_enabled               | OFF        |
| rpl_semi_sync_slave_trace_level           | 32         |
+-------------------------------------------+------------+
8 rows in set (0.00 sec)
半同步

在sesrver4中;

mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
Query OK, 0 rows affected (0.06 sec)

mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.08 sec)

mysql> SET GLOBAL rpl_semi_sync_slave_enabled = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL rpl_semi_sync_master_enabled = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> STOP SLAVE IO_THREAD;
Query OK, 0 rows affected (0.05 sec)

mysql> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)
##检测：状态都为ON（已开启）即可
mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%';
+-------------------------------------------+------------+
| Variable_name                             | Value      |
+-------------------------------------------+------------+
| rpl_semi_sync_master_enabled              | ON         |
| rpl_semi_sync_master_timeout              | 10000      |
| rpl_semi_sync_master_trace_level          | 32         |
| rpl_semi_sync_master_wait_for_slave_count | 1          |
| rpl_semi_sync_master_wait_no_slave        | ON         |
| rpl_semi_sync_master_wait_point           | AFTER_SYNC | 
| rpl_semi_sync_slave_enabled               | ON         |
| rpl_semi_sync_slave_trace_level           | 32         |
+-------------------------------------------+------------+
8 rows in set (0.01 sec)

mysql> SHOW STATUS LIKE 'Rpl_semi_sync%';
+--------------------------------------------+-------+
| Variable_name                              | Value |
+--------------------------------------------+-------+
| Rpl_semi_sync_master_clients               | 1     |
| Rpl_semi_sync_master_net_avg_wait_time     | 0     |
| Rpl_semi_sync_master_net_wait_time         | 0     |
| Rpl_semi_sync_master_net_waits             | 0     |
| Rpl_semi_sync_master_no_times              | 0     |
| Rpl_semi_sync_master_no_tx                 | 0     |
| Rpl_semi_sync_master_status                | ON    |
| Rpl_semi_sync_master_timefunc_failures     | 0     |
| Rpl_semi_sync_master_tx_avg_wait_time      | 0     |
| Rpl_semi_sync_master_tx_wait_time          | 0     |
| Rpl_semi_sync_master_tx_waits              | 0     |
| Rpl_semi_sync_master_wait_pos_backtraverse | 0     |
| Rpl_semi_sync_master_wait_sessions         | 0     |
| Rpl_semi_sync_master_yes_tx                | 0     |
| Rpl_semi_sync_slave_status                 | ON    |
+--------------------------------------------+-------+
15 rows in set (0.00 sec)

在server5中：

mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
Query OK, 0 rows affected (0.06 sec)
mysql> SELECT PLUGIN_NAME,PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%semi%';
+---------------------+---------------+
| PLUGIN_NAME         | PLUGIN_STATUS |
+---------------------+---------------+
| rpl_semi_sync_slave | ACTIVE        |
+---------------------+---------------+
1 row in set (0.00 sec)

mysql> show plugins;
+----------------------------+----------+--------------------+----------------------+---------+
| Name                       | Status   | Type               | Library              | License |
+----------------------------+----------+--------------------+----------------------+---------+
| binlog                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| mysql_native_password      | ACTIVE   | AUTHENTICATION     | NULL                 | GPL     |
| sha256_password            | ACTIVE   | AUTHENTICATION     | NULL                 | GPL     |
| PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| CSV                        | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| InnoDB                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| INNODB_TRX                 | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_LOCKS               | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_LOCK_WAITS          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP                 | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMPMEM              | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMPMEM_RESET        | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_PER_INDEX       | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_PAGE         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_PAGE_LRU     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_POOL_STATS   | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_TEMP_TABLE_INFO     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_METRICS             | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_DELETED          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_BEING_DELETED    | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_CONFIG           | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_INDEX_CACHE      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_INDEX_TABLE      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLES          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLESTATS      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_INDEXES         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_COLUMNS         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FIELDS          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FOREIGN         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FOREIGN_COLS    | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLESPACES     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_DATAFILES       | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_VIRTUAL         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| MRG_MYISAM                 | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| FEDERATED                  | DISABLED | STORAGE ENGINE     | NULL                 | GPL     |
| ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| partition                  | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| ngram                      | ACTIVE   | FTPARSER           | NULL                 | GPL     |
| validate_password          | ACTIVE   | VALIDATE PASSWORD  | validate_password.so | GPL     |
| rpl_semi_sync_slave        | ACTIVE   | REPLICATION        | semisync_slave.so    | GPL     |
+----------------------------+----------+--------------------+----------------------+---------+
46 rows in set (0.00 sec)

mysql> SET GLOBAL rpl_semi_sync_slave_enabled = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> STOP SLAVE IO_THREAD;
Query OK, 0 rows affected (0.34 sec)

mysql> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)
##检测：状态都为ON（已开启）即可
mysql> SHOW STATUS LIKE 'Rpl_semi_sync%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| Rpl_semi_sync_slave_status | ON    |
+----------------------------+-------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| rpl_semi_sync_slave_enabled     | ON    |
| rpl_semi_sync_slave_trace_level | 32    |
+---------------------------------+-------+
2 rows in set (0.00 sec)

测试：

在server3中：
mysql> use test;
Database changed
mysql> insert into userlist values ('user4','444');
Query OK, 1 row affected (0.37 sec)

mysql> insert into userlist values ('user5','555');
Query OK, 1 row affected (0.35 sec)

在server4中：
mysql> SHOW STATUS LIKE 'Rpl_semi_sync%';

这里写图片描述

在serve5中：

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
| user3    | 333      |
| user4    | 444      |
| user5    | 555      |
+----------+----------+
5 rows in set (0.00 sec)

在server4中：
##关闭IO
mysql> STOP SLAVE IO_THREAD;
Query OK, 0 rows affected (0.05 sec)
在server3中：
##此时插入数据需要10秒钟的等待时间
mysql> insert into userlist values ('user6','666');
Query OK, 1 row affected (10.38 sec)
mysql> SHOW VARIABLES LIKE 'rpl_semi_sync%';
##延迟时间为10000毫秒 即位10秒

//
检测：

在server5中：
##数据未同步
mysql> mysql> select * from userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
| user3    | 333      |
| user4    | 444      |
| user5    | 555      |
+----------+----------+
5 rows in set (0.00 sec)

在server4中：
##打开IO
mysql> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)

在server5中：
##数据同步成功
mysql> select * from userlist;
+----------+----------+
| username | password |
+----------+----------+
| user1    | 111      |
| user2    | 222      |
| user3    | 333      |
| user4    | 444      |
| user5    | 555      |
| user6    | 666      |
+----------+----------+
6 rows in set (0.00 sec)
全同步

在server3中

[root@server3 mysql]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
##数据目录初始化
[root@server3 ~]# cd /var/lib/mysql
[root@server3 mysql]# ls
auto.cnf                                     mysql-bin.000004
ib_buffer_pool                               mysql-bin.000005
ibdata1                                      mysql-bin.000006
ib_logfile0                                  mysql-bin.000007
ib_logfile1                                  mysql-bin.index
install-validate-password-plugin.3WRKe7.sql  performance_schema
master.info                                  relay-log.info
mysql                                        server3-relay-bin.000001
mysql-bin.000001                             server3-relay-bin.index
mysql-bin.000002                             sys
mysql-bin.000003                             test
[root@server3 mysql]# rm -fr *
[root@server3 mysql]# ls
[root@server3 mysql]# pwd
/var/lib/mysql
##编写配置文件
[root@server3 mysql]# vim /etc/my.cnf
#####################
删除：
server-id=1
log-bin=mysql-bin

gtid_mode=ON
enforce-gtid-consistency=true

slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=16
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay_log_recovery=ON
添加：
server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
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
## UUID
loose-group_replication_group_name="b57168a3-9c7b-11e8-93be-525400bb761d" 
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.25.52.3:24901"
loose-group_replication_group_seeds="172.25.52.3:24901,172.25.52.4:24901,172.25.52.5:24901"
loose-group_replication_bootstrap_group= off
loose-group_replication_single_primary_mode=off
loose-group_replication_enforce_update_everywhere_checks=on

loose-group_replication_ip_whitelist='172.25.52.0/24,127.0.0.1/8'

这里写图片描述
[root@server3 mysql]# vim /etc/init.d/mysqld
这里写图片描述

[root@server3 mysql]# /etc/init.d/mysqld start
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]
##查看初始密码
[root@server3 mysql]#  grep password /var/log/mysqld.log
[root@server3 mysql]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.17-log

Copyright (c) 2000, 2016, 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> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER root@localhost identified by 'HYM*hyf5532';
Query OK, 0 rows affected (0.04 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> SET SQL_LOG_BIN=0;
Query OK, 0 rows affected (0.00 sec)

mysql> grant replication slave on *.* to server3@'172.25.52.%' identified by 'HYM*hyf5532';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> reset master;
Query OK, 0 rows affected (0.14 sec)

mysql> SET SQL_LOG_BIN=1;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_USER='server3', MASTER_PASSWORD='HYM*hyf5532' FOR CHANNEL 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.66 sec)

mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
Query OK, 0 rows affected (0.56 sec)

mysql> SHOW PLUGINS;

这里写图片描述


mysql> SET GLOBAL group_replication_bootstrap_group=ON;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL group_replication_bootstrap_group=OFF;
Query OK, 0 rows affected (0.00 sec)


mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (1.26 sec)

mysql> SELECT * FROM  performance_schema.replication_group_members;

这里写图片描述

mysql> CREATE DATABASE test;
Query OK, 1 row affected (0.04 sec)

mysql> USE test
Database changed

mysql> CREATE TABLE student( sno INT  PRIMARY KEY, name CHAR(10) NOT NULL);
Query OK, 0 rows affected (0.56 sec)

mysql> INSERT INTO student VALUES(1,'tom');
Query OK, 1 row affected (0.41 sec)

mysql> select * from student;
+-----+------+
| sno | name |
+-----+------+
|   1 | tom  |
+-----+------+
1 row in set (0.00 sec)

mysql> quit
Bye

在server4中：
除不执行以下两步操作外 其余操作均同server3
SET GLOBAL group_replication_bootstrap_group=ON;
SET GLOBAL group_replication_bootstrap_group=OFF;

[root@server4 mysql]# /etc/init.d/mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server4 mysql]# cd /var/lib/mysql
[root@server4 mysql]# ls
ib_buffer_pool  mysqld
[root@server4 mysql]# rm -fr *
[root@server4 mysql]# vim /etc/my.cnf
####################
除 id 与 ip 不同外 均与server3的配置相同

这里写图片描述

[root@server4 mysql]# /etc/init.d/mysqld start
Initializing MySQL database:  
##查看密码
[root@server4 mysql]# grep password /var/log/mysqld.log
[root@server4 mysql]#  mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.17-log

Copyright (c) 2000, 2016, 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 'HYM*hyf5532';
Query OK, 0 rows affected (0.06 sec)

mysql> SET SQL_LOG_BIN=0;
Query OK, 0 rows affected (0.00 sec)

mysql> grant replication slave on *.* to server4@'172.25.52.%' identified by 'HYM*hyf5532';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> reset master;
Query OK, 0 rows affected (0.18 sec)

mysql> SET SQL_LOG_BIN=1;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_USER='server3', MASTER_PASSWORD='HYM*hyf5532' FOR CHANNEL 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.72 sec)

mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
Query OK, 0 rows affected (0.16 sec)
##有group_replication即为成功
mysql> SHOW PLUGINS;
+----------------------------+----------+--------------------+----------------------+---------+
| Name                       | Status   | Type               | Library              | License |
+----------------------------+----------+--------------------+----------------------+---------+
| binlog                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| mysql_native_password      | ACTIVE   | AUTHENTICATION     | NULL                 | GPL     |
| sha256_password            | ACTIVE   | AUTHENTICATION     | NULL                 | GPL     |
| PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| CSV                        | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| InnoDB                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| INNODB_TRX                 | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_LOCKS               | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_LOCK_WAITS          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP                 | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMPMEM              | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMPMEM_RESET        | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_PER_INDEX       | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_PAGE         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_PAGE_LRU     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_BUFFER_POOL_STATS   | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_TEMP_TABLE_INFO     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_METRICS             | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_DELETED          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_BEING_DELETED    | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_CONFIG           | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_INDEX_CACHE      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_FT_INDEX_TABLE      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLES          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLESTATS      | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_INDEXES         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_COLUMNS         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FIELDS          | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FOREIGN         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_FOREIGN_COLS    | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_TABLESPACES     | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_DATAFILES       | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| INNODB_SYS_VIRTUAL         | ACTIVE   | INFORMATION SCHEMA | NULL                 | GPL     |
| MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| MRG_MYISAM                 | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| FEDERATED                  | DISABLED | STORAGE ENGINE     | NULL                 | GPL     |
| ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| partition                  | ACTIVE   | STORAGE ENGINE     | NULL                 | GPL     |
| ngram                      | ACTIVE   | FTPARSER           | NULL                 | GPL     |
| group_replication          | ACTIVE   | GROUP REPLICATION  | group_replication.so | GPL     |
+----------------------------+----------+--------------------+----------------------+---------+
45 rows in set (0.00 sec)

mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (3.93 sec)

mysql> SELECT * FROM  performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | c7c674bc-9c79-11e8-a8d6-525400042e83 | server3     |        3306 | ONLINE       |
| group_replication_applier | f65d4e98-9c88-11e8-9fab-525400322e05 | server4     |        3306 | ONLINE       |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
2 rows in set (0.00 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| student        |
+----------------+
1 row in set (0.00 sec)

mysql> select * from student
    -> ;
+-----+------+
| sno | name |
+-----+------+
|   1 | tom  |
+-----+------+
1 row in set (0.00 sec)
mysql> quit
Bye

如何查看uuid

[root@server5 ~]#  /etc/init.d/mysqld start
Starting mysqld:                                           [  OK  ]
[root@server5 ~]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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> select uuid();
+--------------------------------------+
| uuid()                               |
+--------------------------------------+
| b57168a3-9c7b-11e8-93be-525400bb761d |
+--------------------------------------+
1 row in set (0.00 sec)

server5的操作完全与server4相同

测试：
没有主从之分, 无论在哪一个结点上插入数据 在另外两个节点上均可查看到数据的变更

love_sunshine_999
关注
mysql 半同步复制模式使用详解
congge
09-19 4220
mysql 半同步复制模式使用详解
mysql的组复制（全同步复制）
weixin_43273168的博客
05-09 1601
简介： 组复制的原理 组复制是一种可用于实现容错系统的技术。 复制组是一个通过消息传递相互交互的 server 集群。 通信层提供了原子消息(atomic message)和完全有序信息交互等保障机制。 这些是非常强大的功能,我们可以据此架构设计更高级的数据库复制解决方案。 MySQL 组复制以这些功能和架构为基础,实现了基于复制协议的多主更新。 复制组由多个 server成员构成,并且组中的...
分布式mysql配置(全同步复制)
weixin_43831670的博客
05-08 557
前言： MySQL的组复制(MySQL Group Replication) 1、组复制是基于分布式一致性协议Paxos实现数据最终统一性的MySQL插件，通过这种插件可以 实现弹性、高可用、容错复制拓扑结构。 MySQL组复制提供分布式状态机复制，在服务器之间具有协调性，当数据库服务器属于同一组时， 组复制机制可以自动协调它们，该组可以在具有自动选择新主库功能的单主模式下操作，这种情况...
mysql的全同步复制
weixin_30488313的博客
05-20 170
介绍： Mysql的复制方法有三种： 基于行，基于sql语句，基于混合部署，还有一种就是GTIDS Mysql的主从复制方式有三种： 同步、异步、半同步 全同步复制：在主节点上写入的数据，在从服务器上都同步完了以后才会给客户端返回成功消息，相对来说比较安全，比较靠谱。但是返回信息的时间比较慢 异步复制：在主节点接收到客户端发送的数据就给客户端返回执行成功的消息。然后再开始再从上面...
是什么让 TiDB 从一款中国受欢迎的数据库产品在短短几年内成为全球受欢迎的数据库产品？...
最新发布
TiDB 社区干货传送门
09-12 1111
作者： Billmay表妹 原文来源： https://tidb.net/blog/18e0748c ...
mysql--半同步复制和全同步复制
qq_41977453的博客
01-08 1343
一、半同步复制 1 半同步复制的介绍 mysql的主备库通过binlog日志保持一致，主库本地执行完事务，binlog日志落盘后即返回给用户；备库通过拉取主库binlog日志来同步主库的操作。默认情况下，主库与备库并没有严格的同步，因此存在一定的概率备库与主库的数据是不对等的。半同步特性的出现，就是为了保证在任何时刻主备数据一致的问题。相对于异步复制，半同步复制要求执行的每一个事务，都要求至少...
mysql的半同步复制和全同步复制
Dead_LS的博客
02-10 674
1.mysql半同步复 在server1和server2上安装半同步复制的插件 INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';安装半同步模块 查看server1和server2上的插件 SELECT PLUGIN_NAME, PLUGIN_STATUS设置 FROM INFORMATION_SCHEM...
Mysql的全同步复制（组复制）
qq_46089299的博客
05-12 978
二、搭建实验环境 实验环境：（一主多从模式），一个master节点+两个slave节点 主机名 IP 功能 server1 172.25.254.1 master节点 server2 172.25.254.2 slave节点 server3 172.25.254.3 slave节点 三、开始实现组复制（全同步）的操作流程 组复制（全同步复制）互相为master和slave；相当于一个集群，都可以作为master和slave
Mysql半同步复制原理及问题排查
09-10
MySQL半同步复制是一种复制模式，旨在提供比异步复制更高的数据一致性。在异步复制中，主服务器在将二进制日志发送给从服务器后立即返回结果给客户端，不关心从服务器是否已接收和应用这些日志。这可能导致在主从...
mysql 半同步复制模式
07-31
MySQL的半同步复制模式（Semi-Synchronous Replication）是一种增强型的复制策略，旨在解决传统异步复制中数据丢失的问题。在半同步复制中，主库确保至少有一个从库接收到并写入了事务日志（二进制日志，binlog）后...
MySQL半同步复制配置
12-25
MySQL半同步复制配置是一项重要的数据库高可用性和数据一致性保障技术。在半同步复制模式下，当主服务器向从服务器发送数据时，只有当至少一个从服务器确认接收到该数据后，主服务器才会认为事务提交成功，这样可以...
Mysql的全同步复制
lyy962464的博客
03-31 658
一、全同步复制(（Fully synchronous replication）原理 1、逻辑上 指当主库执行完一个事务，所有的从库都执行了该事务才返回给客户端。因为需要等待所有从库执行完该事务才能返回，所以全同步复制的性能必然会收到严重的影响。 2、技术上 当主库提交事务之后，所有的从库节点必须收到、APPLY并且提交这些事务，然后主库线程才能继续做后续操作。但缺点是，主库完成一个事务的时...
详解MySQL数据库原生的数据复制方式：异步复制、半同步复制与全同步复制
淡定波的博客
04-20 1219
一、MYSQL复制架构衍生史 在2000年，MySQL 3.23.15版本引入了Replication。Replication作为一种准实时同步方式，得到广泛应用。这个时候的Replicaton的实现涉及到两个线程，一个在Master，一个在Slave。Slave的I/O和SQL功能是作为一个线程，从Master获取到event后直接apply，没有relay log。这种方式使得读取event的速度会被Slave replay速度拖慢，当主备存在较大延迟时候，会导致大量binary log没有备份到Sla
MySQL的半同步是什么？
Jimoer
04-18 826
前言 年后在进行腾讯二面的时候，写完算法的后问的第一个问题就是，MySQL的半同步是什么？我当时直接懵了，我以为是问的MySQL的两阶段提交的问题呢？结果确认了一下后不是两阶段提交，然后面试官看我连问的是啥都不知道，就直接跳过这个问题，直接聊下一个问题了。 MySQL的主从复制 我们的一般在大规模、高性能的项目上，都是使用MySQL的复制功能来创建MySQL的主从集群的。主要是可以通过为服务器配置一个或多个备库的方式来进行数据同步。复制的功能不仅有利于构建高性能应用，同时也是高可用、可扩展性、灾难恢复、备份
MySQL全同步复制
qq_45070541的博客
11-18 391
MySQL组复制
Mysql全同步复制
RainingCostaRiga的博客
08-02 428
MySQL数据库的全同步复制的部署 1.配置server1：（因为server1之前做过主从复制，所以要清空环境） <1>停掉之前的mysql，清空/var/lib/mysql目录下所有的mysql缓存记录 注意:必须先停掉mysqld服务，然后再删除数据（这是因为关闭mysqld服务时，会自动保存数据） <2>获取uuid <3>编辑配置文件 [root...
mysql同步复制_MySQL 全同步复制
weixin_27875131的博客
01-18 491
实验环境：没有主从之分，全都是组成员CentOS7操作系统；主机：server1-----------192.168.200.112server2-----------192.168.200.113server3-----------192.168.200.114软件：mysql三台机器数据保存一致性在server1上：修改mysql的配置文件[emailprotected] ~]# vim /...
MySQL主从同步之 异步复制 半同步复制 全同步复制
jj89929665的博客
06-27 2174
为了解决主从同步不一致的问题主库执行完提交事务后，立刻异步执行将结果返给给客户端，并不关心从库是否收到并处理。如果出现从库并未收到处理的情况，还是会有主从数据不一致的问题。期MySQL(5.5以前)仅仅支持异步复制。并且早期支持 myisam引擎。主库在执行完客户端提交的事务后不是立刻返回给客户端，而是等待至少一个从库接收到并写到 relay log 中才返回给客户端。相对于异步复制，半同步复制提高了数据的安全性，同时它也造成了一定程度的延迟。 半同步复制的出现，就是为了保证在任何时刻主备数据一致的问题。相
MySQL半同步复制原理与实战配置
MySQL半同步复制是一种高级的数据复制策略，旨在提高数据一致性，避免主从服务器之间的数据不一致性和潜在的数据丢失。默认情况下，MySQL采用异步复制模式，这种模式虽然性能较好，但存在一定的风险：主服务器可能在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值