Finding the Primary Replica of an Availability Group
Hi All, I've configured VIPs and a WIP for a SQL Always On service and would like to ensure traffic is directed to the current Primary Replica wherever possible. The configuration is as follows: DC1 hosts a SQL server and a corresponding VIP. DC2 hosts a SQL server and a corresponding VIP. The WIP currently directs traffic to the DC1 VIP using Global Availability, with a fallback to Round Robin if required. Does anyone know of a way for the F5 infrastructure to identify which SQL Always On replica is currently the Primary Replica and automatically direct clients to the associated VIP across the two data centres? Any advice or experience with this would be greatly appreciated. Thanks in advance.
Load balancing read only SQL 2008R2 servers
We have everything setup in the LTM and everything is working right. Traffic is getting balanced equally between our MS SQL server (read only). But the issue we are seeing happens when a server goes out for maintenance. We have a health monitor setup to query a DB and the LTM knows when the SQl server it down. But it seems the web servers connections to the SQL servers are keeping the connection alive. Here is a copy of the error that is recieved: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider,error: 0 - An existing connection was forcibly closed by the remote host.) After this happens, the web servers then move over to the next available node. the VIP is setup for performance layer 4, web servers are server 2003, and our SQL servers are server 2008R2 setup with n-path.
