Prevent pooling of read-only connections to MySQL cluster in JBoss EAP

Solution Unverified - Updated -

Issue

During switchover from primary to secondary database in a MySQL cluster, the MySQL server/driver returns read-only connections (for a few seconds) which are not usable for the application.

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP) 7
  • MySQL

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In