Wednesday, November 20, 2019

Data Platform Tips 4 - Geo-replication vs. Failover groups

Active geo-replication allows to create readable replicas and manually failover to any replica in case of a data center outage.

Auto-failover group allows the application to automatically recovery in case of a data center outage.


Features
Geo-replication
Failover Groups
Automatic Failover
No
Yes
Failover multiple databases simultaneously
No
Yes
Update Connection string after failover
Yes
No
Manage Instance supported
No
Yes
Can be in the same region as primary
Yes
No
Multiple Replicas
Yes
No
Supports Read on secondaries
Yes
Yes

No comments:

Post a Comment