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.