Data backup and restore on mysql

Koteswara Pentakota 71 Reputation points
2022-04-22T17:04:51.57+00:00

We configured Mysql database with a backup of 30 days. As part of our ISO Audit process we were asked to show the successful data backup alerts happening every day. At the same time we were also asked to show a successful restore.

While we see that the backup is configured successfully we do not have any alerts which show that it is backed up successfully. Is there a way to configure alerts. The other problem is we need to show proof that we can restore the backed up data atleast once even if it is on a lower environment.

When we tried to do a backup we found that it is asking us to create a new server altogether to restore the backed up data, while we want to restore the data to a specific date and time in the same server (We were using Code guard service earlier using which we can perform this restoration). How do we achieve this. If this can be done only onto a new server do we have to change all the existing connections of app services to this new database? Is this how it is designed?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
718 questions
Azure ISV (Independent Software Vendors) and Startups
Azure ISV (Independent Software Vendors) and Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.ISV (Independent Software Vendors) and Startups: A Microsoft program that helps customers adopt Microsoft Cloud solutions and drive user adoption.
89 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,576 Reputation points
    2022-04-26T06:19:36.923+00:00

    Thanks for replying back @Koteswara Pentakota .

    For single servers we can create an alert on resource group/subscription that can notify us on create/update of any new Azure MySQL Server as mentioned below, but this is not just limited to restore.

    196445-image.png

    However, for backups we dont have any direct alert available but we can use 'Backup Storage Used' alert and set up with a value that could trigger an alert.

    Just one more thing we wanted to bring is Single server is running with existing feature only and more features/new changes are being done on Flexible Server side and the recommendation from us is to start using the flexible server. We also have a backup and restore blade in Flexible Server that lists out all the backup taken by azure.

    196308-image.png

    More features are being added on Flexible Server and I would request you to please explore it once.

    Please let us know if you have any other queries and we can continue discussion.