This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes Jboss and mysql connection (failover) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Jboss and mysql connection (failover) " Watch "Jboss and mysql connection (failover) " New topic

Jboss and mysql connection (failover)

dp dp

Joined: Feb 25, 2003
Posts: 1
Dear All,
I am using JBoss 3.0.4 and MySQL-3.23.55-1 and mysql-connector-java-2.0.14-bin.jar.
I have two application servers (JBOSS) and two mysql. Mysql is using replication method.
Only one of Mysql is using can be Read-Write and the other is read only. If there is any failure in the master db, the slave will take over and become to master.
The dbURL in jboss's datasource is using a domain name (i.e. mysqltest) and it maps to one of the mysql's ip address. So if there is any failure, the mysqltest will point to another mysql. However, how can i make the failover procedure with db connection transparents to client?
I read jConnection-3.0.8 support failover but the connection for the failover server is read only.
Any other suggestion?
Very appreciate for your kindly help!
subject: Jboss and mysql connection (failover)
Similar Threads
ActiveMQ, Queue Failover Question
OutOfMemory Error
unable to catch EJBException from ejbstore in facade
Query about rollback() method
Jboss-MySql Connection Problem