PAAS Failover Groups - Secondary connection string

• Vets5

  SSC Eights!

  Points: 982

  More actions

  July 25, 2022 at 9:33 am

  #4067776

  Hi all,

  We are using some PAAS Geo-replicaed Fail Over groups and I have a question about using the Readonly replica connection string <fog>.secondary.database.windows.net. My question is in the event of an issue connecting to the secondary replica does Azure reroute the connections to the primary?

  We would like to implement read intent style connection string but unfortunately we would have a hard dependency on the read results.

  Looking online I can see the AllowReadOnlyFailoverToPrimary which seems to be what I want but only in the event of failover being triggered? I would like to be resilient against network, DNS issues, secondary going offline etc.

  Thanks,

  V

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 26, 2022 at 10:10 am

  #4068300

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.