Question

A retail company runs its e-commerce order database on Azure Database for MySQL Flexible Server in the East US region. The business requires that the database survive a single datacenter failure within the region with automatic failover, an RPO of zero for committed transactions, and the ability to restore the database to any point within the last 14 days in case of accidental data corruption. Which configuration meets all of these requirements with the least administrative effort?

Accepted Answer

Deploy the server with zone-redundant high availability and configure the backup retention period to 14 days.

Answer

Deploy the server with same-zone high availability and enable geo-redundant backups with default 7-day retention.

Answer

Deploy a single-zone server and create read replicas in two other availability zones, scheduling nightly logical backups with mysqldump.

Answer

Deploy the server with zone-redundant high availability and rely on the default 1-day backup retention, taking manual on-demand backups weekly.