How to scale MySQL horizontally?
What is the industry/production grade solutions or if you have already any experience please share it. Thanks
You are viewing a single comment
What is the industry/production grade solutions or if you have already any experience please share it. Thanks
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.