Page tree
Skip to end of metadata
Go to start of metadata

This documentation is valid only for Console 1.x.

Introduction

By default each Node will open and maintain a maximum of 10 connections to the associated CAST Storage Service / PostgreSQL instance. Some of these connections may remain idle. If you would like to modify the number of open connections, particularly if you have multiple Nodes using the same CAST Storage Service / PostgreSQL instance, please see below.

Step 1 - Edit the configuration file

A configuration file (aip-node-app.properties) must be edited to make these changes. This file is available on EACH Node, therefore if you have more than one Node, you will need to make this change on all Nodes.

To do so, first locate this file:

<installation_folder>\AipNode\data\aip-node-app.properties

Edit the file with a text editor and locate the following lines:

# Minimum number of idle connections that are maintained in the connection pool. Recommended: same as maximumPoolSize
database.server.minimumIdle=10
# Maximum size that the connection pool is allowed to reach, including both idle and in-use connections
database.server.maximumPoolSize=10

CAST recommends keeping both options to the same value. Therefore if you decrease database.server.maximumPoolSize, you should also decrease database.server.minimumIdle to match. A technical explanation of each option is shown below:

database.server.minimumIdleThis property controls the minimum number of idle connections that the Node tries to maintain in the pool. If the idle connections dip below this value and total connections in the pool are less than maximumPoolSize, the Node will make a best effort to add additional connections quickly and efficiently. Default: same as maximumPoolSize
database.server.maximumPoolSize

This property controls the maximum size that the pool is allowed to reach, including both idle and in-use connections. Basically this value will determine the maximum number of actual connections to the CAST Storage Service / PostgreSQL instance. Default: 10

Save the file when the changes are complete.

Step 2 - Apply configuration changes

Restart the Nodes to ensure all changes are taken into account:

  • If the Nodes are installed as Windows Services, restart the services
  • If the Nodes are running only using the batch files, close the CMD windows to stop the processes, then restart then using the following file:
<installation_folder>\AipNode\tools\runAipNode.bat
  • No labels