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
English - March 05, 2020 03:29 - 6 minutes - 4.63 MB - ★★★★★ - 5 ratingsTechnology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: Episode 134 - gRPC
Next Episode: Episode 136 - Sidecar Proxy (Pros and Cons)
MySQL 8.0 supports atomic Data Definition Language (DDL) statements. This feature is referred to as atomic DDL. 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.
I discuss mySQL 8.0 atomic ddl compared to Postgres transactional ddl