Re:Why Uber Engineering Switched from Postgres to MySQL (2016)
by tpetry on Sunday February 28, 2021 @03:02AM
(#26291557)
Mysql 8 supports atomic ddl, which means if you drop two tables in a single DROP TABLE query either both are deleted or none. But it does not support postgresql‘s transactional ddl feature where you can start a transaction change the structure of multiple tables, change some data etc. and commit at the end.
Mysql 8 males ddl changes atomic, but does not support transactional mode where you could rollback them.
Mysql 8 males ddl changes atomic, but does not support transactional mode where you could rollback them.