3 ms·
it's not like Postgres/MySQL/etc are operational nightmares Every database is an operational nightmare. Just wait until MySQL segfaults every time it gets more
by aphyr 14y ago
it's not like Postgres/MySQL/etc are operational nightmares
Every database is an operational nightmare. Just wait until MySQL segfaults every time it gets more than 4 SSL connections at once, or takes four hours to warm up its inno cache. Or Cassandra compaction locks up a node so hard its peers think its down, turning your cluster into a recursive tire fire of GC. Or a Riak node stops merging bitcask and consumes all your disk in a matter of hours. Or Mongo ...
My point is that every database comes with terrifying failure modes. There is no magic bullet yet. You have to pick the system which fits your data and application.
- lwat 14y agoYou don't seem to have any experience with solid, mature RDBMSs like PostgreSQL or Oracle or SQL Server. MySQL sucks in so many ways and all the other names you mentioned are not RDBMSs. People running large numbers of (for example) MS SQL Servers will tell you that they are ridiculously robust and mature and do NOT randomly crash in the middle of the night. And even when your hardware lets you down your hot failover machine is ready to take over without skipping a beat. Magic bullet? These systems are the closest you can find in the world of software.
- aphyr 14y ago<sigh> Or when the Oracle SCN advances too quickly, causing random systems to refuse connections or crash outright. Just because software is large, supported, and mature doesn't mean it is free of serious design flaws. [Edit:] Don't get me wrong, Oracle's DBs are serious business; an incredible feat of engineering. If I could afford them I'd probably use them more often. But everything in this business is a cost tradeoff--in licenses, in dev time, in risk.
- lwat 14y agoFYI PostgreSQL is free.
- aphyr 14y agoAware Postgres is free: it's an excellent database and I've used it successfully (like most of the other tools I've mentioned.) It also has spectacular failure modes; though the only ones I've personally encountered were around vacuuming.
- lwat 14y agoSo if these incredibly mature and robust systems are an 'operational nightmare' I'd like to hear what software systems ARE up to your operational standards? How often did you manage to spectacularly fail PostgreSQL to qualify it an 'operational nightmare'?
- aphyr 14y agohttp://news.ycombinator.com/item?id=3974403 http://news.ycombinator.com/item?id=3974403 (reply threshold is high enough for me to post now)
- whatusername 14y agoI wonder if NonStop SQL ( http://en.wikipedia.org/wiki/NonStop_SQL http://en.wikipedia.org/wiki/NonStop_SQL ) might count..