3 ms·
There will be atomic DDLs, which is great. I didn't understand if this means that a DB migration altering multiple tables can be embedded in a transaction and r
by pmontra 9y ago
There will be atomic DDLs, which is great. I didn't understand if this means that a DB migration altering multiple tables can be embedded in a transaction and rolled back in case of errors, like with PostgreSQL, or if it's only the single operation that became safer.
- morgo 9y agoThe short answer is that it is only single operations that become safer. I don't want to undersell it though: some single operations require multiple steps (i.e. DROP SCHEMA in 5.7 needs to unravel all the tables it discovered and making sure a replica slave produces the same result. 8.0+ does this much cleaner). So it still remains important to have.