Re: ActiveMQ Master/slave with MySQLCluster backend

[schweet]

Hi;

I have master/slave MQ setup with Multi master mesh Mysql back end. With the
following configurations, the failover works perfectly. Take down any DB
host that MQ is connected to, it connects to the next available DB host
automatically. No need to restart. Hope it helps:


        <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://db01.burberry.corp:3306,db02.burberry.corp:3306,db03.burberry.corp:3306/mqpdb_test?relaxAutoCommit=true&amp;autoReconnect=true&amp;maxReconnects=1&amp;failOverReadOnly=false&amp;roundRobinLoadBalance=true"/>
             <property name="maxActive" value="250"/>
             <property name="maxIdle" value="10"/>
             <property name="minIdle" value="5"/>
             <property name="testOnBorrow" value="true"/>
             <property name="validationQuery" value="select 1"/>
             <property name="username" value="mqpdb_test"/>
             <property name="password" value="87P5rfbTU"/>
             <property name="poolPreparedStatements" value="true"/>
        </bean>




--
View this message in context: 
http://activemq.2283324.n4.nabble.com/ActiveMQ-Master-slave-with-MySQLCluster-backend-tp4341454p4665178.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.