When using eclipse link as backend metastore, I noticed it is using default connection pool (32 connections or so) per pod regardless the size of the pod. To avoid too many small pods, it will be nice to increase the number of connections allowed per pod. I tired the following settings but they doesn't seem to be taking effect:
<property name="eclipselink.connection-pool.default.initial" value="1"/>
<property name="eclipselink.connection-pool.default.min" value="64"/>
<property name="eclipselink.connection-pool.default.max" value="64"/>
Here is how I validated:
- Updated persistence.xml to include these 3 settings
- Rebuilt the docker image with updated persistence.xml
- Spun up X number of pods
- Checked the number of established connection on the backend database
With the above setting, it should keep a connection pool of 64 connections per pods, however, that is not I observed with the steps mentioned above.