2 readonly and 1 updateable not work always

[walioul]

Hello ,

I want to use a single master instance and 2 read replica DB. When I add another Readonly then after reading from Read only database.

then when I want to write into a master database it throws the exception "The MySQL server is running with the --read-only option so it cannot execute this statement"
It happens from time to time not always.

Could you please help me using 2 Read Only database and single UPDATABLE database.

Thanks in advance

Walioul

[tranthanhdeveloper]

Hi, sorry for reply late. Could you give me the log and the configuration.

[weihao]

@tranthanhdeveloper

I ran into the same error, and the same setup as @walioul

Log:
Caused by: java.sql.SQLException: The MySQL server is running with the --super-read-only option so it cannot execute this statement

Config:
same as the code