this post was submitted on 03 May 2025
17 points (90.5% liked)

Sysadmin

10552 readers
1 users here now

A community dedicated to the profession of IT Systems Administration

No generic Lemmy issue posts please! Posts about Lemmy belong in one of these communities:
!lemmy@lemmy.ml
!lemmyworld@lemmy.world
!lemmy_support@lemmy.ml
!support@lemmy.world

founded 2 years ago
MODERATORS
DarraignTheSane@lemmy.world
00Lemming@lemmy.world
L3s@lemmy.world
17
What to do when a MySQL/MariaDB database gets too large for a single host? (programming.dev)
submitted 3 months ago by otto@programming.dev to c/sysadmin@lemmy.world
7 comments fedilink hide all child comments
 

What are your strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM is not an option anymore? Do you deploy ProxySQL to start splitting the traffic according to some rule to two different hosts? What would the rule be, and how would you split the data? Has anyone migrated to TiDB? In that case, what was the strategy to detect if the SQL your app uses is fully compatible with TiDB?

you are viewing a single comment's thread
view the rest of the comments
[–] oldfart@lemm.ee 1 points 3 months ago

Is it a single large table? Is it used by a single program you control or something like a web host with 1000 wordpress instances?