Post reply

Question about clustering a shared storage for database file on SQL Server 2016

  • August 12, 2016 at 8:15 pm

    #316159

    Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:

    1. Create a shared storage on server 1

    2. Install SQL server on servers 2 and 3

    3. Create the failover cluster

    This scenario will work if either servers 2 or 3 fails, so the other server still running and there is no interruption, but what if the server 1 with the shared storage fails??? :O

    so hope someone can help me to answer this questions:

    1. Can I create a cluster on the server 1 with the shared storage?

    2. I wish to minimize the time for a recovery in the event of a server fail on 1, so what its the best configuration?

    Thanks alot.

  • August 13, 2016 at 3:08 am

    #1895320

    Failover clustering has a single point of failure - the storage. It's designed to protect against hardware failures of the machines (the shared storage is more commonly a SAN or NAS than another server)

    If that's no acceptable, have you considered Availability Groups?

    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

  • August 13, 2016 at 7:21 am

    #1895324

    Thanks x the reply. Do you please recommend me some tutorial or literature about that groups?

    Thanks

  • August 13, 2016 at 7:48 pm

    #1895341

    Sure. Start with google's first 10 results. Once you've got though that, post any questions you stuill have.

    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

  • August 17, 2016 at 10:06 am

    #1895952

    luisalfonso70 (8/12/2016)

    Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:

    1. Create a shared storage on server 1

    2. Install SQL server on servers 2 and 3

    3. Create the failover cluster

    This scenario will work if either servers 2 or 3 fails, so the other server still running and there is no interruption, but what if the server 1 with the shared storage fails??? :O

    Are you planning for a failover cluster instance or Availability groups?

    A failover cluster instance will require shared storage, the correct order for above will be

    1. Add shared storage on server 1, 2 and 3

    2. Create the failover cluster

    3. Install SQL server on servers 1, 2 and 3

    luisalfonso70 (8/12/2016)

    so hope someone can help me to answer this questions:

    1. Can I create a cluster on the server 1 with the shared storage?

    2. I wish to minimize the time for a recovery in the event of a server fail on 1, so what its the best configuration?

    Thanks alot.

    See my stairway to AlwaysOn starting at this link

    http://qa.sqlservercentral.com/stairway/112556/[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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