Asklemmy

43846 readers

779 users here now

A loosely moderated place to ask open-ended questions

Search asklemmy 🔍

If your post meets the following criteria, it's welcome here!

Open-ended question
Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
Not ad nauseam inducing: please make sure it is a question that would be new to most members
An actual topic of discussion

Looking for support?

Looking for a community?

Lemmyverse: community search
sub.rehab: maps old subreddits to fediverse options, marks official as such
!lemmy411@lemmy.ca: a community for finding communities

~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~

founded 5 years ago

MODERATORS

How to scale MySQL horizontally? (programming.dev)

submitted 10 months ago by hypnotic_nerd@programming.dev to c/asklemmy@lemmy.ml

12 comments fedilink hide all child comments

What is the industry/production grade solutions or if you have already any experience please share it. Thanks

you are viewing a single comment's thread
view the rest of the comments

[–] xmunk@sh.itjust.works 0 points 10 months ago

I provided a "real" answer, but I think it's important to realize that MySQL is far behind the game in terms of performance... The Oracle acquisition really fucked that software and it hasn't recovered.

Anyways, horizontal scaling means replicas... But the specifics of that (and resources to aide with it) are highly dependent on their infrastructure... Self hosted? AWS RDS? Aurora? All those have really different starting points when considering a migration.