Crash-safe DDL of InnoDB tables in MariaDB Server 10.6

Abstract

When the running server is killed at any time while using a crash-safe storage engine, it is expected to recover to a consistent state. The Atomic DDL in the server core that prevents tablename.frm files from getting out of sync with InnoDB turned out not to be the silver bullet. Several sources of inconsistencies were identified and addressed in the InnoDB layer, by making DDL transactions cleaner. No InnoDB file format was changed.

Other links

Date and time

  • Wednesday 6 October, 16.45 – 17.35 CEST (UTC +2)
  • 10:45am – 11:35am New York time,
  • 22:45 – 23:35 Beijing/Singapore time

Presenters

Marko Mäkelä
Software developer – MariaDB Corporation

Marko Mäkelä holds a doctoral degree in theoretical computer science. He has worked on the InnoDB storage engine since 2003. He joined MariaDB Corporation in 2016 as Lead Developer InnoDB. He loves to tinker with low-level code, old computers, embedded systems, and bicycles.