I have a postgresql server that I am unable to manage it. Though it has master-slave replication and I set up my laravel application with the correct connection credentials.

But sometimes replication comes up with unwanted errors. Therefore, how I can configure my Laravel application to recconect in case that replication-based sql errors happen?

How to force Laravel database layer to retry queries that have canceled because of replication error

Jan 20 '20 Comments: 1 Answers: 0

0

I have a Laravel application that uses 2 PostgreSQL database replicas for reading data. The load balancing between these databases is happening via rotating DNS.

The application itself uses the DNS name to access the read-only replicas. But during the query execution I get the following error:

SQLSTATE[40001]: Serialization

…

Open Full Question