MySQL Replication

Why?

• Point-in-time backups/dumps without downtime.
• Disaster recovery.
• Spreading load.

How?

• Master servers send all their updates to the slaves.
• Slaves must begin with their data in the same state.
• Slaves must execute all updates to remain in sync.