January 17, 2018 at 2:22 pm
Hi All,
I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for two node replicas.
Can you please suggest me how many IP's require to configure the always AG between two nodes and it is in SQL 2012 on windows Server 2012.
As per my understanding,two IP's for windows cluster and two IP's for AG listener ? is it correct?
Please confirm.
Best & Regards,
DBA
SQL server DBA
January 17, 2018 at 3:08 pm
Hi,
The listener require one IP address. In case of two cluster nodes you may consider a file share witness as well. https://blogs.technet.microsoft.com/askpfeplat/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one/
January 17, 2018 at 4:50 pm
Database admin(DBA) - Wednesday, January 17, 2018 2:22 PMHi All,I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for two node replicas.
Can you please suggest me how many IP's require to configure the always AG between two nodes and it is in SQL 2012 on windows Server 2012.As per my understanding,two IP's for windows cluster and two IP's for AG listener ? is it correct?
Please confirm.
Best & Regards,
DBA
If you are asking that question I BEG you to not be going down this road unless it is just for learning purposes. There is a WORLD of possible PAIN awaiting you otherwise.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 18, 2018 at 9:02 am
Database admin(DBA) - Wednesday, January 17, 2018 2:22 PMHi All,I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for two node replicas.
Can you please suggest me how many IP's require to configure the always AG between two nodes and it is in SQL 2012 on windows Server 2012.As per my understanding,two IP's for windows cluster and two IP's for AG listener ? is it correct?
Please confirm.
Best & Regards,
DBA
If you plan to use an Availability Group in a Windows Server Failover Cluster you need 1 IP and name for the cluster Client Access Point.
You'll need 1 IP and name for each listener you employ.
I urge you to read my stairway to alwayson starting at this link
http://www.sqlservercentral.com/stairway/112556/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2018 at 2:08 am
Thank you all your prompt response.
If One primary and two secondary replica(one Sycn and another one is Async) which means we need a 3 IP's for cluster (CAP) and 3 IP's for AG listener ?
Please correct me If i'm wrong here...
Thanks in advance!!
Best Regards,
SQL server DBA
January 22, 2018 at 9:46 am
Database admin(DBA) - Sunday, January 21, 2018 2:08 AMThank you all your prompt response.If One primary and two secondary replica(one Sycn and another one is Async) which means we need a 3 IP's for cluster (CAP) and 3 IP's for AG listener ?
Please correct me If i'm wrong here...Thanks in advance!!
Best Regards,
Is this a multi subnet cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2018 at 5:58 am
Database admin(DBA) - Wednesday, January 17, 2018 2:22 PMHi All,I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for two node replicas.
Can you please suggest me how many IP's require to configure the always AG between two nodes and it is in SQL 2012 on windows Server 2012.As per my understanding,two IP's for windows cluster and two IP's for AG listener ? is it correct?
Please confirm.
Best & Regards,
DBA
Minimum 4, one for each node, one for the windows cluster and the other for the Listener
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply