SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2012 Cluster Multiple Instances Procedure !


SQL 2012 Cluster Multiple Instances Procedure !

Author
Message
Asim 6451
Asim 6451
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 4
Hello,

Kindly help me if I need different sources for each instance or can I use the same for all the instances I want to install like, SAN Driver, IP Address, Service Account?

Kindly give me the detailed procedure to follow as in Best Practise.

Regards !
Kumari Punam
Kumari Punam
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 94
As per my understanding of your question, you need information on building and configuring a Multiple Instance cluster.
The cluster can have multiple instances installed and for good performance, it is important to run instances on different physical nodes. So if you have Instance A and B then run instance A on node1 and InstanceB on node2. So that they can use each node resources.

Also, every instance on cluster will have their own IP address and dedicated SAN drives.
The SQL services can run with the common account, that is not a problem.
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20899 Visits: 17246
Asim 6451 (3/26/2013)
Hello,

Kindly help me if I need different sources for each instance or can I use the same for all the instances I want to install like, SAN Driver, IP Address, Service Account?

Kindly give me the detailed procedure to follow as in Best Practise.

Regards !

Each instance you install will have its own resources such as storage, IP and virtual networkname. I would also use dedicated service accounts for each service too. A SQL Server 2012 cluster deployment is not a great deal different to 2008 R2 so this guide should be helpful

Part1
Part2
Part3

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search