Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few limitations like
* No transparent failover capabilities like Always on Listener
* No availability groups and group failover possible
So, Azure Failover Groups provides "Read Only" / "Read Write" connection URLs which allows applications transparent failovers. Read only and Read write workloads get different connection strings and upon failover, applications connect to the appropriate node automatically
Also, one can combine group of databases as a unit of failover and make them failover together as well, as done in Always on availability groups.Β
Step by step instructions on configuring availability groups provided below
* Configure Primary Server, Secondary Server and Geo Replication as explained inΒ http://strictlysql.blogspot.sg/2017/05/sql-azure-databases-active-secondary.html
*Β Click on the primary server ( not database ) and select failover groups
* Click on the add group and
Β Β Β Β Β * Pick the existing database "db1" to be added to the failover group
Β Β Β Β Β * Pick the existing secondary server
Β Β Β Β Β * Click on create