Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Adding a new instance on a existing cluster Expand / Collapse
Author
Message
Posted Thursday, December 29, 2011 12:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 3, 2016 10:52 PM
Points: 1,004, Visits: 992
Hi All

I need to add a new sql instance on the existing cluster, how do i go about?

The current setup of the cluster is Active\Active

2K8 OS Enterprise and 2K8 Enterprise SQL
256GB ram and disk allocation we using mount points





It's better to fail while trying, rather than fail without trying!!!
Post #1227662
Posted Thursday, December 29, 2011 1:44 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, January 27, 2016 5:54 AM
Points: 4,429, Visits: 4,204
Just run the setup and install a new clustered instance.
It's not really different from installing the first instance.


Markus Bohse
Post #1227675
Posted Thursday, December 29, 2011 2:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 3, 2016 10:52 PM
Points: 1,004, Visits: 992
What about a new ip address and service accounts, as currently running two nodes that are active

Thx





It's better to fail while trying, rather than fail without trying!!!
Post #1227681
Posted Thursday, December 29, 2011 2:10 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, January 27, 2016 5:54 AM
Points: 4,429, Visits: 4,204
smthembu (12/29/2011)
What about a new ip address and service accounts, as currently running two nodes that are active

Thx

Of course each new instance needs to have it's own cluster resource group, including IP-adress and shared disk. If you want to use another service account or the same as for the existing instance depends on your internal policy. I've seen companies there they use one account for all instances andothers have a different account for each instance.

What I meant to say in my first post is basically you have to follow the same steps as when you installed the first instance except for the fact that you have a diferent name and cluster group.


Markus Bohse
Post #1227682
Posted Thursday, December 29, 2011 2:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 3, 2016 10:52 PM
Points: 1,004, Visits: 992
Thanks




It's better to fail while trying, rather than fail without trying!!!
Post #1227683
Posted Friday, December 30, 2011 1:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 192, Visits: 292
Complete the requirements for clustered instance and install it as you installed the first instance
Post #1228539
Posted Monday, January 2, 2012 1:46 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 27, 2016 3:54 AM
Points: 540, Visits: 1,558
New instance needs
* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared disk for msdtc


Regards,
Raj

http://Strictlysql.blogspot.com
Post #1228803
Posted Tuesday, January 3, 2012 2:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 14, 2015 2:42 AM
Points: 1,332, Visits: 15,308
arr.nagaraj (1/2/2012)
New instance needs
* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared disk for msdtc


and preferable a new cluster group for controlled failover. This can be done in the installation wizard but I prefer to prepare in advance.

As far as I'm aware, you dont "need" another msdtc for the instance either but you can add one.
Post #1229101
Posted Tuesday, January 3, 2012 2:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 27, 2016 3:54 AM
Points: 540, Visits: 1,558
Yes. 'Preferably' additional msdtc and cluster group.

Regards,
Raj

http://Strictlysql.blogspot.com
Post #1229104
Posted Thursday, January 5, 2012 6:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 3, 2016 10:52 PM
Points: 1,004, Visits: 992
Thanks All for assistance




It's better to fail while trying, rather than fail without trying!!!
Post #1230690
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse