How to scale MySQL horizontally?
How to scale MySQL horizontally?
What is the industry/production grade solutions or if you have already any experience please share it. Thanks
You're viewing a single thread.
Use postgres
I'm glad someone else said it... It may sound glib but the performance limits between Postgres and MySQL are night and day.
More seriously though... Read replication is how you horizontally scale any RDBMS. Read replication unlocks a serious amount of read bandwidth but it comes at a (usually steep) technical cost to migrate logic to be handle aware - especially when it comes to complex transactions.
It's not really an answer to the question though.
We don't know that they can just change providers.
In fact as they're asking this it likely means they can't.
I provided a "real" answer, but I think it's important to realize that MySQL is far behind the game in terms of performance... The Oracle acquisition really fucked that software and it hasn't recovered.
Anyways, horizontal scaling means replicas... But the specifics of that (and resources to aide with it) are highly dependent on their infrastructure... Self hosted? AWS RDS? Aurora? All those have really different starting points when considering a migration.