Sample Header Ad - 728x90

Is it a good idea to have a read connection point to both write database and read replica?

0 votes
0 answers
137 views
In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here ) In the past the dns server was connected to two read replicas but I removed one to cut costs. It happened that the only read replica I had had a physical failure and had to restart, in that time my whole system went down. I was wondering if it's a good idea to make read connection point to the dns server, which in turn points to both the read replica that I have and the write database as depicted here: enter image description here
Asked by abbood (503 rep)
Aug 28, 2019, 08:46 AM
Last activity: Aug 28, 2019, 10:09 AM