activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Tully <gary.tu...@gmail.com>
Subject Re: JDBC Master Slave Question
Date Mon, 29 Jun 2009 10:07:09 GMT
You have got to ask the JDBC driver or database documentation. I imagine
there is a lock expiry option that can be tweaked.

2009/6/29 colonelx <zac@zacburke.com>

>
> Hi,
>
> I have 2 brokers setup in a JDBC Master Slave Configuration.
>
> Each broker is on a different machine. BoxA and BoxB
> The database is also on a different machine BoxC. (mysql 5.1)
>
> The failover is working fine when I manually kill any instance of ActiveMQ
> on BoxA or BoxB. (Ctrl-C)
>
> However, can anyone tell me what will happen if the if the Master instance
> looses its network connection ?
> Will its lock on the database get dropped immediately ? or will it still
> hold a (now invalid) lock on the database ?
> I ask this, because if this happens , there could possibly be a condition
> where the slave won't ever be able to get a lock on the database because
> the
> master has lock which did not get correctly released and manual
> intervention
> would be needed in order to fix up the problem.
>
> I know that I could test this by plugging in and out the physical network
> connections, but I'm not really in a position to do this on any of the
> above
> boxes.
>
> Thanks.
>
> --
> View this message in context:
> http://www.nabble.com/JDBC-Master-Slave-Question-tp24251198p24251198.html
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>


-- 
http://blog.garytully.com

Open Source Integration
http://fusesource.com

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