Detailed explanation of the method of semi-synchronous replication of MySQL

This article mainly introduces "the detailed explanation of the method of MySQL semi-synchronous replication". In the daily operation, I believe that many people have doubts about the detailed explanation of the method of MySQL semi-synchronous replication. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "detailed explanation of the method of MySQL semi-synchronous replication". Next, please follow the editor to study!

1. Install the relevant plug-ins on the master and slave nodes respectively

Master > INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so'

Slave > INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so'

2. Enable semi-synchronous replication

In the configuration file on master, add

Rpl_semi_sync_master_enabled=ON

Add to the configuration file of at least one slave node

Rpl_semi_sync_slave_enabled=ON

Then restart the mysql service to take effect.

Alternatively, you can start its related functions dynamically on the mysql service:

Master > SET GLOBAL rpl_semi_sync_master_enabled = ON

Slave > SET GLOBAL rpl_semi_sync_slave_enabled = ON

Slave > STOP SLAVE IO_THREAD; START SLAVE IO_THREAD

3. Confirm that the semi-synchronization feature is enabled

Master > CREATE DATABASE mydb

Master > SHOW STATUS LIKE 'Rpl_semi_sync_master_yes_tx'

Slave > SHOW DATABASES

At this point, the study of "detailed explanation of the method of semi-synchronous replication of MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!