You plan to migrate on-premises MySQL databases to Azure Database for MySQL Flexible Server. To ensure the databases remain accessible if a datacenter fails while minimizing cost, which compute tier should you select?

The General Purpose compute tier is the correct choice because it offers a balance of compute, memory, and I/O resources suitable for most business workloads, including those requiring high availability. It supports zone-redundant high availability, which ensures database accessibility even if an entire datacenter fails, by replicating data across different availability zones within an Azure region. This meets the requirement for minimizing downtime during a datacenter outage. The Burstable tier is designed for workloads with infrequent or burstable CPU usage and is not recommended for production workloads requiring consistent performance and high availability. The Memory Optimized tier is for high-performance, in-memory workloads and is significantly more expensive, exceeding the requirement for cost minimization.