Backup and Terminate Azure Database for MySQL

Question

Hello.

I would like to ask for help regarding our Azure Database for MySQL service. We are conducting a cost-saving process and found that one of our database is currently not in use by our system. Could you please provide the procedure for backing up and terminating the service? We want to back it up as we may need to redeploy it in the future if we decide to continue the project. Additionally, are there any costs associated with the backup, termination, and redeployment process?

Thank you!

Answer 1

Hi @jb_devel,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Here’s a step-by-step guide for backing up and terminating your Azure Database for MySQL service, along with information on associated costs:

Backing Up Your Azure Database for MySQL

1.Trigger an On-Demand Backup:

• Go to the Azure portal and select your Azure Database for MySQL flexible server instance.
• Under Settings, select Backup and restore from the left panel.
• On the Backup and restore page, select Backup Now to trigger an on-demand backup.

2.Automated Backups: Azure Database for MySQL automatically creates server backups and stores them in local redundant storage. These backups can be used to restore your server to a point-in-time within your configured backup retention period.

3.Exporting Backups: You can export backups to an Azure storage account (Azure Blob Storage) for long-term storage.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore#backup-overview

Terminating the Service

Delete the Database:

• In the Azure portal, navigate to your Azure Database for MySQL instance.
• Select Delete from the top menu.
• Confirm the deletion by typing the database name and selecting Delete.

Redeploying the Database

Restore from Backup:

• To redeploy the database, you can restore it from the backup stored in Azure Blob Storage or from the automated backups.
• In the Azure portal, go to Backup and restore and select the backup you want to restore from.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore#restore

Costs associated with backup, termination, and redeployment.

• Azure Backup charges a protected instance fee based on the size of the database (in gigabytes) on a per-unit (250-GB) basis. Backup storage fees apply for storing backups in the Standard vault tier.
• There are no direct costs associated with terminating the service but ensure that you have exported or backed up all necessary data before deletion.
• Costs for redeployment will depend on the compute and storage resources you provision for the new instance. You can use the Azure Pricing Calculator to estimate these costs.

For more information, please refer the documents:

https://learn.microsoft.com/en-us/azure/backup/backup-azure-mysql-flexible-server-about

https://azure.microsoft.com/en-us/pricing/details/mysql/

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.