Azure SQL Database auto-failover groups

The auto-failover groups ( Preview)  feature is regards to the Azure SQL HA and it’s combination of Active geo-replication.

Active geo-replication leverages the Always On technology of SQL Server to asynchronously replicate committed transactions on the primary database to a secondary database using read committed snapshot isolation (RCSI). Auto-failover groups provide the group semantics on top of active geo-replication but the same asynchronous replication mechanism is used.

auto-failover groups (in-preview) gives you listener ( read-write and read-only ) end-point which you can configure to application code ( connection string ) , during the  failover  end-point remain unchanged and no need change application code ( it’s automatic failover ) .

read more

Leave a Reply

Your email address will not be published. Required fields are marked *