News for hackers. Stuff that matters.

A comment on Django zero-downtime migrations for Postgres that respect database locks. Parent comment

Re:Django zero-downtime migrations for Postgres that respect... by Doxin on Tuesday October 23, 2018 @07:35AM (#18282473)
I'm not even sure this is possible in mysql. Last time I checked mysql still couldn't do DDL statements in a transaction.
[ Parent | on HN ]
Re:Django zero-downtime migrations for Postgres that respect... by lloeki on Tuesday October 23, 2018 @10:38AM (#18283718)
Last time I checked MySQL even silently commits out of the transaction and proceeds with the remainder of the queries.

Here are the "implicit commit" statements:

https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html

[ Parent | on HN ]
Re:Django zero-downtime migrations for Postgres that respect... by Doxin on Thursday October 25, 2018 @08:35AM (#18300380)
Honestly I don't see a single good reason for any new project to use mysql over postgres. mysql is almost universally terrible at actually being a database.
[ Parent | on HN ]
Re:Django zero-downtime migrations for Postgres that respect... by fredley on Tuesday October 23, 2018 @12:01PM (#18284540)
In Django it doesn't, it just dumps you out with a fucked-up semi-migration that takes you 20 minutes to get back to a consistent state...
[ Parent | on HN ]