MQSeries.net :: View topic - JDBC Adapters in an Active/Active cluster environment

dotaneli · Posted: Wed Mar 18, 2009 1:45 am Post subject:

Hey everyone.

I am currently designing an Active/Active environment of wbi.
We decided to go with 2 RH machines, each containing one QMgr and one Broker. Same flows run on both machines, so as same queues in qmgrs.

Qmgrs are clustered and queues serving the flows are shared for maximum load balancing.

All the flows in the organization are stateless.

What i do not know precisely is the way the JDBC adapter operates regarding events from the DB.

We plan of having 2 adapters, one for each broker - residing that broker on the same physical machine.

Correct me if I'm wrong, but as far as i know - JDBC adapter listens to a table which concentrates all the events that we wanted to know about, from specific tables.

Once it finds a new row, it generates an MQ message and sends it to the broker for analysis.

What happens then? does it "mark" the read message? does it copy it to a shadow table containing the read events?
Does it delete that event?

When the adapter accesses that event table - does it open it as "select for update" or locks it in any way?

The main issue at hand is what happens if both adapters detect new events, and our system is notified twice for that same event?

I would love to here some insights about it...

Thanks,

Eli.