3 ms·
I don't think the claim of MySQL replication being better is related to statement vs. row vs. binary diff. I think it is about the tooling and community knowled
by antoncohen 9y ago
I don't think the claim of MySQL replication being better is related to statement vs. row vs. binary diff. I think it is about the tooling and community knowledge about replication, and about running MySQL in large scale production environments in general.
MySQL is run more often at extremely large scale (Facebook, YouTube, Twitter, Dropbox, etc.) than Postgres. That results in very battle tested and/or featureful tooling like orchestrator (https://github.com/github/orchestrator https://github.com/github/orchestrator), MHA (https://github.com/yoshinorim/mha4mysql-manager https://github.com/yoshinorim/mha4mysql-manager), ProxySQL (http://www.proxysql.com/ http://www.proxysql.com/), and gh-ost (https://github.com/github/gh-ost https://github.com/github/gh-ost), along knowledge and best practices shared by those organization.
- amigoingtodie 9y agoWhat are anybody's real-world use case for proxysql? I have been toying with the idea of using it for local devs to access our prod DB for reads (for accurate data) and using a local DB on their machines for writes. Not sure how to handle UPDATEs, though.
- emfree 9y agoUse cases for ProxySQL: many. - failover - query routing (e.g., for sharded deployments) - caching - workload stats/metrics - query rewriting etc.