AlwaysOn Setup

Question

Experts ,

If I create a Always On Instance with read only replica , will it be using a common listener. How will the requests be routed based on the fact if it is an update or a read only request. Any changes required at the application end or will all applications support by default , this setup

Answer 1

Hi @Vishal Garg ,

Welcome to Microsoft Q&A!

Please refer to Offload read-only workload to secondary replica of an Always On availability group:

To support read-only routing, an availability group must possess an availability group listener. The read-only client must direct its connection requests to this listener, and the client's connection string must specify the application intent as "read-only." That is, they must be read-intent connection requests.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Intent is to offload reads.

connection needs to include the ApplicationIntent setting -> does it need to be marked in the application connection string or somewhere in the AlwaysOn Setup

Answer 3

Is that secondary set to read-only or read-intent? What is the purpose of the secondary - is it for reporting only or is their an intent to offload reads? If the intent is to offload your reads - is that something you have researched and verified is actually needed for the application?

In order for reads to be offloaded - the connection needs to include the ApplicationIntent setting. If the connection hasn't been updated then the secondary will not be utilized to redirect reads to the secondary.