How to deploy Microsoft AlwaysOn Availability Group without an AG Listener
The purpose of this article is to provide instruction on the installation of Microsoft SQL Server AlwaysOn Availability Groups without the use of the Availability Group Listener.
Using ScaleArc in place of the AlwaysOn AG listener provides a more robust implementation. During the failure of the primary replica within an Availability Group incoming client connections will be queued within ScaleArc. Once the newly promoted primary replica becomes available, ScaleArc will process the queued connections in a first come first service basis. The only impact to the client application servers is a delay in response during the database server failover operation.
NOTE: In order to maximize this functionality, it is crucial that the client application server connection timeout values are set appropriately for your envrionment.
Follow the normal procedure for configuration of a Microsoft SQL Server AlwaysOn Availability Group as suggested by Microsoft here.
NOTE: Skip the creation of the Availability Group Listener
ScaleArc can perform the function of the AG Listener. The application servers will communicate to the database(s) via the ScaleArc cluster address. ScaleArc will routinely probe the servers within the Availability Group to determine status and availability.
Complete the ScaleArc cluster configuration (as described in the ScaleArc MS SQL Admin Guide) using the IP address/DNS name of the AlwaysOn Availability Group primary replica in the Servers section.
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315. For general support inquiries, you can also e-mail us at firstname.lastname@example.org.
2901 Tasman Drive Santa Clara, CA 95054 | Email: email@example.com