High Foglight® Management Server load may consuming all connections to backend database. This results in any of the following problems:
To resolve this issue, increase available connections to the database.
1 |
Edit the appropriate <FOGLIGHT HOME>/config/datasource/datasource-dbtype.properties file. Take SQL Server for example, <FOGLIGHT HOME>/config/datasource/datasource-sqlsvr.properties. |
2 |
• |
maxTotal: The maximum number of connections that can be kept in the pool. Ensure that maxTotal >= maxIdle. |
• |
maxIdle: The maximum idle connections kept in the pool. |
1 |
Edit the appropriate <FOGLIGHT HOME>/config/datasource/datasource-dbtype.properties file. Take SQL Server for example, <FOGLIGHT HOME>/config/datasource/datasource-sqlsvr.properties. |
• |
maxTotal: The maximum number of connections that can be kept in the pool. Ensure that maxTotal >= maxIdle >= minIdle. |
• |
initialSize: The initial number of connections that are created when the pool is started. The initialSize is only used when the pool is created. |
• |
maxIdle: The maximum idle connections kept in the pool. |
1 |
Ensure that your user account has appropriate permissions to access the <FOGLIGHT HOME>\server\default\conf directory (Management Server 5.6.x) or <FOGLIGHT HOME>\server\jobss\conf (Management Server 5.7.1 and higher): |
• |
Windows®: Log in as an Administrator. |
• |
• |
• |
• |
• |
Postgres: Postgresql-ds.xml |
3 |
Locate the following line in the file, and then change the value of 20 to 50 or higher. <max-pool-size>${foglight.database.max_pool_size:20}</max-pool-size> |
4 |
(Management Server 5.7.5.3 and higher only) You must remove the foglight.database.max_pool_size entry and just enter the hardcoded value: <max-pool-size>50</max-pool-size> |
1 |
Ensure that your user account has appropriate permissions to access the <FOGLIGHT HOME>\server\default\conf directory: |
• |
Windows®: Log in as an Administrator. |
• |
• |
• |
• |
3 |
Add min-pool-size and max-pool-size elements between password and before prepared-statement-cache-size, as follows: |
High Availability (HA) means running multiple Foglight® Management Servers in a cluster, where one is the primary and one or more are secondaries (on standby). The general setup, as well as the communication between the members of the cluster, requires special attention.
These issues may be attributable to JGroup (the underlying communication package that JBoss® uses for its HA implementation) and to the fact that a Foglight HA implementation uses UDP for communication by default and UDP is by nature an unreliable protocol.
If you encounter these HA issues, consider performing the following tuning exercise.
b |
Edit server/default/deploy/cluster-service.xml by doing the following: |
c |
Locate the line beginning <TCPPING initial_hosts="thishost[7800],thathost[7800]" and change thathost to the host name of the secondary server in the cluster. If there are more than two servers in the cluster, add those servers to the list as well: thishost[7800],host2[7800],host3[7800]. |
To specify the IP address or host name to be used for communication, set the following:
You can set this using the command line interface or by adding the following to the server.config file:
server.cmdline.option0 = "-Djboss.bind.address=127.0.0.1";
server.cmdline.option0 = “-Dbind.address”;
server.cmdline.option1 = “127.0.0.1”;
where 127.0.0.1 is the desired IP address
server.cmdline.option0 = "-Djboss.bind.address=host1.example.com";
server.cmdline.option1 = "-Dbind.address=host1.example.com";
where host1.example.com is the desired host name
You also need to reconfigure the restarter to perform server health check with the same host name or IP address. To do so, open the restart_monitor.config file, find the line beginning with health.check.url, and replace localhost with the host name or IP address specified with --host.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center