SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Clustering SQL Standard edition with 4 Nodes
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

imughal
Posting Yak Master

192 Posts

Posted - 08/22/2013 :  05:36:00  Show Profile  Reply with Quote
Hi,

I need help on following scenario.

I have Windows Server 2012 Standard edition and SQL Server 2012 Standard edition. I want to implement following scenario.

2 Node as cluster Active/Passive
3rd Node as Mirror
4th Node as Mirror / Replication

I know it will work on 3rd node but i am not clear about 4th node, Is this solution workable if so how pls guide.

What could be other solution to achieve this.

Pls also tell what are cluster node limitation in windows and sql standard edition.

thx

yelouati
Starting Member

10 Posts

Posted - 08/23/2013 :  23:44:16  Show Profile  Reply with Quote
Please consider always on with availability group. This will provide for all your mirrors. Although I am not sure about the Standard Edition.

Otherwise, 1 Cluster + 1 Mirror + 1 Replica is totally feasible. I have done it.
Go to Top of Page

imughal
Posting Yak Master

192 Posts

Posted - 08/24/2013 :  05:49:19  Show Profile  Reply with Quote
hi,

can u pls share step by step to do it.
thx
Go to Top of Page

sql-lover
Yak Posting Veteran

84 Posts

Posted - 09/17/2013 :  11:47:38  Show Profile  Reply with Quote
quote:
Originally posted by imughal

hi,

can u pls share step by step to do it.
thx



Building a Cluster has a lot of steps. Not only during the creation phase, but before that. Just to mention a few: picking the right SAN, disk or LUN layout, IP and hostname implementation, etc.

Google it and you will find lot of links that will explain.

However, I think what is really important on your question is knowing what you are trying to achieve. For instance: do you want HA? How many 9s are you willing to accept? What's your budget? What type of SAN do you have, how much RAM on every node and what's the SQL workload for your instances? How many databases and what type of workload do you have? Are you trying to use Mirroring as an offsite DR strategy?

You need to think carefully about all those and asses your current hardware.

Also, I do not know of any colleague that it is actually using AlwaysOn on a production at this moment. I would hesitate, at least at this moment, in using AlwaysOn on any live environment. I think that Mirroring finally got decent latency values on SQL2012, assuming that a correct network implementation is also made, of course.

Edited by - sql-lover on 09/17/2013 11:52:02
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000