70. Azure SQL failover groups
https://www.betabit.nl/en/betatalks
In this Betatalks episode, Oscar & Rick will talk about Azure SQL failover groups. Failover groups are a way to increase availability for Azure SQL. They will show you how you can set up a failover group with a replicated secondary database in another region using Bicep. Next to the obvious disaster scenario where this would help, you will also have read-only endpoints on all the failover databases in the different regions that you could actively use in your application design.
Timestamps
00:35 – Failover groups
02:18 – SQL Server - Failover groups demo
04:48 – How was it before failover groups
05:10 – Failover groups demo continued
07:20 – Creating a failover group
09:40 – The trickiness with failover groups
11:36 – Failover group deployment
13:20 – Server one and server one secondary
13:43 – Failover group configuration details (picture)
15:04 – Failover group endpoints
19:52 – Tips from Oscar
Links for more information on Azure SQL failover groups:
https://learn.microsoft.com/en-us/azu...
Join us on our Discord channel: / discord
There is more to come!
https://www.betabit.nl