3 ms·

I think it depends on the problem. I've worked at a tiny telco (<100 people) where MySql absolutely wouldn't have worked. We ended up using Scylla DB. We had

I think it depends on the problem. I've worked at a tiny telco (<100 people) where MySql absolutely wouldn't have worked. We ended up using Scylla DB. We had billions of rows in single tables. If you're launching an e-commerce site that sells shoes or something, yeah, you probably aren't going to sell a billion shoes every year so MySql is probably fine. Finally, I use this example a lot: Github thought they could scale out MySql by writing their own Operator system that sharded MySql. They put thousands of engineering hours in it, and they still had global database outages that lost customer data. You get that shit for free using Scylla/Cassandra (the ability to replicate across data centers and still fine grained control to do things like enforce local quorum to not impact write speed etc.) They probably made the wrong choice.

krembo 3y ago
Or just use RDS Aurora for same benefits out of the box at scale.
- pc86 3y ago
  You know as I get closer and closer to official graybeard status I start having more of a hair trigger when someone says "just use __________" as if that solves everything and doesn't just create a list of a dozen or two other problems. Everything is tradeoffs, you need to look at what you're trying to do and see which problems you are okay with. Some of these will be show-stoppers at larger scale. Some might be show-stoppers now. But "just use __________" is never the right answer for any serious discussion.
- VirusNewbie 3y ago
  Aurora won't work near as well for write heavy/time series type workloads. It's probably a good middle ground for a lot of applications though.
tynorf 3y ago
Cassandra does not make you immune to database issues: https://monzo.com/blog/2019/09/08/why-monzo-wasnt-working-on-july-29th/ https://monzo.com/blog/2019/09/08/why-monzo-wasnt-working-on...
- pmcf 3y ago
  Yes. You still have to read the docs before randomly setting “auto_bootstrap” to false. Or just use Astra and not worry about scaling your own cluster.
- tomcam 3y ago
  Did GP make such a claim? I didn’t see it, but maybe the comment was edited.
sciurus 3y ago
Are you referring to their use of Vitess? https://github.blog/2021-09-27-partitioning-githubs-relational-databases-scale/ https://github.blog/2021-09-27-partitioning-githubs-relation... GitHub didn't write it, Google/YouTube did.

krembo 3y ago

Or just use RDS Aurora for same benefits out of the box at scale.

pc86 3y ago
You know as I get closer and closer to official graybeard status I start having more of a hair trigger when someone says "just use __________" as if that solves everything and doesn't just create a list of a dozen or two other problems. Everything is tradeoffs, you need to look at what you're trying to do and see which problems you are okay with. Some of these will be show-stoppers at larger scale. Some might be show-stoppers now. But "just use __________" is never the right answer for any serious discussion.
VirusNewbie 3y ago
Aurora won't work near as well for write heavy/time series type workloads. It's probably a good middle ground for a lot of applications though.

tynorf 3y ago

Cassandra does not make you immune to database issues: https://monzo.com/blog/2019/09/08/why-monzo-wasnt-working-on-july-29th/ https://monzo.com/blog/2019/09/08/why-monzo-wasnt-working-on...

pmcf 3y ago
Yes. You still have to read the docs before randomly setting “auto_bootstrap” to false. Or just use Astra and not worry about scaling your own cluster.
tomcam 3y ago
Did GP make such a claim? I didn’t see it, but maybe the comment was edited.

sciurus 3y ago

Are you referring to their use of Vitess? https://github.blog/2021-09-27-partitioning-githubs-relational-databases-scale/ https://github.blog/2021-09-27-partitioning-githubs-relation... GitHub didn't write it, Google/YouTube did.