Episode 135 - mySQL 8.0 has a new feature called Atomic DDL and it is not what you think

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Thu, 05 Mar 2020 03:29:52 GMT

<p>MySQL 8.0 supports atomic Data Definition Language (DDL) statements. This feature is referred to as <em>atomic DDL</em>. An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic transaction. The transaction is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the operation.</p> <p>I discuss mySQL 8.0 atomic ddl compared to Postgres transactional ddl</p>