In part1, I’ve shown how to create a windows cluster in a multi subnet setup. In this post let’s see how to create a AG and corresponding listener.
In my lab, I will be creating two AGs and two corresponding listeners.
Details:
I’ve two databases – > sales and customers.
Two AGs – > Sales_AG and Customers_AG.Two Listners – > sqllst_Sales and sqllst_Cust.
For sales AG, I’ve disabled “Database level health detection”, a new feature introduced in SQL 2016.
Now, for Listener two IPs from both subnets have been provided.
Same process has been followed for creating customers AG and listener as well(But this time I’ve enabled Database level health detection).
Since this is a multi-subnet setup two entries(one from each subnet) will be created in DNS for each listener name as shown below.
That’s about it folks.
Srikanth,
Can you please point me to a a place where I can learn how to do a failover between he primary and the dr site? We are planning for a 3 node setup like the one you mentioned . 2 in DC and one in Sanjose
The witness will be in DC . Planning to use sql server 2016 with windows server 2012R2. Do I have to disable the node weight of the 3rd node? Please let me know
Thanks!
Vijay
see this fantastic doc from Microsoft.
https://msdn.microsoft.com/library/hh781257.aspx