Rocky Linux 8.4に指向型データベースClickHouseをインストールする

OSバージョンの確認

# cat /etc/redhat-release
Rocky Linux release 8.4 (Green Obsidian)
操作方法
1.yum-utils導入
# sudo dnf -y install yum-utils
2.GPGキーのインポート

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
# sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
# sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
# sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG

3.リポジトリを追加

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
# sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
repo の追加: https://repo.clickhouse.tech/rpm/clickhouse.repo
# sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo repo の追加: https://repo.clickhouse.tech/rpm/clickhouse.repo
# sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
repo の追加: https://repo.clickhouse.tech/rpm/clickhouse.repo

4.clickhouseのインストール
# sudo dnf -y install clickhouse-server clickhouse-client

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
インストール済み:
clickhouse-client-21.11.4.14-2.noarch
clickhouse-common-static-21.11.4.14-2.x86_64
clickhouse-server-21.11.4.14-2.noarch
略 インストール済み: clickhouse-client-21.11.4.14-2.noarch clickhouse-common-static-21.11.4.14-2.x86_64 clickhouse-server-21.11.4.14-2.noarch
略
インストール済み:
  clickhouse-client-21.11.4.14-2.noarch
  clickhouse-common-static-21.11.4.14-2.x86_64
  clickhouse-server-21.11.4.14-2.noarch

5.起動
# sudo systemctl start clickhouse-server
自動起動
# sudo systemctl enable clickhouse-server

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
Synchronizing state of clickhouse-server.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable clickhouse-server
Synchronizing state of clickhouse-server.service with SysV service script with /usr/lib/systemd/systemd-sysv-install. Executing: /usr/lib/systemd/systemd-sysv-install enable clickhouse-server
Synchronizing state of clickhouse-server.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable clickhouse-server

ステータスを確認
# sudo systemctl status clickhouse-server

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vend>
Active: active (running) since Fri 2021-11-19 21:57:23 JST; 1min 8s ago
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data) Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vend> Active: active (running) since Fri 2021-11-19 21:57:23 JST; 1min 8s ago
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vend>
Active: active (running) since Fri 2021-11-19 21:57:23 JST; 1min 8s ago

6.接続確認
# clickhouse-client

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
ClickHouse client version 21.11.4.14 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.11.4 revision 54450.
test.arkgame.com :)
ClickHouse client version 21.11.4.14 (official build). Connecting to localhost:9000 as user default. Connected to ClickHouse server version 21.11.4 revision 54450. test.arkgame.com :)
ClickHouse client version 21.11.4.14 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.11.4 revision 54450.

test.arkgame.com :)

 

Rocky Linux 8

Posted by arkgame