Suscribers locking during snapshot replication
- by remi_bourgarel
Hi all :)
Here is my architecture :
I have a main server and 4 replica (the servers are synchronized with snapshot replication).
The replication is working fine, except for one thing : during the replication a lot of SELECT request on one of the replica fail with a time-out.
Here are my questions :
Can I avoid these time-out ?
If I can't : how can I detect the start and the end of the replication to redirect all the request on one of the replica to the main ?
Thanks
Sorry if you already answered to that kind of question but I couldn't find anything.