activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dejan Bosanac <de...@nighttale.net>
Subject Re: JDBC Master/Slave
Date Tue, 20 Oct 2009 08:07:31 GMT
Hi Nabil,

I don't see why database locking would not work in Tomcat environment. You
need to have database locking in order to have master/slave work correctly.
Also, pure jdbc adapter does not use any files on the filesystem, so
data-directory shouldn't make any difference.

Cheers
--
Dejan Bosanac - http://twitter.com/dejanb

Open Source Integration - http://fusesource.com/
ActiveMQ in Action - http://www.manning.com/snyder/
Blog - http://www.nighttale.net


On Mon, Oct 19, 2009 at 11:34 PM, NabiL <elaomari.nabil@gmail.com> wrote:

>
> Hi,
>
> I try to set up two AMQ 5.3 brokers (deployed on 2 tomcat servers ) to get
> some redundancy in
> our solution.
>
> The AMQ documentation describes the JDBC Master/slave as below :
> On startup one master grabs an exclusive lock in the broker database and
> all
> other brokers are slaves and pause waiting for the exclusive lock.
> >> This situation occurs only if we use AMQ as standalone (not embedding in
> >> server container tomcat)
>
> I configured the 2 AMQ Web-console5.3.war on each Tomcat server to use a
> shared DB (Mysql). As a result, the master start successfully and grabs the
> lock, the AMQ slave can't start. To resolve this situation i positioned
> useDatabaseLock=false.
>
> Questions :
> 1 - If i disable database locking.. Do i need to use some other mechanism
> to stop the slave broker from becoming active while the master is on-line
> in
> order to avoid data corruption ?
>
> 2 - i configured  persistenceAdapter element on each broker as show below :
>    <persistenceAdapter>
>        <jdbcPersistenceAdapter dataSource="#mysql-ds"
> useDatabaseLock="false"/>
>     </persistenceAdapter>
>
> <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://host/activemq?relaxAutoCommit=true"/>
>                <property name="username" value="xxx"/>
>                <property name="password" value="xxx"/>
>                <property name="maxActive" value="200"/>
>                <property name="poolPreparedStatements" value="true"/>
>   </bean>
>
>  As you can see, i did not specify  any data
> directory="${activemq.base}/data/ on jdbcPersistenceAdapter element. What
> is
> the difference if specify the data directory on this element ?
>
>
> Sorry for my bad english. Any help will be appreciated.
>
> Thanks in advance.
> NabiLo
>
>
> --
> View this message in context:
> http://www.nabble.com/JDBC-Master-Slave-tp25966078p25966078.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message