MySQL 8.0: Atomic DDLs - Implementation and Impact

Tuesday 2:20PM-3:10PM

@ Goldsmith 1

MySQL / MariaDB

50 minutes conference

Intermediate

Tracks:
Operations

MySQL 8.0 implements atomic and crash-safe DDL. We will discuss how this affects behaviour of individual DDL statements, binlog and crash-safeness. We will also discuss the role of InnoDB as a data dictionary SE and a user tables SE, and touch upon requirements for writing a data dictionary SE for MySQL.
MySQL 8.0 implements I_S as views over dictionary tables stored in InnoDB. There are legacy features that require queries to SE. What is the impact of this, and how to make a compromise between updated and fast information.


Speakers

Ståle Deraas

Ståle Deraas (Oracle)

Senior Engineering Manager

Biography:

Ståle Deraas has been working with MySQL Database team since 2008. He is currently employed by Oracle, based in Norway. He is Senior Software Development Manager for the runtime team of the MySQL Database. He has a background in the database industry, working for Sun Microsystems on Java DB, and prior to that on Software Development Tools. He has a B.Sc Hons degree in Computing Science from the University of Glasgow.


Percona Live

Percona Live Europe starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA