Re:One Giant Leap for SQL: MySQL 8.0 Released
by ExactoKnight on Wednesday April 25, 2018 @02:30PM
(#16924528)
>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.
Re:One Giant Leap for SQL: MySQL 8.0 Released
by VectorLock on Wednesday April 25, 2018 @02:09PM
(#16924328)
>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.
Re:One Giant Leap for SQL: MySQL 8.0 Released
by philliphaydon on Wednesday April 25, 2018 @09:46PM
(#16928167)
Uber’s use of PostgreSQL was a mess. It’s probably the worst example of why not to use PostgreSQL.
Re:One Giant Leap for SQL: MySQL 8.0 Released
by ausjke on Wednesday April 25, 2018 @02:29PM
(#16924524)
https://lwn.net/Articles/752063/
PostgreSQL's fsync() surprise
this is very scary, if not fatally scary.
Re:One Giant Leap for SQL: MySQL 8.0 Released
by macdice on Wednesday April 25, 2018 @04:18PM
(#16925630)
I 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?
Re:One Giant Leap for SQL: MySQL 8.0 Released
by sterwill on Wednesday April 25, 2018 @03:00PM
(#16924882)
I 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?
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.