Best practices for safely performing schema changes in Azure Database for MySQL

SiddhantSawant

Microsoft

Dec 16, 2024

Learn how MySQL’s online DDL operations can affect your data and explore best practices to protect your tables during ALTER TABLE and OPTIMIZE TABLE operations.

Azure Database for MySQL - Flexible Server is built on the open-source MySQL database engine, and the service supports MySQL 8.0 and newer versions. This means that users can take advantage of the fl...

Updated Dec 16, 2024

Version 1.0

Microsoft

Joined March 08, 2022

View Profile

Azure Database for MySQL Blog

Follow this blog board to get notified when there's new activity

Sergei Stepanov

Copper Contributor

May 01, 2026

Is this bug still active? Was if fixed for 8.0 and 8.4 flexible?

Sudheesh_N

Microsoft

May 03, 2026

As per the community bug links (MySQL Bugs: #115608: Inplace ALTER TABLE might cause lost rows if concurrent purge and MySQL Bugs: #115511: Inplace ALTER TABLE might fail with duplicate key error if concurrent insertions) the issue is fixed in MySQL Server 8.0.41, 8.4.4. Our current running versions are 8.0.44 and 8.4.7 (Version Support Policy | Microsoft Learn ) , so this should be fixed.

Blog Post

Best practices for safely performing schema changes in Azure Database for MySQL

Learn how MySQL’s online DDL operations can affect your data and explore best practices to protect your tables during ALTER TABLE and OPTIMIZE TABLE operations.