HikariCP icon indicating copy to clipboard operation
HikariCP copied to clipboard

read only appears when mysql master-slave switch

Open mysql-wkp opened this issue 2 years ago • 2 comments

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.

mysql-wkp avatar Sep 08 '22 07:09 mysql-wkp

是不是

mysql-wkp avatar Sep 08 '22 08:09 mysql-wkp

got a read-only connection from the connection pool after the db failover #1802 I see this problem too, is there a solution now?

mysql-wkp avatar Sep 08 '22 09:09 mysql-wkp

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.

whenjonny avatar Feb 09 '23 02:02 whenjonny

I have explained in another repo, and now finding the ways to detect and reconnect.

whenjonny avatar Feb 09 '23 02:02 whenjonny