Prevent pooling of read-only connections to MySQL cluster in JBoss EAP
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, tools, and much more.