DevOps

1710 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

How to scale MySQL horizontally? (self.devops)

submitted 11 months ago by hypnotic_nerd to c/devops

8 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

[–] Tja 3 points 11 months ago (1 children)

Scaling horizontally is never trivial, can you share more about the requirements?

Usually application level partitioning, but it's hardly repeatable. Cloud providers offer solutions like Spanner, that cost quite a bit. You have new SQL DBs like yugabyte or cockroach, which are not exactly MySQL, and are not really battle tested. And noSQL like MongoDB or Cassandra, which are, well, not even SQL, but are proven technologies and scale quite effortlessly.

[–] [email protected] 3 points 11 months ago

I work for another distributed database company. I can say that it's much harder to convert cockroachDB customers than Yugabyte customers. Given that, I'd think that CockroachDB is likely the more vetted solution. Sure it's new (2017), but it's not THAT new.