activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan Jovanovic <ivan.jovano...@gmail.com>
Subject Re: How to configure AMQ to use a database cluster instead of a single db?
Date Wed, 07 May 2008 14:59:08 GMT

I have the same question?

Did anyone implemented this kind of configuration?

Cheers,
Ivan

j0llyr0g3r wrote:
> 
> Hey folks, 
> 
> i have a configuration problem which hopefully can be solved:
> 
> I have an up and running mySQL-Cluster consisting of 2 nodes (let's say
> mydbhost1 and mydbhost2) which works so far as i can tell.
> 
> Currently i have two AMQ-instances, configured as a cluster as well.
> 
> But here is the problem:
> 
> How can i tell activemq to use the __other__ mySQL-node in case its
> primary mysql-node shuts down?
> 
> Currently my data-source configuration in AMQ looks like this, using
> "mydbhost1":
> 
>   <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://mydbhost1/activemq?relaxAutoCommit=true"/>
>      <property name="username" value="wnmf"/>
>      <property name="password" value="wnmf"/>
>      <property name="poolPreparedStatements" value="true"/>
>   </bean> 
> 
> But how can i tell AMQ to use my "mydbhost2" in case "mydbhost1" fails
> over?
> 
> Can i simply set a comma-separated list in the configuration like:
> 
> <property name="url" value="jdbc:mysql://mydbhost1/activemq,
> jdbc:mysql://mydbhost2/activemq"/>
> 
> ?
> 
> I didn't find anything in the manual or via google......
> 
> Any help is highly appreciated!
> 

-- 
View this message in context: http://www.nabble.com/How-to-configure-AMQ-to-use-a-database-cluster-instead-of-a-single-db--tp13066825s2354p17106207.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message