SQL 2008 x64 clustering active / active

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » SQL 2008 x64 clustering active / active

13 posts, Page 2 of 2

««1 2

SQL 2008 x64 clustering active / active

Rate Topic

Display Mode

Topic Options

Author

Message

EdVassie

Posted Tuesday, October 02, 2012 2:32 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,621, Visits: 2,756

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

vijay.ahire8

Posted Thursday, October 18, 2012 10:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 8:08 AM
Points: 2, Visits: 41

What is the difference between Active/Active and Acitve/Passive clustring in SQL 2008??

Post #1374492

EdVassie

Posted Friday, October 19, 2012 3:44 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,621, Visits: 2,756

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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 »

13 posts, Page 2 of 2

««1 2

Permissions