3 ms·
RDS is expensive. People still treat their databases like mainframes; just make the machine bigger to get better performance, and use more reliable components
by jrockway 7y ago
RDS is expensive.
People still treat their databases like mainframes; just make the machine bigger to get better performance, and use more reliable components to decrease the risk of data loss or downtime. Amazon is happy to take your money to manage that for you. Their profit margin exists in you being scared of what can go wrong, and the ease of getting things set up.
(I don't have a good suggestion for an alternative to this approach. The design of commonly-used relational databases surprises me. They all assume disks have some sort of intrinsic durability. Disk manufacturers all make you pay extra money to maintain this illusion; underprovisioning, wear leveling, background garbage collection, hardware RAID. But at the end of the day, it can all just get sucked up by a tornado (or a rogue shell script) and all that means nothing. I do not understand why disks are not just dumb blocks of NAND flash connected directly to the application, which can then provide cross-datacenter redundancy and save everyone a ton of money. I guess that is why Google makes their own SSDs and their own planet-scale database engine. They know it's silly. The rest of us are stuck with expensive garbage that is, with 100% certainty, going to fail. Who to blame is all that we can work around, and blaming Amazon is better than blaming yourself!)
- jeremyjh 7y agoDistributed systems bring their own problems. I've seen more production outages caused by poorly coded or configured HA setups than due to any single-host level hardware failure. I remember one application where a 60 second network outage caused a forty minute database outage due to HA supervisors going batshit. What works well are simple setups like async log shipping to another site with manual fail-over. If you think you cannot afford 30 minutes downtime there is really no amount of money you can spend to be sure you are improving your chances.
- EricE 7y ago> I've seen more production outages caused by poorly coded or configured HA setups than due to any single-host level hardware failure. Me to! HA is fiendishly difficult and often dramatically underestimated - until things go sideways and fail in unanticipated ways, of course :)