🔥 Make sure you star the repo to keep up to date with new tips and tricks.
💡 Learn more : Read Replicas in Azure Database for MySQL
Author: Kumar Allamraju Twitter: @kumarallamraju
The read replica feature allows you to replicate data from an Azure Database for MySQL server to a read-only server. You can replicate from the master server up to five replicas. Replicas are updated asynchronously using the MySQL engine's native binary log (binlog) file position-based replication technology.
The read replica feature helps you to improve the performance and scale of read-intensive workloads. Read workloads can be isolated to the replica instances, while write workloads can be directed to the master instance. A common scenario is to have BI and analytical workloads use the read replica as the data source for reporting.
Please note that the read replica feature uses MySQL asynchronous replication. This feature isn't meant for synchronous replication scenarios. There will be a measurable delay between the master and the replica instance. The data on the replica eventually becomes consistent with the data on the master.
You can also create a read replica in a different Azure Region when creating the read replica. This can help you to serve clients in different geographic regions more quickly.
In few steps we will learn to create a read replica for Azure managed MySQL database. This article assumes you have already created a Azure MySQL database instance. If not, pls refer to this posting to create a new MySQL server in Azure.
Replicas are new servers that are similar to regular Azure Database for MySQL servers. For each read replica, you're billed for the provisioned compute in vCores and storage in GB/ month.
Database Read Replica(s) helps in decreasing load on the primary DB by serving read-only traffic. Read replicas allow you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. Cross-region replication can be helpful for scenarios like disaster recovery planning or bringing data closer to your end users. In this article, we learned to create a read replica from an existing MySQL master instance in the same azure region or a different region.