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


SQL 2008 x64 clustering active / active


SQL 2008 x64 clustering active / active

Author
Message
richard-730095
richard-730095
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 6
Hello all,
I've been trying for days now to get my new SQL Server x64 Enterprise cluster online in an active / active configuration.
In the end, this is going to an a 5 node cluster with one acting as passive.

My question / issue stems from not being able to install a new instance of SQL without it being a named instance. I get the first node online then the second will only install as a named instance..

Help?
Eddie Wuerch
Eddie Wuerch
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1185 Visits: 2228
You may only install one default instance of SQL Server on a server.

For clustering to work, you must install an instance on every node (server) in the cluster (the installer will do that for you).

The base idea behind clustering is that an instance of SQL Server may run on any of the nodes. Even though your intention is to run the cluster in active/active config - two instances of SQL Server, each running on a different server - if one server fails, the active instance on the failed server will move to the other server. That leaves both instances running on a single server. Both of those instances cannot be the default instance. Otherwise, how would you identify to which instance you wish to connect?

When you performed the first clustered install of the default instance, you claimed the server's default instance for that instance across every server in the cluster to which you enabled that instance to run.

All subsequently-installed instances must be named instances as a result. Quite often, when folks install instances on clusters, they only use named instances.

-Eddie

Eddie Wuerch
MCM: SQL
Victor Shahar
Victor Shahar
SSC Journeyman
SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)SSC Journeyman (99 reputation)

Group: General Forum Members
Points: 99 Visits: 248
Hi all,

I found a great product that is running as a GRIDSCALE and it's activating like a active/active cluster, take a look:

http://www.xkoto.com/

P.B.
If you will buy it, just send me an botle of wine :-)

Best regards,
Victor S.
DBA
EdVassie
EdVassie
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7355 Visits: 3875
SQL Server clustering is designed to solve the problem of high availability, not the problem of load balancing.

You can install SQL Server on a multi-node cluster, but only one node of the SQL Server instance name can be active at one time. If you have a multi-node cluster this has the effect of increasing the number of locations where SQL Server can be started if a given server fails, but it does not allow you to run multiple active nodes at one time.

Gridscale adds a little bit extra. This gives you a single logical name your applications can use to connect to SQL Server, and routes the connection request to the appropriate SQL Server instance. Each SQL Server instance in Gridscale has exclusive use of the databases attached to it. This means that if you have a given database that is used very heavily it MUST be located on a server that has enough power to run all your queries. Gridscale does not give you a shared data cluster where multiple nodes can both update the same database.

There is a way to get a shared data cluster with SQL Server, where multiple nodes are able to update the same database, but I have no idea what performance this would have. If you have what Microsoft call a geographically dispersed cluster you use SAN replication to keep the various LUNs synchronised. SQL Server uses the VSS writer component to let all active nodes know what pages have been changed, so that the other nodes can refresh their copy of these pages from disk. It is marketed as a way to distribute a cluster across multiple data centres, but there is no reason why everything could not be located in a single SAN. My main reservation with this setup is lack of community knowledge on the performance of the VSS writer component, because if this cannot keep up with the rate of change everything would comer to a halt or get corrupted.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
GTR
GTR
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1007 Visits: 368
richard-730095 (10/12/2009)
Hello all,
I've been trying for days now to get my new SQL Server x64 Enterprise cluster online in an active / active configuration.
In the end, this is going to an a 5 node cluster with one acting as passive.

My question / issue stems from not being able to install a new instance of SQL without it being a named instance. I get the first node online then the second will only install as a named instance..

Help?



Eddie explained very well how active\active clustering works. If that is the case why don't you go for Active\Passive clustering?

EnjoY!

EnjoY!
SQLDBA-536161
SQLDBA-536161
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 73
Hi Gurus,
I'm having trouble understanding SQL Server active/active cluster model. I was asked by our management about the difference between active/passive active/active to run SharePoint 2010.
I know what is active/passive means. I’m trying to make sense out of active/active. So in active/active, you have 2 instances running on each node. Say

