March 9, 2009 at 2:11 pm
We have an active/active cluster. The IP address, from the cluster admin, assigned to the SQL instance differs from that found in the SQL configuration manager.
Say, the IP address found in the cluster admin is xxx.xxx.xxx.1 but the IP address found from the SQL configuration manager is xxx.xxx.xxx.2, which is the same as the IP address used for the node the instance resides on. Apparently, we would like the instance reside on the IP xxx.xxx.xxx.1.
How to fix it?
Any input will be greatly appreciated.
March 9, 2009 at 3:32 pm
I don't think there is anything to be fixed. When SQL Server is running on node 1 - it uses the IP address for that node. Cluster Administrator exposes the virtual IP which is what you connect to instead of connecting directly to the node.
When the system fails over to the other node - SQL Server will be running on that node with that nodes IP adddress and the virtual IP will not have changed. Cluster Administrator will then direct connections to this node.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 10, 2009 at 10:16 am
Thank you so much for your input.
I cannot say I agree with you. If the cluster fails over, and its IP is changed, the IP used by the SQL instance will be changed. How will user connect it?
March 10, 2009 at 10:47 am
The virtual IP address will not change. The users connect to the virtual IP address and not the node specific address. Cluster administrator redirects the virtual IP address to the node running SQL Server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 10, 2009 at 11:26 am
If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as a manual reconnect to the other address would be required.
As Jeffrey mentioned, users need to connect to the SQL Virtual IP address
March 10, 2009 at 12:27 pm
Richard M (3/10/2009)
If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as a manual reconnect to the other address would be required.As Jeffrey mentioned, users need to connect to the SQL Virtual IP address
That is my point. The setup of the IP address is incorrect. My question is what we need to do in changing the IP to the virtual IP.
March 10, 2009 at 12:36 pm
SQL ORACLE (3/10/2009)
Richard M (3/10/2009)
If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as a manual reconnect to the other address would be required.As Jeffrey mentioned, users need to connect to the SQL Virtual IP address
That is my point. The setup of the IP address is incorrect. My question is what we need to do in changing the IP to the virtual IP.
There is nothing to change on the server or in cluster administrator. You need to change how the application connects to the clustered instance of SQL Server. The application should use the SQL Cluster name (or the SQL Cluster IP Address) to connect and not use the node specific IP addresses.
The cluster service will take care of redirecting to the appropriate node - based upon which node is currently running SQL Server.
If you really think there is a problem with the setup - can you post the definition of each cluster group and the resources in each group. You should have at least two groups:
Cluster Group
Cluster IP Address
Cluster Name
Quorom Disk
SQL Group
SQL Resources
You might also have (and probably should have) and MSDTC group.
Each cluster group will have it's own IP address and Name and various other resources.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 10, 2009 at 2:29 pm
Jeffrey:
I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact I may come across, and what detail procedures I should follow when I change the IP address to the virtual IP.
Many thanks for your input once again.
March 10, 2009 at 2:45 pm
SQL ORACLE (3/10/2009)
Jeffrey:I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact I may come across, and what detail procedures I should follow when I change the IP address to the virtual IP.
Many thanks for your input once again.
Change what? where?
Like I said before, the application needs to be changed to use the virtual IP name or address. I don't know what it would take to make that change in your application.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply