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
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
Hi @Vishu-2318,
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.
Hi @Vishu-2318,
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.
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
12 people are following this question.