DevOps

1843 readers

1 users here now

DevOps integrates and automates the work of software development (Dev) and IT operations (Ops) as a means for improving and shortening the systems development life cycle.

Rules:

Posts must be relevant to DevOps
No NSFW content
No hate speech, bigotry, etc
Try to keep discussions on topic
No spam of tools/companies/advertisements
It’s OK to post your own stuff part of the time, but the primary use of the community should not be promotional content.

Icon base by Lorc under CC BY 3.0 with modifications to add a gradient

founded 2 years ago

MODERATORS

Ategon

RandomDevOpsDude

Stategies for scaling out MySQL/MariaDB when database gets too large for a single host? (self.devops)

submitted 3 days ago* (last edited 3 days ago) by otto to c/devops

3 comments fedilink hide all child comments

What are your preferred strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM or using regular replication is not an option anymore? Do you deploy ProxySQL to start splitting the traffic according to some rule to two different hosts?

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

[–] refalo 5 points 3 days ago (2 children)

Have you actually analyzed what your real bottleneck is?

[–] otto 1 points 2 days ago (1 children)

I am asking for general strategies, not for a solution to a specific case.

[–] refalo 2 points 1 day ago

Well general strategies are going to depend on where the bottleneck is, so the main general strategy is simply to find the bottleneck. From there, there may be other general strategies one would use for those, but there's so many possible starting places, it's hard to give any specifics as they all depend on what the bottleneck actually is.