In a two node Windows 2008 cluster server,
Instance share2010 running on node1 as active and share2010 running on node2 as passive
Instance share2010_2 running on node2 as active and share2010_2 running on node1 as passive

Can someone please explain how application(SharePoint 2010) failover would work ?
And how data between 2 instances are sync ?
anthony.green
anthony.green
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12686 Visits: 6519
SQLDBA-536161 (10/17/2011)
Hi Gurus,
I'm having trouble understanding SQL Server active/active cluster model. I was asked by our management about the difference between active/passive active/active to run SharePoint 2010.
I know what is active/passive means. I’m trying to make sense out of active/active. So in active/active, you have 2 instances running on each node. Say

In a two node Windows 2008 cluster server,
Instance share2010 running on node1 as active and share2010 running on node2 as passive
Instance share2010_2 running on node2 as active and share2010_2 running on node1 as passive

Can someone please explain how application(SharePoint 2010) failover would work ?
And how data between 2 instances are sync ?


What is your goal here? Two different sharepoint sites, eg. sharepoint1.domain.com and sharepoint2.domain.com or are you just having sharepoint.domain.com?

If you are having just sharepoint.domain.com then you want active passive. If you are having sharepoint1.domain.com and sharepoint2.domain.com then you can either have active passive and have the databases on the same instance aslong as they names are different, e.g WSS_Content_SP1, WSS_Content_SP2, or you could go active active with two SQL instances, and the db's could be called the same, e.g WSS_Content.

The data would not sync between the two instances and the failover would be just like a normal fail over, where the resource group moves over to the second node and starts up, and its the same instance, same databases, then Sharepoint will continue to work, no change nessesary.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Server_Programmer
Server_Programmer
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 44
You are right Eddie and I agree with you

But let's all think about the following scenario (Note: I didn't test yet)

There is another solution called "Network Load Balancing" that comes with Windows servers 2000 Advanced server and next later versions of windows so I believe that the way we can make Active - Active solutions is to merge both techniques together.

what I want to say is in case we have enough resources and servers we can do the following:

Windows Clusters Configuration:

Cluster A (SQL Node 1, SQL Node 2) ----> Shared disk Drives (ABCD) , Cluster A IP Address: 192.168.0.110
Cluster B (SQL Node 3, SQL Node 4) ----> Shared disk Drives (ABCD) , Cluster B IP Address: 192.168.0.120
Cluster C (SQL Node 5, SQL Node 6) ----> Shared disk Drives (ABCD) , Cluster C IP Address: 192.168.0.130

Network Balancing must be configured for the following clusters:

Cluster A , Cluster B, Cluster C

The Public IP Address of Network Load Balance Service is: 192.168.0.140

Now,

1- The Users will connect to the servers using NBL of IP: 192.168.0.140
2- The load on each server could be balanced because of NBL Balance.
3- NBL will handle redirecting user's requests to the Clusters.
4- All Clusters are using same Shared Disks that means all are using same databases location.
5- We'll have only one problem or doubt which is does SQL Server installer overwrite the configuration of other clusters?

This is a question.

Does anyone has faced same scenario? or has any correction ?

I am just thinking and would like to share my thoughts
EdVassie
EdVassie
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7355 Visits: 3875
Your Active/Active scenario will not work. There is an inherent restriction with SQL Server that means a given SQL service must have exclusive access to the database file.

If somehow you get past this and get multiple SQL instances to share the same disk in read/write mode you will corrupt the databases. When SQL instance A reads a page from disk to its buffer, it assumes it has 100% control over the page. If SQL instance B replaces the page on disk this is not known to SQL instance A. When SQL instance A writes the page to disk you will destroy the updates made by SQL instance B.

If you really need multiple database instances able to update the same database file, then you need to look at DB2. In DB2 there is instance to instance communication to let all instances know which instance is updating a given database page, so that updates from multiple instances do not get lost.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Server_Programmer
Server_Programmer
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 44
Hi and thanks for your quick response,

So, is there anyway to implement Active / Active scenario to ensure the load on each server is as low as possible?

what does microsoft say regarding this?
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