AlwaysOn Replication

Question

Experts , For a read-only / read intent database in secondary alwayson , can we have a sync replication and automatic failover between primary and secondary or will it be async only with a manual failover

Answer 1

Hi @Vishu ,

> but does it lead to a lot of locking due to sync replication for the read requests

No.

> Also with node1\sql2019 being primary, will the replication be from node1\sql2019 -> node3\SQL2019 or can it be from node2\sql2019 -> node3\SQL2019 also

The data replication is from node1\sql2019 -> node3\SQL2019. The replication is from primary replica to secondary replica.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 2

Hi @Vishu ,

We can have sync replication and auto failover between primary and secondary replica when we setting secondary replica for read only.

I check this in my environment.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 3

Thanks , but does it lead to a lot of locking due to sync replication for the read requests

Also with node1\sql2019 being primary, will the replication be from node1\sql2019 -> node3\SQL2019 or can it be from node2\sql2019 -> node3\SQL2019 also