All Products
Search
Document Center

ApsaraDB RDS:Does ApsaraDB RDS for MySQL support online DDL operations? How do I perform online DDL operations on an ApsaraDB RDS for MySQL instance?

Last Updated:Aug 24, 2023

Yes, ApsaraDB RDS for MySQL supports online DDL operations since MySQL 5.6 because online DDL operations are supported in open source MySQL from MySQL 5.6. You can perform online DDL operations to change the schemas of tables on an ApsaraDB RDS for MySQL instance without causing issues that block DML operations. For more information about how to perform online DDL operations on an ApsaraDB RDS for MySQL instance, see the official MySQL manuals.

Reference manuals

Related features

Data Management (DMS) also allows you to change the schemas of tables without locking the tables. For more information, see Perform lock-free DDL operations.