Azure SQL Database Continued
- Azure SQL Replications and Failovers
- Replication is a technique where data gets replicated across other database.
- Replication is used to mitigate performance issues by redirecting all the reads from secondary database and all the write operations from primary database.
- Read operations are also used for Analytics.
- Lets create an Azure SQL Database
- Now lets create a replica
- Replications are of two types
- synchronous Replications
- Asynchronous Replications
- Azure supports autofailover using failover groups which can be configured on server