Health Monitoring

When you deploy the Denodo Platform or the Solution Manager behind a load balancer or on a Kubernetes cluster, you may need to check if their components are alive.

This page explains how to check if the components of the Denodo Platform and the Solution Manager are “alive”. Note that this page has a table for the components of the Solution Manager and another for the components of the Solution Manager. Some components are included in both and in that case, the only thing that changes to test if they are alive is the port in which they listen to connections.

Components of Denodo Platform

Notes

Virtual DataPort and the web container

To probe Virtual DataPort and also, the web container, create a view (e.g. CREATE OR REPLACE VIEW ping_query_view AS SELECT 1) and query it with the RESTful web service:

https://denodo-server.acme.com:9443/denodo-restfulws/admin/views/ping_query_view?$format=json

This endpoint will return the HTTP status code 200 if Virtual DataPort and the web container are alive.

As an alternative, you can also test if Virtual DataPort is alive with the script <DENODO_HOME>/bin/ping -q <query>. However, you will not test if the web container is working. For example:

<DENODO_HOME>/bin/ping.sh -v -t 30000 -q "SELECT 1" -l monitor_user
-p "encrypted:UjOsIu8972jviqGpcLP3Mg==" //denodo-server.acme.com/admin

See more in How to Check If a Virtual DataPort Server Is Alive (Virtual DataPort Administration Guide)

Data Catalog

Send an HTTP request to

https://denodo-server.acme.com:9443/denodo-data-catalog/Ping

This endpoint returns the HTTP status code 200 if the Data Catalog is alive. The body of the response is empty.

Design Studio

Send an HTTP request to

https://denodo-server.acme.com:9443/denodo-design-studio/Ping

This endpoint returns the HTTP status code 200 if the Design Studio is alive. The body of the response is empty.

Diagnostic & Monitoring Tool

Send an HTTP request to

https://denodo-server.acme.com:9443/diagnostic-monitoring-tool/Ping

This endpoint returns the HTTP status code 200 if this tool is alive.

Scheduler

Use the ping script of Scheduler (<DENODO_HOME>/tools/scheduler/ping).

Scheduler Administration Tool

Send an HTTP request to

https://denodo-server.acme.com:9443/webadmin/denodo-scheduler-admin/Ping

This endpoint returns the HTTP status code 200 if this tool is alive.

Scheduler Index Server

Use the export script of Scheduler Index to validate the connection with this component.

Components of Solution Manager

Notes

Design Studio

Send an HTTP request to

https://denodo-server.acme.com:19443/denodo-design-studio/Ping

This endpoint returns the HTTP status code 200 if the Design Studio is alive. The body of the response is empty.

Diagnostic & Monitoring Tool

Send an HTTP request to

https://denodo-server.acme.com:19443/diagnostic-monitoring-tool/Ping

This endpoint returns the HTTP status code 200 if this tool is alive.

License Manager

Send an HTTP request to

https://denodo-server.acme.com:10091/pingLicenseManager

This endpoint returns the HTTP status code 200 if the service is alive. See more about this in Ping License Manager Server.

Scheduler Administration Tool

Send an HTTP request to

https://denodo-server.acme.com:19443/webadmin/denodo-scheduler-admin/Ping

This endpoint returns the HTTP status code 200 if this tool is alive.

Security Token Server (Denodo SSO)

Send an HTTP request to

https://denodo-server.acme.com:19443/sso/ping

This endpoint returns the HTTP status code 200 if the service is alive.

Solution Manager

Send an HTTP request to

https://denodo-server.acme.com:10090/pingSolutionManager

This URL returns the HTTP status code 200 if this tool is alive. See more about this in REST API.

Solution Manager Administration Tool

Send an HTTP request to

https://denodo-server.acme.com:19443/solution-manager-web-tool/Ping

Virtual DataPort and the web container

To probe Virtual DataPort and also, the web container, create a view (e.g. CREATE OR REPLACE VIEW ping_query_view AS SELECT 1) and query it with the RESTful web service:

https://denodo-server.acme.com:19443/denodo-restfulws/admin/views/ping_query_view?$format=json

This endpoint will return the HTTP status code 200 if Virtual DataPort and the web container are alive.

As an alternative, you can also test if Virtual DataPort is alive with the script <DENODO_HOME>/bin/ping -q <query>. However, you will not test if the web container is working. For example:

<DENODO_HOME>/bin/ping.sh -v -t 30000 -q "SELECT 1" -l monitor_user
-p "encrypted:UjOsIu8972jviqGpcLP3Mg==" //denodo-server.acme.com:19999/admin

See more in How to Check If a Virtual DataPort Server Is Alive (Virtual DataPort Administration Guide)

Consider this if you did not enable HTTPS on these components:

  • In the installation of the Denodo Platform, the HTTP port is 9090 by default.

  • In the installation of the Solution Manager, the HTTP port is 19090 by default.