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

SQL 2008 x64 clustering active / active Expand / Collapse
Author
Message
Posted Tuesday, October 2, 2012 2:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:18 AM
Points: 2,886, Visits: 3,256
As far as a cluster is concerned, you are limited to Active/Passive for a given database.

If you want to have multiple instances accessing the same database, then the two simplest things are:

a) Mirroring. This works OK in SQL 2005 and above, but is greatly improved in SQL 2012. Mirroring will allow you to have one instance doing all the updates while the other instances read committed data.

b) Peer to Peer replication. This is what we use. It does support multiple instances updating the same set of data and sharing the updates, but you need your application to be designed to support this. We need P2P as we populate scale-out servers at multiple sites, which cannot be done with mirroring, but direct all our updates to a single instance because our applications cannot cope with multi-site update.

c) Merge replication. The typical use case for this is where you have subscriber databases that may not be connected to your network full time. It allows more flexibility than P2P, but is more complex to maintain.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1366899
Posted Thursday, October 18, 2012 10:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 10, 2014 2:14 AM
Points: 2, Visits: 57
What is the difference between Active/Active and Acitve/Passive clustring in SQL 2008??
Post #1374492
Posted Friday, October 19, 2012 3:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:18 AM
Points: 2,886, Visits: 3,256
All clustering in SQL Server is inherently Active/Passive. A given database can only be online to a single node at any one time.

People use the term Active/Active to indicate they have installed multiple SQL Server clusters, each one with its own set of databases. In this scenario, SQL Cluster 1 can have its active databases on windows cluster node A, and SQL Cluster 2 can have its active databases on windows cluster node B. This means both windows cluster nodes are active, but they are active with completely separate databases.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1374709
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse