MySQL半同步复制配置和参数详解
目录
1 成功配置主从复制
2 加载插件
3 半同步复制监控
4 半同步复制参数
1 成功配置主从复制
操作步骤参考：https://blog.csdn.net/zyb378747350/article/details/148309545
2 加载插件
#主库上
MySQL 8.0.26 之前版本:
mysql>INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
或
MySQL 8.0.26 之后版本:
mysql>INSTALL PLUGIN rpl_semi_sync_source SONAME 'semisync_source.so';
mysql> SHOW STATUS LIKE 'Rpl_semi_sync_source_status';
+-----------------------------+-------+
| Variable_name | Value |
+-----------------------------+-------+
| Rpl_semi_sync_source_status | ON |
+-----------------------------+-------+
1 row in set (0.00 sec)
MySQL 8.0.26 之前版本:
mysql>SET GLOBAL rpl_semi_sync_master_enabled = 1;
或
MySQL 8.0.26 之后版本:
mysql>SET GLOBAL rpl_semi_sync_source_enabled = 1;
vi /etc/my.cnf
[mysqld]
rpl_semi_sync_master_enabled=1
或
MySQL 8.0.26 之后版本:
rpl_semi_sync_source_enabled=1
#从库上
MySQL 8.0.26 之前版本:
mysql>INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
或
MySQL 8.0.26 之后版本:
mysql>INSTALL PLUGIN rpl_semi_sync_replica SONAME 'semisync_replica.so';
mysql> show variables like 'rpl_semi_sync%';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| rpl_semi_sync_replica_enabled | ON |
| rpl_semi_sync_replica_trace_level | 32 |
+-----------------------------------+-------+
MySQL 8.0.26 之前版本:
mysql>SET GLOBAL rpl_semi_sync_slave_enabled = 1;
或
MySQL 8.0.26 之后版本:
mysql>SET GLOBAL rpl_semi_sync_replica_enabled = 1;
MySQL 8.0.26 之前版本:
mysql>STOP SLAVE IO_THREAD;
mysql>START SLAVE IO_THREAD;
或
MySQL 8.0.26 之后版本:
mysql>STOP REPLICA IO_THREAD;
mysql>START REPLICA IO_THREAD;
vi /etc/my.cnf
[mysqld]
rpl_semi_sync_slave_enabled=1
或
MySQL 8.0.26 之后版本:
rpl_semi_sync_replica_enabled=1
3 半同步复制监控
mysql> SHOW STATUS LIKE 'Rpl_semi_sync%';
4 半同步复制参数
#主库上
mysql> show global variables like '%semi%';
+---------------------------------------------+------------+
| Variable_name | Value |
+---------------------------------------------+------------+
| rpl_semi_sync_source_enabled | ON |
| rpl_semi_sync_source_timeout | 10000 |
| rpl_semi_sync_source_trace_level | 32 |
| rpl_semi_sync_source_wait_for_replica_count | 1 |
| rpl_semi_sync_source_wait_no_replica | ON |
| rpl_semi_sync_source_wait_point | AFTER_SYNC |
+---------------------------------------------+------------+
6 rows in set (0.00 sec)
#从库上
mysql> show global variables like '%semi%';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| rpl_semi_sync_replica_enabled | ON |
| rpl_semi_sync_replica_trace_level | 32 |
+-----------------------------------+-------+
2 rows in set (0.00 sec)
