To facilitate seamless migration from Azure Database for MySQL - Single Server to Flexible Server, we’re pleased to announce smart defaults for Azure Database for MySQL Import, further Azure Database for MySQL Import uses snapshot backup and restore technology to offer a simple and fast migration path to restore the source server's physical data files to the target server. Azure Database for MySQL Import currently supports the offline mode of import. Based on user-inputs, it takes up the responsibility of provisioning your target Flexible Server based on mappable server properties (tier, version, sku-name, storage-size, location, geo-redundant-backup, public-access, tags, auto grow, backup-retention-days, admin-user and admin-password) from Single Server without requiring user input and then taking the backup of the source server and restoring it on the target.
Key features of Azure Database for MySQL Import include:
- Support for Azure Database for MySQL - Single Server as data source.
- Provisioning a target flexible server based on smart defaults from the source single server, consequently triggering import.
- Support for importing schema, data and logins.
- Fast data backup and restore to target, suitable for bigger workloads.
The following example takes in the data source information for a single server named 'test-single-server' and target flexible server information and performs an import from source to target. The Azure Database for MySQL Import command maps over the corresponding tier, version, sku-name, storage-size, location, geo-redundant-backup, public-access, tags, auto grow, backup-retention-days, admin-user and admin-password properties from Single Server to Flexible Server as smart defaults, if no inputs are provided to the CLI command.
You can choose to override the smart defaults by providing inputs for these optional parameters. Additionally, you can choose to enable high availability and virtual network integration by providing input for the corresponding parameters.
az mysql flexible-server import create --data-source-type "mysql_single" --data-source "test-single-server" --resource-group "test-rg" --name "test-flexible-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!