Re: ActiveMQ multiple JDBC data sources in same configuration

Thank you JB, I will definitely take a look at that. Vince Get Outlook for iOS From: Jean-Baptiste Onofre Sent: Tuesday, May 25, 2021 12:12:51 AM To: users@activemq.apache.org Subject: Re: ActiveMQ multiple JDBC data sources in same config

Re: ActiveMQ multiple JDBC data sources in same configuration

Hi Vince, It’s possible to have different datasource: one for the main message store, one for the lease locker. As JDBC leaser locker extends persistent adapter, you can pass a datasource. Something like this should work: You can take a look on http://blog

Re: ActiveMQ multiple JDBC data sources in same configuration

Matt, We have not noticed any locking. Data server from the DB just fine. But, the leased locker functionality seems to fail over errantly while using the pool. I will see if I can get them to open a Jira against this. Thank you. Vince Get Outlook for iOS __

Re: ActiveMQ multiple JDBC data sources in same configuration

Hey Vince, Most likely DB tuning and/or connection lifecycle coordination b/w the connection factory used by ActiveMQ and the database instance. Can’t rule out a bad or flaky database either. If the customer is struggling with keeping the connection pool tuned and consistent, adding more syste

Re: ActiveMQ multiple JDBC data sources in same configuration

Thanks for replying so quickly Matt. Customer is not having and issue with the data in the DB. The issue shows itself when ActiveMQ randomly has failover events when the lock is in the DB. It’s using the same connection pool as the store. Seems to be some type of contention and master slave pai

Re: ActiveMQ multiple JDBC data sources in same configuration

Hello Vince- Are you able to detail out the use case and rationale for separating the data store from the locker? On the surface that sounds like creating an extra runtime coupling with a distributed system— generally that approach creates more aggregate downtime. Thanks, Matt Pavlovich > On

Dynamic queues with filters, question

I have an integration layer that I'm using to receive data. I'd like to publish this data to Artemis to make it available to multiple applications. The data comes from multiple sources, and the data has different classifications. So, a simple example would be banks and currency. I'm listening to m

ActiveMQ multiple JDBC data sources in same configuration

Are there any future plans with ActiveMQ that will provide separate data source (using JDBC) to handle leader activity and message traffic? We are aware we can use kahaDB and JDBC, but we’d like to have a separate JDBC sources for our message store and our lock. Thank you. Vince This e-mail