Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to achieve semi-synchronous replication in Mysql5.7. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

0. System version

Mysql > select version (); +-+ | version () | +-+ | 5.7.25-log | +-+ 1 row in set (0.00 sec)

Install and open on the master

Mysql > install plugin rpl_semi_sync_master soname 'semisync_master.so';Query OK, 0 rows affected (0.03 sec) set global rpl_semi_sync_master_enabled=on

two。 Install and open from above

Mysql > install plugin rpl_semi_sync_slave soname 'semisync_slave.so';Query OK, 0 rows affected (0.01 sec) mysql > set global rpl_semi_sync_slave_enabled=on;Query OK, 0 rows affected (0.00 sec)

3. Confirm that the installation is successful

Mysql > show variables like'% semi%' +-+-+ | Variable_name | Value | +-- -+-+ | rpl_semi_sync_master_enabled | OFF | | 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 | +-+-+ 6 rows in set (0.00 sec) |

4. Use another method to confirm whether the installation is successful

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 | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | | 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 | | MyISAM | | | ACTIVE | STORAGE ENGINE | NULL | GPL | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL | | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | | | GPL | | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL | | FEDERATED | DISABLED | 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_master | ACTIVE | REPLICATION | semisync_master.so | GPL | +-- +-- | -+ 46 rows in set (0.00 sec)

5. Parameter explanation:

Setting rpl_semi_sync_master_enabled # # to on means that the semi-synchronous function is enabled rpl_semi_sync_master_timeout # # unit is millisecond, which means that if the master library waits for a reply message from the slave library to exceed this value, it automatically switches to the asynchronous replication mode rpl_semi_sync_master_wait_for_slave_count # #, which controls how many successful feedback the master library receives from the slave library. The default value of rpl_semi_sync_master_wait_point # # is AFTER_SYNC, which means that the master library writes everything to binlog, passes it to the slave library, refreshes it to the relay log, and the master library begins to wait for feedback from the slave library. After receiving the reply from the slave library, the master library submits the transaction and returns the "commit ok" result to the client.

6. Restart the io thread of the slave library for the setting to take effect

Stop slave io_thread

Start slave io_thread

On how to achieve semi-synchronous replication in Mysql5.7 to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.