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
Schooner MySQL Sync Replication
After commit, all Slaves guaranteed to receive and commit the change
Slave in lock-step with Master
Corruption
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