Check the Health of a ksqlDB Server
Check a ksqlDB Server from the ksqlDB CLI¶
Check the streams, tables, and queries on the ksqlDB Server that you're connected to by using the DESCRIBE EXTENDED and EXPLAIN statements in the ksqlDB CLI.
- Run SHOW STREAMS or SHOW TABLES, then run
DESCRIBE EXTENDED <stream|table>. - Run SHOW QUERIES, then run
EXPLAIN <query-name>.
Check a ksqlDB Server running in a native deployment¶
If you installed ksqlDB server by using a package manager, like a DEB or RPM, or from an archive, like a TAR or ZIP file, you can check the health of your ksqlDB Server instances by using shell commands.
Check the ksqlDB Server process status¶
Use the ps command to check whether the ksqlDB Server process is
running:
1 | |
Your output should resemble:
1 | |
If the process status of the JVM isn't Sl or Ssl, the ksqlDB server
may be down.
Check a ksqlDB Server by using the REST API¶
The ksqlDB REST API supports a "server info" request, which you access
with a URL like http://<ksqldb-server-host>/info. The /info endpoint
returns the ksqlDB Server version, the Apache Kafka® cluster ID, and
the service ID of the ksqlDB Server.
Also, the ksqlDB REST API supports a basic health check endpoint at
/healthcheck.
Important
This approach doesn't work for non-interactive, or headless, deployments of ksqlDB Server, because a headless deployment doesn't have a REST API server. Instead, check the JMX metrics port.
For more information, see Introspect server status.
Check a ksqlDB Server running in a Docker container¶
If you're running ksqlDB server in a Docker container, run the
docker ps or docker-compose ps command, and check that the status of
the ksql-server container is Up. Check the health of the process in
the container by running docker logs <ksql-server-container-id>.
Check the JMX metrics port¶
In addition to the previous health checks, you can query the Java Management Extensions (JMX) port on a host that runs ksqlDB Server.
This is useful when you need to check a headless ksqlDB Server that's running natively or in a Docker container, because headless deployments of ksqlDB Server don't have a REST server that you can query for health. Instead, you can probe the JMX port for liveness. A JMX probe is the most reliable way to determine readiness of a headless deployment.
Note
JMX indicates that the JVM is up and responsive. This test is similar to confirming is the ksqlDB process is running, but a successful response doesn't necessarily mean that the ksqlDB service is fully operational. To get better exposure, you can monitor the nodes from Confluent Control Center or JMX.
The following command probes the JMX port by using the Netcat utility.
1 | |
An exit code of 0 for an open port tells you that the container and ksqlDB JVM are running. This confirmation has a level of confidence that's similar to the REST health check.
The general responsiveness on the port should be sufficient as a high-level health check. For a list of the available metrics you can collect, see JMX Metrics.