ClickHouse is is an open source column-oriented database management system. Instana can auto-discover and monitor ClickHouse server processes.
Sensor (Data Collection)
The Instana agent automatically finds the ClickHouse configuration file (
config.xml), either in its default location
/etc/clickhouse-server/config.xml or by inspecting the
--config-file argument that has been passed when starting the
clickhouse-server process. However, the agent currently does not support (that is, does not automatically parse) settings overrides specified in auxiliary configuration files in
config.d directories next to the main config file (see the Configuration files section of the ClickHouse documentation). ZooKeeper configuration is currently also not automatically taken into account.
The following configuration values are automatically tracked by parsing the ClickHouse configuration file.
The following metrics are collected:
The Instana agent automatically finds the ClickHouse config file (
config.xml), as described above. The agent can figure out most of the configuration values it needs to connect to ClickHouse by parsing this config file.
The Instana agent accesses ClickHouse via its HTTP interface. In a vanilla ClickHouse installation, this interface is accessible without credentials. In this case, the Instana ClickHouse sensor does not need any special configuration.
If, on the other hand, you have configured the ClickHouse HTTP access to require credentials, you need to provide said credentials to the Instana agent. This can be done by configuring them in the agent’s configuration file
Here are all possible configuration values for ClickHouse monitoring:
com.instana.plugin.clickhouse: user: admin password: admin protocol: http host: localhost httpPort: 8123
user: the user name used to access ClickHouse’s HTTP interface,
password: the user name used to access ClickHouse’s HTTP interface,
host: the host name or IP of the ClickHouse server
httpPort: the port of the ClickHouse server
The configuration value for
httpPort needs to be an integer value, otherwise it will be ignored, that is, if it can’t be parsed into a number, the standard port will be used.