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

  • The answer may depend on why you have a read replica in the first place.
    – jjanes
    Aug 28, 2019 at 14:42
  • I have a read replica for scalability
    – abbood
    Aug 29, 2019 at 5:15


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.