Post reply

Always on

  • September 7, 2018 at 4:33 am

    #372351

    Can any one explain when  we recomend asynchronous and synchronous mode to be configured in always on with example

  • September 7, 2018 at 5:42 am

    #2004828

    ramyours2003 - Friday, September 7, 2018 4:33 AM

    Can any one explain when  we recomend asynchronous and synchronous mode to be configured in always on with example

    Sync mode for HA and async mode for DR

  • September 7, 2018 at 9:37 am

    #2004908

    Please explain elaborately

  • September 7, 2018 at 3:27 pm

    #2004953

    It depends on your recovery requirements. Synchronous commits to the secondary before committing on the primary so depending on network speed between the primary and secondary that can add an unacceptable latency. If so in your case you may loose some data in a disaster. If you can't live with that pay for more bandwidth. Asynchronous doesn't wait on the primary for commit on the secondary so no more latency but a possibility of some data loss in a disaster. If you have a RO replica for reporting also, if it's asynchronous, for most it's "real enough time".

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

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