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

Creating an Active/Passive cluster Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 12:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:49 AM
Points: 32, Visits: 135
Friends,

I am exploring an option to create SQL cluster with active/passive node on an already existing cluster.
Here is the scenario:
Existing: Server 1 is Active and server 2 is passive
Required: I need to add discs and on separate resource group I want to create Server 2 as active with different SQL server instance, of course, and Server 1 will be passive node for this cluster.

I have done a lot of research on this and I think is it possible.

Please provide some points to consider before going ahead with this plan, I cant afford to mess up on this one.

Response is much appreciated.
Post #1410376
Posted Wednesday, January 23, 2013 1:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:13 AM
Points: 1,190, Visits: 1,664
Isn't the definition of an active/active cluster one that runs a separate instance on each node, each with their own resource groups?

So you are wanting to go from active/passive to active/active.
Post #1410389
Posted Wednesday, January 23, 2013 1:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:49 AM
Points: 32, Visits: 135
Yes correct. Existing cluster needs to remain untouched and cluster should become active-active.
Post #1410390
Posted Wednesday, January 23, 2013 1:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:13 AM
Points: 1,190, Visits: 1,664
It should be fairly straightforward. Make sure you're licenced for the extra running hardware.

Brent Ozar has a screenshotted install
http://www.sysads.co.uk/2012/02/add-additonal-sql-instance-to-existing-sql-server-2008-r2-cluster/

Also, you need to install the 2nd instance from the 1st node, then fail it over. Make sure your SQL max memory settings are suitable (either change them through a SQL agent job on SQL startup or ensure both instance will fit in RAM on the same node)
Post #1410399
Posted Wednesday, January 23, 2013 5:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
foxxo (1/23/2013)
Also, you need to install the 2nd instance from the 1st node, then fail it over.

Actually, no you don't!


chandrakant_gaurav (1/23/2013)
Yes correct. Existing cluster needs to remain untouched and cluster should become active-active.

Ensure you present any storage for the new instance to both nodes, it's probably easier (and I prefer too) install the new instance on the currently passive node which will then make it active. You may then simply run the add node wizard on the partner node that has the original instance running.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1410505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse