News for hackers. Stuff that matters.
Re:Ask HN: Real-world anecdotes of MySQL at scale? by dsr_ on Tuesday September 27, 2022 @11:45AM (#32996881)
Sharding is when you store your tables, or parts of tables, on other machines, so that queries are executed by the resources of those remote machines.

Read-only replication stores a copy of the whole database on other machines, so that any query which doesn't write can be handled by asking the remote machine. Writes are bottlenecked through the primary machine, which then sends changes to the remotes.

There are no comments on this comment yet.