Microsoft Azure Data FundamentalsDescribe how to work with relational data on AzureMedium
A global e-commerce company uses Azure Database for MySQL to power its storefront. To improve read scalability and reduce latency for users in different geographical regions, the company wants to distribute read-only copies of its database. Which feature of Azure Database for MySQL should be configured?
- APrivate Link
- BHigh Availability (HA)
- CGeo-restore
- DRead Replicas
Show answer & explanationAnswer & explanation
Correct answer: D. Read Replicas
Read Replicas in Azure Database for MySQL allow you to replicate data from a primary server to up to ten read-only replica servers. This improves read scalability and can reduce latency by serving read queries from closer replicas.
Why the other options are wrong
- A. Private Link provides private connectivity to Azure services over a private endpoint, enhancing security but not directly addressing read scalability or latency for distributed users.
- B. High Availability (HA) ensures continuous operation in case of failures but does not inherently improve read scalability or distribute read workloads geographically.
- C. Geo-restore is a disaster recovery feature that allows restoring a database to a different geographical region, not for improving read scalability.
Azure DB for MySQL Read Replicas
Read Replicas allow you to scale out read-heavy workloads from an Azure Database for MySQL primary server to multiple read-only replica servers.
- Improves read scalability and performance.
- Can be in the same or different regions.
- Asynchronous replication from primary to replicas.
Memory trick: Read Replicas: Replicate Reads, Reduce Latency.