activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From schweet <aktar...@gmail.com>
Subject Re: ActiveMQ Master/slave with MySQLCluster backend
Date Wed, 27 Mar 2013 09:06:08 GMT
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.

Mime
View raw message