SQL Server 2008 R2 SP1 64x cluster active/active

  • Ive read several posts on this here, and am wondering how you can use sql server cluster as active/active to achieve load balancing. Is this possible? Most posts I'm seeing indicate cluster is only used for Hi-Av.

    My company's goal is to have 2 database servers (vm nodes) that can feed into one database to manage the large number of front end instances, volume of processes and transactions, etc. Is this possible with SQL Server (cluster)? How would you configure it if this is possible? If not, what would you suggest for architecture? They prefer to use SQL Server (as opposed to ORacle Rac) due to it's better integration with security and lower cost.

    Jamie

  • No, clustering for SQL is high availability only. What people mean when they say active-active is two different instances with two different sets of database one running on each cluster node.

    It's possible to 'scale-out' with peer-to-peer replication, but that's mostly for read-heavy systems or the cost of the replication overwhelms the system.

    What kind of volume of transactions are you talking about anyway?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 20+ front ends, 25+ million users

  • Running facebook or something?

    Something at that scale is going to take some really good architectural design (not just database design) for not only the scalability but also maintenance, recoverability and all that king of thing. Not going to be easy to do, regardless of database system used.

    Do you have someone there with experience of running systems (database and app) at that scale?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Jamie,

    as Gail mentioned clustering for HA only....pear 2 pear has its own complexity and for such a volume might not be the best bet...

    Your best bet would to wait for sql 2012 as it comes with read only mirrors which can help do good amount of load balancing, explore that area if it meets ur req...

    Prakash

    http://www.sqlfeatures.com

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply