Blog Post

Azure Database for MySQL Blog
5 MIN READ

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

SiddhantSawant's avatar
SiddhantSawant
Icon for Microsoft rankMicrosoft
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
azure
bug fixes
Bugs
data loss
data loss prevention
flexible server
High Availability
MySQL
opensource
PERCONA
MarcinKoperski's avatar
MarcinKoperski
Copper Contributor
Feb 03, 2025

Hello Microsoft. Could you please explain why this information placed in "best practices" page and not send to all your customers using MySQL 8 as critical issue ?

  • SiddhantSawant's avatar
    SiddhantSawant
    Icon for Microsoft rankMicrosoft
    Feb 10, 2025

    Thank you for your feedback! This blog is intended to share best practices for safely performing schema changes in Azure Database for MySQL. As the behavior discussed in the blog originates from the MySQL Community Edition, we aim to provide guidance through blogs and documentation to help customers effectively manage such scenarios.
    We are committed to providing valuable insights that support the broader MySQL community. We appreciate your engagement and look forward to supporting you!