Shulou(Shulou.com)06/01 Report--

Determine if the plug-in can be installed dynamically

Show variables like'% have_dynamic_loading%';ls / usr/local/mysql-5.6.38-linux-glibc2.12-x86_64/lib/plugin/semisync_*/usr/local/mysql-5.6.38-linux-glibc2.12-x86_64/lib/plugin/semisync_master.so/usr/local/mysql-5.6.38-linux-glibc2.12-x86_64/lib/plugin/semisync_slave.so

Install the software:

Master

Install plugin rpl_semi_sync_master SONAME 'semisync_master.so';set global rpl_semi_sync_master_timeout=60000

From

Install plugin rpl_semi_sync_slave SONAME 'semisync_slave.so';select * from mysql.plugin

Turn on function

Main library

Set global rpl_semi_sync_master_enabled=on

Slave library

Set global rpl_semi_sync_slave_enabled=on;stop slave io_thread;start slave

Main library:

Show status like'% semi%'

From the library io_thread normally, replication latency has no effect on semi-synchronization.

Profile addition options:

Master

Rpl_semi_sync_master_enabled=1rpl_semi_sync_master_timeout=60000

From

Rpl_semi_sync_slave_enabled=1

Note:

1. Without semi-synchronous replication, semi-synchronous replication will cause some statements to be inapplicable and affect the master-slave process.

two。 Do not open rpl_semi_sync_slave_enabled in the master library and rpl_semi_sync_master_enabled in the slave library. Use the corresponding role parameters correctly.

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.