3 ms·
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 Databas
by Kudotap 3y ago
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
- huijzer 3y agoHow 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?
- zeroCalories 3y agoOne large VM won't give you replication/sharding, failover, or backups.
- Aeolun 3y agoWith one large VM, for most use cases, you do not need anything but the backups.
- zeroCalories 3y agoSure, if your workload is small and you have a SLA of "it will be fine."
- Aeolun 3y agoMost businesses do not need an SLA on ther webservice beyond ‘call us if it doesn’t work’.
- jamesblonde 3y agoCheck out RonDB (https://www.rondb.com/blog 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.
- paulryanrogers 3y agoWhat are the tradeoffs? Guessing based on the stack it's eventual consistency
- jamesblonde 3y agoNo. 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.
- Alifatisk 3y agoCheck out Vitess! It’s MySQL at scale.