activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "R.I.Pienaar" <>
Subject MySQL active/passive cluster not recovering from master power failure
Date Fri, 30 Sep 2011 10:54:02 GMT

I have a active/passive setup using a mysql datastore:

    <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
       <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
       <property name="url" value="jdbc:mysql://jmsdb1/activemq?relaxAutoCommit=true"/>
       <property name="username" value="activemq"/>
       <property name="password" value="xx"/>
       <property name="poolPreparedStatements" value="true"/>

this works fine, one of the pair is master and one is slave based on the 
lock contention on the table.

When the master fails - like with a power failure or a kernel panic - the lock
does not get released though.  Even through a restart of the server the lock
do not get released.  If we just cleanly shut down the master like for maintenance
then it is all good.

After restart when the server eventually came back up it re-acquired the lock and
was again the master.

Failover never happened.  Is there some tunable setting or advice you can give on 
improving this setup to be better resilient to failure of this nature?

View raw message