Re:Ask HN: Real-world anecdotes of MySQL at scale?
by MuffinFlavored on Wednesday September 28, 2022 @01:01AM
(#33004406)
would be cool if there was a free open source program that did this well written once so we could all benefit from it
[ Parent
| on HN ]
Re:Ask HN: Real-world anecdotes of MySQL at scale?
by 20after4 on Wednesday September 28, 2022 @06:50AM
(#33006538)
It's not something that you can easily abstract away from the application's concerns without a significant performance penalty. For the most basic CRUD operations, an ORM could probably do a decent job. Surely someone has already written an ORM that supports sharding?
Beyond CRUD, I'm not so sure, and any application that's big enough to use sharding probably has some pretty complicated queries. At that point you really don't want to be depending on a library to handle the low level details. You need to think about the performance implications of the access patterns and the trade-offs inherent in different design choices. If a library makes these choices for you then you are unlikely to get optimal results.
Re:Ask HN: Real-world anecdotes of MySQL at scale?
by sanjayio on Wednesday September 28, 2022 @08:48AM
(#33007267)
There’s Vitess that’s been mentioned on HN a lot recently. https://vitess.io/