I tried searching but couldnt find anything, neither here nor googling. Anyways I would like to use MySQL's hot-standby replication. It is basically a master/slave design with log based recovery. I have my app running fine with one mysql DB but would like to know if there is a way for JBoss to attempt to connect to another DB if the first one is not available. Or if theres is another way to make this work. The slave DB will not be at the same ip as the App server or the Master DB. I would like to have JBoss handle this as I can't think of another way of doing it.
Can anyone point me in the right direction? Thanks.
Using jboss 3.2.3, mysql 4.0.16 max, winXP, newest JDBC connector etc, also using HIbernate2 for CMP with stateless session beans and some MDB's.