Category: Software Preview

ReplicationFeatures/SemiSyncReplication


Contents

[edit] SEMI-SYNCHRONOUS REPLICATION

Feature preview from a contributed patch from Mark Callaghan and Wei Li, Google, that was modified by Zhenxing He, MySQL Replication Team.

[edit] Provides:

A facility for highly available replication. If the master crash after having committed a transaction, the slave is guaranteed to have receive it.

[edit] Use case:

If the master crash, the slave can be instantly promoted to substitute the old master. The slave has all the master's transactions either in its relay-log or already applied.

[edit] User interface:

 master:
    --rpl_semi_sync_enabled=1|0
    --rpl_semi_sync_timeout= timeout value in seconds
 slave:
    --rpl_semi_sync_slave_enabled=1|0
 master:
    set global rpl_semi_sync_enabled=1|0;
    show status like 'Rpl_semi_sync_clients';
    show status like 'Rpl_semi_sync_status';
    show status like 'Rpl_semi_sync_no_tx';
    show status like 'Rpl_semi_sync_yes_tx';
 slave:
    set global rpl_semi_sync_slave_enabled = 1|0;
    show status like 'Rpl_semi_sync_slave_status';

[edit] Modifications made by MySQL:

[edit] References:

[edit] Associated issues:

[edit] Downloads:

[edit] Thanks:

Mark Callaghan and Wei Li from Google whose original patch for 5.0 was converted by Zhenxing He MySQL Replication Team.

Retrieved from "http://forge.mysql.com/wiki/ReplicationFeatures/SemiSyncReplication"

This page has been accessed 328 times. This page was last modified 17:04, 13 April 2008.

Find

Browse
MySQLForge
Main Page
Current events
Recent changes
Random page
Help
Edit
Edit this page
Editing help
This page
Discuss this page
Post a comment
Printable version
Context
Page history
What links here
Related changes
My pages
Special pages
New pages
File list
Statistics
Bug reports
More...