Thanks for the feedback.
The Azure DB for MySQL service is managed at the server level, so restoring at the database level is not something we are planning to support.
Backups are taken automatically by the service. If you want to store them in a storage account, you set up a script to do a MySQL dump and store them in Azure Storage.
Support for up to five read-only replicas within the same region is now in public preview. This feature is aimed to scale out read-heavy workloads.
Check out the documentation to learn more about replicas:
- Overview: docs.microsoft.com/en-us/azure/mysql/concep..
- How to create replicas from the portal: docs.microsoft.com/en-us/azure/mysql/howto-..
Azure CLI support will be following shortly.
Andrea Lam on behalf of the Azure Database for MySQL product team