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.
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.
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.
deleted by creator
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.