Lesson Learned #425:Azure SQL Database Failover Group Endpoint: A Deep Dive into DNS Resolution
Today, we got a service request where our customer is facing connectivity issue using Azure SQL Database Failover Group Endpoint howerver using the IP of the Azure SQL Server Primary they didn't see any connectivity problem. The Azure SQL Database service offers robust features to ensure high availability and disaster recovery. One of these is the Failover Group, which permits seamless switchover between a primary and a secondary database. In this technical exploration, I would like to share with you how the Failover Group endpoint leverages DNS to route traffic and how we can determine to which IP it is currently resolving. We found that the customer networking environment had several problem resolving the IP of the Azure SQL Server primary.
