locked
Active/active cluster RRS feed

  • Question

  • Dear All,

    I have a doubt about active/active clustering.

    Well active/active clustering is recomeded for single database for high availablity and for performance or not ??????

    We are having one database connected to many branches more than 500 users connected 24/7.

    I am looking for a solution for high availablity and load blancing and better performance.

    Please suggest me a perfect solution for this scneriao.

    Earlier response will be appreciated.

    Thanks.....

     

    Sunday, December 18, 2011 10:12 AM

Answers

  • No for a single database that is (potentially) overkill although depending upon your budget is viable. Clustering does not give you a performance gain.

     

    For HA, as long as you have Enterprise edition then database mirroring is an option to you. Based upon the limited information provided, from a scalability perspective (performance and HA) you could look at peer-peer replication although using that technique would still ideally require each branch to update its own logical dataset (to try to avoid update conflicts).

     


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    • Proposed as answer by Janos BerkeMVP Sunday, December 18, 2011 12:49 PM
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 12:08 PM
  • You do not need ACTIVE/ACTIVE or (two nodes) clustering for one database, have Active/Passive config.

    Moreover SQL Server clustering is not about load balancing, for better performance you need properly defined indexes and powerful hardware. 

    Read this article

    http://msdn.microsoft.com/en-us/library/ms190202.aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 1:16 PM
  • I am looking for a solution for high availablity and load blancing and better performance.


    As already mentioned, clustering is for HA rather than performance.  The SQL Server solution for scale-out performance with load-balancing of a read-only workloads (i.e. reporting) is Scalable Shared Databases (http://technet.microsoft.com/en-us/library/ms345392.aspx).  But that is not an option if more than one node must be read/write.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 2:10 PM

All replies

  • No for a single database that is (potentially) overkill although depending upon your budget is viable. Clustering does not give you a performance gain.

     

    For HA, as long as you have Enterprise edition then database mirroring is an option to you. Based upon the limited information provided, from a scalability perspective (performance and HA) you could look at peer-peer replication although using that technique would still ideally require each branch to update its own logical dataset (to try to avoid update conflicts).

     


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    • Proposed as answer by Janos BerkeMVP Sunday, December 18, 2011 12:49 PM
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 12:08 PM
  • You do not need ACTIVE/ACTIVE or (two nodes) clustering for one database, have Active/Passive config.

    Moreover SQL Server clustering is not about load balancing, for better performance you need properly defined indexes and powerful hardware. 

    Read this article

    http://msdn.microsoft.com/en-us/library/ms190202.aspx


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 1:16 PM
  • I am looking for a solution for high availablity and load blancing and better performance.


    As already mentioned, clustering is for HA rather than performance.  The SQL Server solution for scale-out performance with load-balancing of a read-only workloads (i.e. reporting) is Scalable Shared Databases (http://technet.microsoft.com/en-us/library/ms345392.aspx).  But that is not an option if more than one node must be read/write.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Stephanie Lv Sunday, December 25, 2011 6:40 AM
    Sunday, December 18, 2011 2:10 PM
  • Thanks for the  providing with the proper information.I really appreciate it.

    And I want to ask you that Our branches are only connecting to the application they and HQ is having centralized database branches are only having application Access.

    Please can you give me any tips for performance.

    I can provide you with complete information.

    Tuesday, February 21, 2012 6:13 AM
  •  

    Thanks for the  providing with the proper information.I really appreciate it.

    Can you give me any tech for load balancing.

     

     

     

    Tuesday, February 21, 2012 6:14 AM