activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mikmela <mikm...@yahoo.com>
Subject JDBC based Master/slave configuration
Date Tue, 31 Jan 2012 18:34:20 GMT
As it was mentioned  in
http://activemq.2283324.n4.nabble.com/activemq-user-Network-of-brokers-and-db-schema-td2342357.html#a2342360

"Its technically possible to patch the JDBC message store to include a
broker ID column in all the tables to allow the same JDBC database to be 
used for multiple brokers..."
Understanding all drawbacks of such approach,  we would like to use  "shared
database instance" approach for multiple master/slave groups of brokers as a
default configuration to simplify client's burden in administration of our
product. Our software allowing to create/configure multiple brokers in
master/slave groups dynamically via GUI. The problem is the current ActiveMQ
master/slave default implementation requires a separate database instance
for each master/slave group. 
I was wondering if someone has implemented somethinng like this? 
Looking into the source I can see that most of the SQL statements will need
to be customized... This, seems, can be done via <statements> element in
configuration xml... Possibly,  we'll need own jdbcadapter similar to
SybaseJDBCAdapter or OracleJDBCAdapter, or just extend
JDBCPersistenceAdapter. DefaultDatabaseLocker might require to be extended
as well... Is this correct assessment, or much more is involved? 

I'd appreciate any help on this matter...

--
View this message in context: http://activemq.2283324.n4.nabble.com/JDBC-based-Master-slave-configuration-tp4345431p4345431.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Mime
View raw message