locked
Basic cluster question RRS feed

  • Question

  • HI there.

    I have some basic question regarding implementing cluster in SQL environment.

    Is it possible to achieve SQL cluster per database level or you can do that only on SQL instance level?

    The idea is to implement high availability of Database, but not all of them?

    Is that possible?


    bostjanc

    Wednesday, January 24, 2018 12:35 PM

Answers


  • Is it possible to achieve SQL cluster per database level or you can do that only on SQL instance level?

    The idea is to implement high availability of Database, but not all of them?


    You can do that not with SQL Server cluster but with simple availability groups residing on Windows Server failover cluster (WSFC). With AG a discreet set of databases failover to other nodes when disaster strikes


    Cheers,

    Shashank

    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 Wiki Articles

    MVP

    • Marked as answer by B_C_R Wednesday, January 24, 2018 1:31 PM
    Wednesday, January 24, 2018 1:05 PM
  • classic SQL cluster has shared disk space to hold DBs. In AAG every SQL server has its own disk space for DBs.

    So disk amount used for DBs in AAG is twice.

    You also need additional IPs for AAG listeners.  

    Another thing is that not every system can work correctly with AAG. 

    Full info here


    Best Regards,
    Łukasz Antoniak


    Please do take a moment to "Vote as Helpful" and/or "Mark as Answer", wherever applicable. Thanks!

    • Marked as answer by B_C_R Wednesday, January 24, 2018 1:31 PM
    Wednesday, January 24, 2018 1:22 PM

All replies

  • SQL cluster per database level is not possible and we can do that only on SQL instance level. if you have do that per database level, then you have to install separate cluster instance for each database .

    ____________________________________________

    Please Mark This As Answer if it solved your issue 
    Please Vote This As Helpful if it helps to solve your issue 

    _____________________________________________________________

    Wednesday, January 24, 2018 12:51 PM

  • Is it possible to achieve SQL cluster per database level or you can do that only on SQL instance level?

    The idea is to implement high availability of Database, but not all of them?


    You can do that not with SQL Server cluster but with simple availability groups residing on Windows Server failover cluster (WSFC). With AG a discreet set of databases failover to other nodes when disaster strikes


    Cheers,

    Shashank

    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 Wiki Articles

    MVP

    • Marked as answer by B_C_R Wednesday, January 24, 2018 1:31 PM
    Wednesday, January 24, 2018 1:05 PM
  • Thanks for the replies.

    What are pros and cons of either chosing SQL cluster level or WSFC?
    With best regards


    bostjanc

    Wednesday, January 24, 2018 1:09 PM
  • Thanks for the replies.

    What are pros and cons of either chosing SQL cluster level or WSFC?
    With best regards


    bostjanc

    A SQL Server cluster cannot exist without WSFC so there is no con as such. While AG may or may not use SQL FCI( this means SQL Server cluster). What I suggested is simple AG on WSFC without SQL FCI

    Cheers,

    Shashank

    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 Wiki Articles

    MVP

    Wednesday, January 24, 2018 1:20 PM
  • classic SQL cluster has shared disk space to hold DBs. In AAG every SQL server has its own disk space for DBs.

    So disk amount used for DBs in AAG is twice.

    You also need additional IPs for AAG listeners.  

    Another thing is that not every system can work correctly with AAG. 

    Full info here


    Best Regards,
    Łukasz Antoniak


    Please do take a moment to "Vote as Helpful" and/or "Mark as Answer", wherever applicable. Thanks!

    • Marked as answer by B_C_R Wednesday, January 24, 2018 1:31 PM
    Wednesday, January 24, 2018 1:22 PM
  • thank you all for the replies

    bostjanc

    Wednesday, January 24, 2018 1:31 PM