Geek Answers Handbook

Managing connection resources in a cluster in Ignite using Hikari

How can I manage resources when ignited.

Given the application I am developing, I have several connections that I used for storage (JDBC / SAP / others). I used all the connections in the pool and managed them using HIKARI. Now, given that I can now have a cluster of machines using ignite, which method can I use so that I can distribute connections across nodes.

Ignite does not provide this mechanism out of the box.

I was thinking about using services as a container for these connections, but then managing the connection is an additional cost. Just like reinventing the wheel.

Hikari does not have any cluster management features and therefore is limited to a single node resource.

Any suggestions would be appreciated.

+6
source share
2 answers

Do you have the opportunity to take a look at the JDBC client node driver ? It must handle the distribution of requests between nodes.

+2
source

Starting with 4.2 SP2, SAP Data Services now supports the use of JDBC drivers as a data source. This feature is implemented through a new type of JDBC adapter.

To add a JDBC adapter, you use the Data Services Administration Console, navigate to the adapter instances, select the job server, and then select Adapter Configuration.

SAP Data Services JDBC

SAP HANA , Java SAP HANA JDBC (API).

SAP HANA JDBC

0

More articles:


All Articles