Making DDL's Atomic in MariaDB

Crash safety is one of the requirements of modern databases. Although DML is crash safe (depending on storage engine), DDL is still problematic. MariaDB 10.6 will implement atomic DDL. Currently RENAME and DROP are fully supported for all database objects and the goal is to implement all remaining o...

Full description

Bibliographic Details
Main Author: Widenius, Michael Monty
Format: Article in Journal/Newspaper
Language:English
Published: FOSDEM VZW 2021
Subjects:
DML
Online Access:https://dx.doi.org/10.5446/52713
https://av.tib.eu/media/52713
Description
Summary:Crash safety is one of the requirements of modern databases. Although DML is crash safe (depending on storage engine), DDL is still problematic. MariaDB 10.6 will implement atomic DDL. Currently RENAME and DROP are fully supported for all database objects and the goal is to implement all remaining operations. This talk will go into the technical details of the atomic DDL implementation, explaining how it provides crash safety.