If a whole zone failure takes out a mysql single server, will you still have access to backups?

Question

I am assuming that a single server can't auto recover from a whole zone failure, since that's a feature of flexible? Is that correct?

But after such a failure, will backups be available? Are backups zone redundant?

Accepted Answer

Found the storage redundancy docs:
https://video2.skills-academy.com/en-us/azure/storage/common/storage-redundancy

So the answer is, locally redundant backups are within a given zone so won't be available if the zone goes down.

Answer

@alex Thank you for reaching out.
Our sincere apologies for the delay in getting back to you.

Azure database for MySQL provides options to backup to locally redundant or geo-redundant storage.
You can choose an option as per your requirement, while creating the server.

If an entire region is experiencing an outage, and if you do not have a geo-redundant backup, you cannot recover from backup and create a new server in another region.
So, if you need complete backup redundancy, you should backup to geo-redundant storage.

If you want to manage the backups yourself, you can use mysqldump to back up the database and store the files at a location of your choice.

Please let me know if you have further questions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

Share via

If a whole zone failure takes out a mysql single server, will you still have access to backups?

1 additional answer

Your answer