Aurora failover breaks jobs servers

[Manikandan85]

• Laravel Version: 5.7
• PHP Version: 7.2

Hi, I am using AWS Aurora with write and read servers with respective endpoints. When an Aurora fail over happens, read server gets switched to write servers.

After that switch, the database connections still goes to read server instead of write server. I think some DNS caching is happening there.

"SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement "

Is there any good solution to fix?