Automatic Backup in Mysql flrxible server

Question

I am working with an Azure MySQL Flexible Server and would like to understand how to configure automatic backups and restore points effectively. I have read through the documentation but still have some questions.

How can I configure automatic backups for my MySQL Flexible Server? Is this feature enabled by default, and if so, how can I customize the backup retention period?

Does enabling backups and restore points incur additional costs? If so, how are the costs calculated for backup storage?
Any insights, best practices, or considerations would be greatly appreciated

THANKS

Answer 1

@DataCoder
Thank you for the question and for using Microsoft Q&A platform.

Automatic backups are enabled by default for Azure MySQL Flexible Server. The service takes snapshot backups of the data files and transaction logs, storing them in local redundant storage within the region. Snapshot backups are taken daily, and transaction log backups occur every five minutes.

Azure Database for MySQL Flexible Server provides up to 100% of your provisioned server storage as backup storage at no additional cost. For example, if you have provisioned a server with 250 GB of storage, you have 250 GB of storage available for server backups at no extra charge.

Any additional backup storage used beyond the provisioned amount is charged in GB per month. Azure Backup charges a protected instance fee based on the size of the database (in gigabytes) per-unit.

You can refer to the below links for more help:
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
https://learn.microsoft.com/en-us/azure/backup/backup-azure-mysql-flexible-server-about
https://learn.microsoft.com/en-us/azure/backup/backup-azure-mysql-flexible-server-support-matrix

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.