MySQL Forums
Forum List  »  Utilities

MySQL fabric master database failover
Posted by: P P
Date: March 23, 2016 03:29AM

Hi All,

We are trying a MySQL master fail over scenario in our MySQL fabric setup. We are using MySQL connector J 5.1.38.

1. When initial startup all the connections are working fine.
2. When we stop the MySQL master node all the connections from the application are redirected to newly selected master.
3. When we again start the MySQL node and add it to fabric as slave, we are getting errors in the application.

2016-03-23 06:56:28.387 [http-8080-exec-4] ERROR o.s.t.i.TransactionInterceptor - Application exception overridden by commit exception
LicenseManagerException: org.hibernate.exception.GenericJDBCException: The MySQL server is running with the --read-only option so it cannot execute this statement

We are using tomcat JDBC connection pooling.

Any pointers will be really helpful.


Options: ReplyQuote

Written By
MySQL fabric master database failover
March 23, 2016 03:29AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.