3 ms·
Back in the day (i.e. long before Oracle purchased MySQL), if you wanted an open source database, you had two choices: Postgres, which was reliable, and MySQL,
by smacktoward 9y ago
Back in the day (i.e. long before Oracle purchased MySQL), if you wanted an open source database, you had two choices: Postgres, which was reliable, and MySQL, which was fast. It turned out there were a lot more people who cared about being fast than there were who cared about reliability.
Eventually Postgres got fast enough and MySQL got reliable enough, which has made the distinction between them somewhat fuzzier today. But by then MySQL had become the standard database offered by umpty zillion web hosts, and ubiquity is a hard position to dislodge someone from.
- VectorLock 9y ago>Postgres, which was reliable My experience recently and historically has been the exact opposite. Postgres seems to blow up in more mysterious and hair-yankingly frustrating ways than MySQL does. "Why Uber Engineering moved from Postgres to MySQL" echos a lot of the issues I've had with Postgres in large production environments.
- philliphaydon 9y agoUber’s use of PostgreSQL was a mess. It’s probably the worst example of why not to use PostgreSQL.
- ausjke 9y agohttps://lwn.net/Articles/752063/ https://lwn.net/Articles/752063/ PostgreSQL's fsync() surprise this is very scary, if not fatally scary.
- sterwill 9y agoI can't read it because it's paywalled, but how is the operating system's fsync behavior "fatally scary" with regards to PostgreSQL? How does MySQL handle durability in these cases? What's your point?
- severine 9y agohttps://lwn.net/SubscriberLink/752063/5a5e2ebd8bcf3129/ https://lwn.net/SubscriberLink/752063/5a5e2ebd8bcf3129/
- macdice 9y agoI think it is scary about Linux. They are still wrestling with reliable error reporting for buffered IO after decades, and while the changes in 4.13 are an improvement in some ways they make some highly questionable assumptions that don't seem to be based on POSIX. I'm not following it in detail but fortunately it sounds like something might be done to improve the situation on the Linux side?
- ExactoKnight 9y ago>MySQL got reliable enough MySQL still doesn't support nested DDL's, and this has caused me extreme amounts of pain in old projects where consistency was expected and we did not receive it on crucial payment processing.