Posted September 7, 20231 yr To facilitate seamless migration from Azure Database for MySQL - Single Server to Flexible Server, we’re pleased to announce smart defaults for Azure MySQL Import, further reducing inputs required to trigger a Single to Flexible Server migration. With Azure MySQL Import Smart Defaults, businesses can now migrate an Azure Database for MySQL single server to an Azure Database for MySQL flexible server by running a single CLI command with minimal inputs! We have implemented smart defaults for 10 inputs required for target Flexible Server provisioning. Additionally, we have marked 4 erstwhile required parameters (tier, version, storage-size, sku-name) as optional in light of the above change. Admin login and password are copied over from the Single Server instance implicitly and any inputs passed for them through the CLI command would be redundant. Azure MySQL Import uses snapshot backup and restores technology to offer a simple and fast migration path to restore the source server's physical data files to the target server. Azure 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. The key features of Azure MySQL Import include the following: Supports Azure Database for MySQL - Single Server as data source. Provisions target Flexible Server based on smart defaults from source Single Server and consequently triggers import. Supports schema, data and logins import. Fast data backup and restore to target, suitable for bigger workloads. The following example takes in the data source information for Single Server named 'test-single-server' and target Flexible Server information and performs an import from source to target. 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" For more information about using Azure MySQL Import for offline migration of workloads to Azure Database for MySQL – Flexible Server, see the following documentation: Migrate Azure Database for MySQL - Single Server to Flexible Server using Azure MySQL Import CLI | M... 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! Continue reading...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.