top | item 27477582

(no title)

isotopp | 4 years ago

If you are not running a database at home, you have the database in a replication setup.

That provides capacity, but also redundancy. Better redundancy than at the disk level - fewer resources are shared.

https://blog.koehntopp.info/2021/03/24/a-lot-of-mysql.html Here is how we run our datatbases.

discuss

order

tyingq|4 years ago

"If you are not running a database at home, you have the database in a replication setup."

That's one of the perceptions I'm saying isn't always true. Especially in big, non-tech companies that have a mish-mash of crazy legacy stuff. Traditional H/A disks and backups still dominate some spaces.

AstralStorm|4 years ago

Backups that are easily restored trump replication for so many cases and much more cheaply. High availability is overrated when you have spare preconfigured commodity hardware you can spin up in minutes, which is often perfectly acceptable human time scale. You really don't need the other insurance running all the time - that only makes it more fragile.

Only really huge services would care about downtime of this degree, or horizontal scaling.