07-27-2015 10:51 AM
Hello
Currently , I have 2 node cluser for SQL database.
There are requirement to add new node to the existing cluster.
If I install windows , sql installation & configuration as same as the exsing nodes.
The finally step are just adding the node to cluster and re-run the SQL agent configuration wizard to reconfigure the SQL service group.
I am not sure about the additional step that must be concern.
Thank you.
Solved! Go to Solution.
07-27-2015 12:25 PM
Hi pgm10s,
It sounds like you have everything covered fairly well. The installation of SQL needs to have the same path to the binaries as the existing nodes. The path to the master database files can be different. But don't worry, the SQL service group configuration wizard will fix that difference. You just need to run the wizard from an existing node in the cluster where the share storage is already online and then add the new node via the wizard.
Be sure to install any SQL patches on the new node that may have been installed on the 2 existing SQL nodes.
Don't forget to test failover to ensure that SQL is working correctly on all nodes.
If you have configured SQL Network settings to use a different port then you might need to change that manually. But if that needs to be done, then it should come out in the testing phase..
Thank you,
Wally
07-27-2015 12:25 PM
Hi pgm10s,
It sounds like you have everything covered fairly well. The installation of SQL needs to have the same path to the binaries as the existing nodes. The path to the master database files can be different. But don't worry, the SQL service group configuration wizard will fix that difference. You just need to run the wizard from an existing node in the cluster where the share storage is already online and then add the new node via the wizard.
Be sure to install any SQL patches on the new node that may have been installed on the 2 existing SQL nodes.
Don't forget to test failover to ensure that SQL is working correctly on all nodes.
If you have configured SQL Network settings to use a different port then you might need to change that manually. But if that needs to be done, then it should come out in the testing phase..
Thank you,
Wally
07-27-2015 09:36 PM
Thank you for the advice.
There are more requirement about the downtime that must low as possible.
I have tested adding the sql node. I found that there is no downtime during the adding process.
There will be only 3-4 minutes downtime when I switch SQL SG to new node.
07-28-2015 05:42 AM
Hi pgm10s,
It sounds like you are on the right track and have a good hand on what you need to do. Remember that if you have any problems during the process you can always open a case with Symantec Techncial Support.
Thank you,
Wally Hem
08-05-2015 11:55 PM
Hello Wally_Heim
I have some question about manage SQL under VCS control.
After we finish configured the SQL service group without Detail Monitoring.
-If we add more SQL database in the same instance with same share drive/volume , what shoud we change or do anything at VCS.
-If we delete SQL database, what shoud we change or do anything at VCS.
Thank you.