This post has been republished via RSS; it originally appeared at: Microsoft Data Migration Blog articles.
We’re pleased to announce that Azure DMS now provides preview support for replication of data definition and administration statements for MySQL v8.0 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.
- 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…
- 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.
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
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.
We plan to include support for statement replication for MySQL v5.7 workloads in future releases, so stay tuned!
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!