News for hackers. Stuff that matters.

A comment on Is 20M of rows still a valid soft limit of MySQL table in 2023?. Parent comment

Re:Is 20M of rows still a valid soft limit of MySQL table in... by nonethewiser on Monday May 22, 2023 @09:44PM (#36038835)
what is it?
[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by mh- on Monday May 22, 2023 @09:48PM (#36038860)
Events that are enriched off of other data in the same DB.

The system design predates me, but it is solid (albeit difficult to operate at this scale - usual stuff like schema changes, replication bootstrapping).

[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by numbsafari on Monday May 22, 2023 @09:57PM (#36038900)
What is your mean time to recovery like when you have to restart your system?
[ Parent | on HN ]
Re:Is 20M of rows still a valid soft limit of MySQL table in... by mh- on Monday May 22, 2023 @11:13PM (#36039347)
We keep hot masters (typical MySQL master-master-slave(s) setup) on standby.

Bootstrapping one from scratch (like if we need to stand up a new replica)? We restore a disk image on GCP from point in time snapshots, then let it catch up on replication. So it'll depend on how far behind it is when it comes online.

TLDR: a few hours in the worst case. ~Zero downtime in practice.

[ Parent | on HN ]