Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-4035

Improve JDBC connection management

XMLWordPrintable

      I have a case where the whole clustering reliability and HA must rely on HA capabilities of clustered database, and running on top of application server is not an option.

      The current JDBC store implementation is rather bare bones on the connection management side. JDBC driver is used directly with no management layer. At startup, the broker just opens couple of direct connections to database and expects them to be available forever. This is something that cannot be expected in HA production environment. So, similarly to the discussion linked below, in our case we lose the db connection after one hour, and all the brokers need to be restared to get new connections:

      http://activemq.2283324.n4.nabble.com/Artemis-does-not-reconnect-to-MySQL-after-connection-timeout-td4751956.html 

      This is something that could be resolved by simply using JDBC4 isValid checks, but proper connection handling and pooling through datasource would be preferrable.

      I have implemented a solution for this by using DBCP2 datasource. Our test cluster has been successfully running this forked version since the release of Artemis 2.13.0. I will prepare of pull request if this is seen to be something that can be useful.

              fnigro Francesco Nigro
              fnigro Francesco Nigro
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: