locked
Active active cluster RRS feed

  • Question

  • Dear all,

    I'm trying to figure out without any success in the official documentation wether SQL Server 2012/2014 supports active-active clustering or not.

    I mean by active-active clustering having two RDBMS accessing the same database in a read-write fashion at the same time (like an Oracle RAC).

    Do you have any clues concerning this question ? Any pointer to an official documentation saying something like: "yes, you can make load balancing in front of an SQL server cluster" (or the negation ;) )

    Thank you,

    Laurent

    Thursday, October 2, 2014 3:02 PM

Answers

  • I'm trying to figure out without any success in the official documentation wether SQL Server 2012/2014 supports active-active clustering or not.

    Hi,

    Let me first tell you there is nothing like Active active cluster correct word is Multi instance cluster. Multi instance cluster is fully supported in SQL Server.


    I mean by active-active clustering having two RDBMS accessing the same database in a read-write fashion at the same time (like an Oracle RAC).

    No multi instance cluster would be two or more applications accessing different instances of SQL server whih are residing on different or same nodes. Generally its different nodes. Oracle RAC is different from SQL Server clustering please dont mix both

    to an official documentation saying something like: "yes, you can make load balancing in front of an SQL server cluster" (or the negation ;) )

    Load balancing is Application concept and SQL Server Clustering is totally different from it. As a fact SQL Server clustering does not provides load balancing it provides redundancy. Installing multi instance cluster is same as Active passive cluster you just need to install two instances with both instances on different node.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Articles

    Thursday, October 2, 2014 3:12 PM
  • As others have said, there is no built in way to support the SAME database in a read/write mode on 2 instances with load balancing.

    If you feel you really need this, the best you can do is use MERGE replication between 2 instances and somehow load balance the users between the 2 instances using some external method.


    Please see:

    http://www.brentozar.com/archive/2011/03/scaling-up-or-scaling-out-part-two/

    Thursday, October 2, 2014 3:24 PM

All replies

  • The reason you are not able to find any official documentation is because there is no such feature.

    The closest feature is Always -ON availability groups in SQL 2012/2014. But there also it only permits Active (read/write)- SemiActive(read) in your words.

    Read more about availability groups here - http://msdn.microsoft.com/en-GB/library/ff877884.aspx


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Thursday, October 2, 2014 3:07 PM
  • I'm trying to figure out without any success in the official documentation wether SQL Server 2012/2014 supports active-active clustering or not.

    Hi,

    Let me first tell you there is nothing like Active active cluster correct word is Multi instance cluster. Multi instance cluster is fully supported in SQL Server.


    I mean by active-active clustering having two RDBMS accessing the same database in a read-write fashion at the same time (like an Oracle RAC).

    No multi instance cluster would be two or more applications accessing different instances of SQL server whih are residing on different or same nodes. Generally its different nodes. Oracle RAC is different from SQL Server clustering please dont mix both

    to an official documentation saying something like: "yes, you can make load balancing in front of an SQL server cluster" (or the negation ;) )

    Load balancing is Application concept and SQL Server Clustering is totally different from it. As a fact SQL Server clustering does not provides load balancing it provides redundancy. Installing multi instance cluster is same as Active passive cluster you just need to install two instances with both instances on different node.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Articles

    Thursday, October 2, 2014 3:12 PM
  • As others have said, there is no built in way to support the SAME database in a read/write mode on 2 instances with load balancing.

    If you feel you really need this, the best you can do is use MERGE replication between 2 instances and somehow load balance the users between the 2 instances using some external method.


    Please see:

    http://www.brentozar.com/archive/2011/03/scaling-up-or-scaling-out-part-two/

    Thursday, October 2, 2014 3:24 PM
  • Can you look into MERGE Replication feature?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Friday, October 3, 2014 8:04 AM
  • Actually SQL Server *does* have something slightly similar to Oracle (contrary to what others have told you), and it is called Scalable Shared Server. Unfortunately it only works for read-only databases and Microsoft have absolutely no plans to develop this technology to incorporate writes. I have made many requests directly to MS for a SQL RAC style implementation, but this is sadly not on the Roadmap, so is unlikely to ever happen.

    Regards,<br/> Mark Broadbent.<br/> Microsoft Certified Master<br/> Contact me through <a href="http://bit.ly/1fGF0nv" target="_blank">twitter</a> | <a href="http://bit.ly/1lWxFEj" target="_blank"> blog</a> | <a href="http://bit.ly/1k8Joyf" target="_blank">sqlcloud</a><br/> <hr> Please click &quot;<b>Propose as answer</b>&quot; if a post solves your problem<br/> or/and <b>vote the post up</b> if it's been helpful.<br/> <br/> <a href="http://bit.ly/1i5ZVBS" target="_blank">Want professional SQL Server High Availability Training? Click here</a>

    Wednesday, October 8, 2014 3:06 PM