Azure DMS statement replication support for MySQL v8.0 and v5.7 workloads (Preview)
Published Nov 06 2023 11:02 AM 2,424 Views
Microsoft

We’re pleased to announce that Azure DMS now provides preview support for replication of data definition and administration statements for MySQL v8.0 and v5.7 workloads, which businesses can use to migrate databases to Azure while those databases remain operational. This feature is designed to enable seamless migration of workloads that create, load, and drop temporary tables on the sources, as well as for workloads that truncate a table and then load it with data.

 

Note: While this functionality allows you to run select data definition and administration statements during the replication phase of migration, it’s still recommended to exercise caution while making schema, security, or permission changes during a migration to ensure a consistent state post-migration.

 

Statement replication support

Details about the support associated with statement replication are covered in the following points.

  • The replication feature supports replicating data definition and administration statements that occur after the initial load and are logged in the binary log to the target.
  • This functionality supports both the online migration and replicate changes scenarios migration.
  • The statement replication feature is currently supported when migrating to a target Azure Database for MySQL flexible server running MySQL v8.0 or v5.7.
  • To enable replication of data definition and administration statements, in the Azure DMS migration wizard, on the Select Databases tab, under Server migration options, select Replicate data definition statements

    Image1a.png
  • Statement replication is supported for databases, tables, and schema objects (views, routines, triggers) that are selected for schema migration when configuring an Azure DMS migration activity. Data definition and administration statements for databases, tables, and schema objects that aren’t selected won’t be replicated. Selecting an entire server for migration will replicate statements for any tables, databases, and schema objects that are created on the source server after the initial load has completed.

    Image2a.png
    Image3a.png

 

Data Definition statement support

Azure DMS statement replication supports all of the Data Definition statements listed here, with the exception of the following commands:

  • LOGFILE GROUP statements
  • SERVER statements
  • SPATIAL REFERENCE SYSTEM statements
  • TABLESPACE statements

 

Data Administration – Account Management statement support

Azure DMS statement replication supports all of the Data Administration – Account Management statements listed here, with the exception of the following commands:

  • SET DEFAULT ROLE
  • SET PASSWORD

 

Data Administration – Table Maintenance statement support

Azure DMS statement replication supports all of the Data Administration – Table Maintenance statements listed here, with the exception of the following commands:

  • REPAIR TABLE
  • ANALYZE TABLE
  • CHECKSUM TABLE

 

Summary

Customers have long asked for support for replicating data definition and administration statements as part of MySQL migrations, which would enable real-time migration. By offering our customers this feature in preview, we hope to enable the ability to perform some critical database-level changes and provide for seamless replication to the target server.

 

If you have any feedback or questions about the information provided above, please leave a comment below or email us at AskAzureDBforMySQL@service.microsoft.com. Thank you!

Co-Authors
Version history
Last update:
‎Dec 18 2023 11:28 AM
Updated by: