Hacker News new | ask | show | jobs
by tdbgamer 3196 days ago
Scaling reads is pretty easy with MySQL as you can create read replicas and just have a single write node. Scaling writes while maintaining strong consistency is very hard and requires a sharding setup. Facebook wrote an article showing a bit under the hood details of how they setup MySQL sharding here:

https://www.facebook.com/notes/facebook-engineering/under-th...

You should look into CockroachDB if you want something very easy and scalable. It's strongly consistent like a conventional RDBMS but still scales horizontally pretty easily. It's basically like Google Cloud Spanner if you've heard of that.