Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:07 AM
Points: 964, Visits: 887
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: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:07 AM
Points: 964, Visits: 887
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: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:07 AM
Points: 964, Visits: 887
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: Tuesday, September 9, 2014 2:26 PM
Points: 192, Visits: 205
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 488, Visits: 1,340
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

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, August 18, 2014 3:04 AM
Points: 1,362, Visits: 15,269
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 488, Visits: 1,340
Yes. 'Preferably' additional msdtc and cluster group.

Regards,
Raj

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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:07 AM
Points: 964, Visits: 887
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