Beautiful. Been aiming to learn how to scale MySQL databases so I can run my apps on VMs without having to used managed dbs like Aurora or Azure Managed Database

Check out RonDB (https://www.rondb.com/blog) which is a fork of MySQL Cluster but has support for elasticity with no downtime, backups, etc. Disclaimer: i am involved with RonDB.

What are the tradeoffs? Guessing based on the stack it's eventual consistency

No. It's a distributed database. Transactions are committed in memory, and then (by default every second) committed as a group to disk. This gives you phenomenal write throughput and low latency, but the tradeoff is that if a whole cluster goes lights out, you could lose a second of data. It's kind of like turning off fsync for InnoDB.

How big are your apps? Wouldn’t the most simple and reliable way be to get one beefy MySQL server and let all the app instances connect to that?

One large VM won't give you replication/sharding, failover, or backups.

With one large VM, for most use cases, you do not need anything but the backups.

Sure, if your workload is small and you have a SLA of "it will be fine."

Most businesses do not need an SLA on ther webservice beyond ‘call us if it doesn’t work’.

Check out Vitess! It’s MySQL at scale.

Happy Thanksgiving to dang and to the HN community

Got rid of my 2 smartphones couple of months ago

Rubbish

Truly beats me. I mean, if you were confident in your hypothesis, then why in Heaven's name would you file a lawsuit (a lawsuit!) against fellow scientists who are poking holes in the theory.

Truthfully, these days it's really beginning to seem as though I'm living through the wrong century. I mean it's like something broke in the world, and basic common sense went took a looong vacation.

1st world problems. In quite a number of countries from Argentina to Turkey to Venezuela, a terrible economic situation and declining living conditions are leading to visible weight loss

Lol. Fastest browsing ever. Crazy to think that in 2022, we're being advised that sites should work without JavaScript. The percentage of people (actual, real live people) who turn off JS when browsing is probably <1%

And hence the reason why kids who grow up in urban areas, tend to have considerably lower than immunity kids raised in rural environments. Urbanism negatively affects us in a lot more ways than we're currently even aware of