- Grafana dashboards basic reports, Proton Server
- reports (materialized views and queries) basic reports, tags reports
- timers
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4 # optional
echo "deb http://repo.yandex.ru/clickhouse/deb/stable/ main/" | sudo tee /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update
sudo apt-get install -y clickhouse-server clickhouse-client
sudo service clickhouse-server start
clickhouse-client
clickhouse-client -n < schema/schema.sql
and then create the base report table and materialize view
clickhouse-client -n < schema/reports/base.sql
Example:
<?xml version="1.0" encoding="UTF-8"?>
<dictionaries>
<dictionary>
<name>Proton</name>
<source>
<clickhouse>
<host>127.0.0.1</host>
<port>9500</port>
<user>default</user>
<password></password>
<db>proton</db>
<table>dictionary</table>
</clickhouse>
</source>
<lifetime>600</lifetime>
<layout><hashed /></layout>
<structure>
<id><name>ID</name></id>
<attribute>
<name>Value</name>
<type>String</type>
<null_value></null_value>
</attribute>
</structure>
</dictionary>
</dictionaries>
Download latest Proton server
And run it.
NAME:
Proton - high performance Pinba storage server.
VERSION:
0.2 rev[f2e5ae4] master (2019-03-20.12:40:46 UTC).
USAGE:
-addr string
listen address (default ":30002")
-backlog int
backlog size (default 10000)
-concurrency int
number of the background processes (default 2)
-dsn string
ClickHouse DSN (default "native://127.0.0.1:9500")
-metrics_addr string
address on which to expose metrics (default ":2112")
-pprof string
pprof address. If set to start the pprof server
If you are using the deb
package, change the startup options in /etc/proton-server/options
.