Post reply

AlwaysOn Clusterless

  • March 13, 2020 at 1:02 pm

    #3734029

    Hi All

    I'm hoping I can get something cleared up regarding AlwaysOn without an underlying Windows Cluster.

    So my understanding is:

    • Supports sync and async commit modes
    • If the primary is available, you can failover without data loss by setting to synchronous if it wasn't set already.
    • Cannot failover automatically
    • No listeners

    So my thought is, why is this not considered as a viable HA solution?

     

    Thanks

  • March 13, 2020 at 1:26 pm

    #3734031

    SQLSACT wrote:

    Cannot failover automatically

    Sums it up pretty much.

  • March 13, 2020 at 1:40 pm

    #3734061

    Thanks

    I hope I'm not missing something here because I really want to pursue this in our organization.

    Are you aware of any edition limitations?

  • March 16, 2020 at 11:37 am

    #3734661

    I'm trialling a synchronous pair with a 3rd node that is async… i'm asking similar questions. I'm hitting so many issues with HA groups that I just want to go back to mirroring with snapshots on a windows 2008 server cluster

     

    MVDBA

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

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