Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cluster wide connection resources management in Ignite, using Hikari

How can I manage resources on ignite.

Given the application i am developing, i have a few connections that i used to keep, (JDBC/SAP/others). I used to keep all the connections in a pool and manage them using HIKARI. Now given that now I can have a cluster of machines using ignite, what method can I use, so that I can distribute the connections across the nodes.

Ignite doesn't provide this mechanism out of the box.

I have thought of using services as a container for these connections, but then the management of connection is an extra overhead. As good as reinventing the wheel.

Hikari doesn't have any cluster management features and hence is limited to single node resource.

Any suggestions will be appreciated.

like image 746
frewper Avatar asked Aug 11 '17 10:08

frewper


1 Answers

Did you have a chance to take a look at JDBC client node driver? It should handle distributing the queries between nodes.

like image 188
alexmagnus Avatar answered Nov 03 '22 01:11

alexmagnus