Friday, August 5, 2011

MySQL/InnoDB Replication Options

MySQL Asynchronous Replication
Master doesn't wait for slave
Slaves determines how much to pull log events from Master (Bin log) to Slave (Relay log)
Read stale data on slave

No flow control
Corruption

Master failure
Data loss

MySQL Semi-Sync Replication
Master waits for an ACK from slave
Slave logs the transaction event in relay log and ACKs
Read stale data on slave
No flow control
Corruption

Master failure
Data loss


Schooner MySQL Sync Replication

After commit, all Slaves guaranteed to receive and commit the change
Slave in lock-step with Master
Read stale data on slave
No flow control
Corruption

Master failure
Data loss

DRBD (Distributed Replicated Block Device)
Block level replication available for Linux
Suitable for a Master with Direct Attached Storage (DAS)

SAN (Storage Area Network)
Shared disk with similar pros and cons as DRBD
Available for multiple OS
Snapshot backups are a plus


Reference
http://www.schoonerinfotech.com/blog/

No comments:

Post a Comment