Confirm
358
edits
Changes
→Summary
* All reads and writes for a shard go to a single '''master''' MySQL database.
** This saves us having to deal with conflicting writes and othe multi-master headaches.
** To keep things simple, there are no read slaves. The sharding is the only thing responsible for distributing server load.
** A single DB host machine might hold multiple shards.
* Each master synchronously replicates to a '''hot standby''' in the same DC, to guard against individual machine failure.
