MySQL Semi-synchronous replication

Source: Internet
Author: User

First, Brief introduction

Viewed documents: http://www.actionsky.com/mysql-57-semi-sync-intro/
Where the semi-synchronous copy is explained in great detail.

Second, the simple configuration

Semi-synchronous replication is the main theory of mastering, this configuration is just a few simple parameters.
Semi-synchronous replication or in the case of async is correct.
>master:
>>install plugin rpl_semi_sync_master soname ' semisync_master.so ';
>> See if the added plugin was successful:
>>show plugins;
>>
>>select plugin_name,plugin_status from Information_schema.plugins where plugin_name like '%semi% ';
>>

>set Global Rpl_semi_sync_master_enabled=on;
>
>slave:
>install plugin rpl_semi_sync_slave soname ' semisync_slave.so ';
>
>set Global Rpl_semi_sync_slave_enabled=on;
>

Test:

The slave io thread is closed, and this happens when master updates the data.

Wait for the slave server again for 10 seconds,
Start slave io_thread;
View data,

MySQL Semi-synchronous replication

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.