From users-return-13902-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org Wed May 07 14:59:40 2008 Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 97837 invoked from network); 7 May 2008 14:59:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 May 2008 14:59:40 -0000 Received: (qmail 32876 invoked by uid 500); 7 May 2008 14:59:41 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 32518 invoked by uid 500); 7 May 2008 14:59:41 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 32507 invoked by uid 99); 7 May 2008 14:59:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 May 2008 07:59:41 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 May 2008 14:58:54 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Jtl6q-0008Qi-Rr for users@activemq.apache.org; Wed, 07 May 2008 07:59:08 -0700 Message-ID: <17106207.post@talk.nabble.com> Date: Wed, 7 May 2008 07:59:08 -0700 (PDT) From: Ivan Jovanovic To: users@activemq.apache.org Subject: Re: How to configure AMQ to use a database cluster instead of a single db? In-Reply-To: <13066825.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ivan.jovanovic@gmail.com References: <13066825.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org 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": > > destroy-method="close"> > > value="jdbc:mysql://mydbhost1/activemq?relaxAutoCommit=true"/> > > > > > > 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: > > > > ? > > 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.