Skip to content
Source
Sign inSign up

Run the analytics server

Site administration

Run the analytics server

You run the ClickHouse server that keeps the analytics events, and you must keep them safe. Pick a task below, and sign in to the server to do it.

2 min read

The server is the one of Set up analytics.

Pick a task

Sign in to the server

Connect as root, with the SSH key that you added when you created the server:

ssh root@<server IPv4>

The clickhouse-client commands of these tasks run there.

  • The admin user of ClickHouse is default. It can sign in only from the server itself.
  • The password of default is in /root/.clickhouse-admin. Only root can read this file.
  • The password of the user ingest is only in the Worker secret CLICKHOUSE_PASSWORD.

Keep the server up to date

  • Ubuntu installs its security updates by itself, with unattended-upgrades.

  • When an update needs a restart, the file /var/run/reboot-required exists. Then restart the server with reboot.

  • Update ClickHouse with apt:

    apt-get update
    DEBIAN_FRONTEND=noninteractive apt-get install --only-upgrade -y clickhouse-server clickhouse-client
    systemctl restart clickhouse-server

While ClickHouse or the server restarts, the consumer keeps its batches in the queue and tries them again later. No event is lost.