Re:Re: ActiveMQ Master/slave with MySQLCluster backend

[SuoNayi]

Hi,are you using Mysql Cluster?
 I think amq can work only when the lease database lock is used.



At 2013-03-28 03:26:08,schweet <aktar...@gmail.com> wrote:
>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.