Hi,
We upgraded our AWS RDS instance type that we use for our Akka Persistence Db. We use Slick jdbc driver on top. The steps are: 1. Spinup new db type and set as Read replica of the current Persistence Db. 2. Failover to the Read replica. The problem we encountered is that the persistence queries were failing because the MySQL server was running with --read-only flag. Why would this happen when the read replica should have been promoted to a write replica?
Our theory is that due to DNS caching Akka is still pointing to the old replica which has been downgraded to a read replica due to the failover. Is this what happens? How can we prevent this such that during failover persistence queries go to the new write replica?