[Clickhouse] Clickhouse Install

[ 개요 ]

* OS : Ubuntu 20.04

* Clickhouse : v23.3.2.37-lts

https://github.com/ClickHouse/ClickHouse/releases/tag/v23.3.2.37-lts

Release Release v23.3.2.37-lts · ClickHouse/ClickHouse

 

[ Clickhouse Install ]

1. Clickhouse Package Install

sudo apt-get install -y apt-transport-https ca-certificates curl gnupg
curl -fsSL 'https://packages.clickhouse.com/rpm/lts/repodata/repomd.xml.key' | sudo gpg --dearmor -o /usr/share/keyrings/clickhouse-keyring.gpg

echo "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg] https://packages.clickhouse.com/deb stable main" | sudo tee \
    /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update

 

2. clickhouse-server, client, common-static Install - v23.3.2.37

sudo apt-get install clickhouse-server=23.3.2.37 clickhouse-client=23.3.2.37 clickhouse-common-static=23.3.2.37

* clickhouse-server가 설치 된 경우, 별도로 clickhouse-keeper를 설치하지 않아도 됨

* clickhouse-server에 clickhouse-keeper 기능이 내장되어 있음

 

3. clickhouse-server 실행

systemctl start clickhouse-server

clickhouse-client
ClickHouse client version 23.3.2.37 (official build).
Connecting to localhost:9000 as user default.
Password for user (default): 
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 23.3.2 revision 54462.

Warnings:
 * Linux threads max count is too low. Check /proc/sys/kernel/threads-max
 * Available memory at server startup is too low (2GiB).
 * Maximum number of threads is lower than 30000. There could be problems with handling a lot of simultaneous queries.

click01.test.com :)

 

https://clickhouse.com/docs/en/install#install-from-deb-packages

Install ClickHouse | ClickHouse Docs