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.
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.