HikariCP
HikariCP copied to clipboard
read only appears when mysql master-slave switch
aurora in failover The connection in the connection pool is not still connected to the old main library, read_only appears, and yes, the system cannot write.
是不是
got a read-only connection from the connection pool after the db failover #1802 I see this problem too, is there a solution now?
Aurora explains that the ip will change after failover or restart. And after failover the read replica will restart and continue to work, after that the connection pool will reconnect and it seems fine before mutating the data.
I have explained in another repo, and now finding the ways to detect and reconnect.