➜ wget https://github.com/ClickHouse/ClickHouse/releases/download/v24.3.2.23-lts/clickhouse-client-24.3.2.23.x86_64.rpm
➜ wget https://github.com/ClickHouse/ClickHouse/releases/download/v24.3.2.23-lts/clickhouse-server-24.3.2.23.x86_64.rpm
➜ wget https://github.com/ClickHouse/ClickHouse/releases/download/v24.3.2.23-lts/clickhouse-common-static-24.3.2.23.x86_64.rpm
[root@244 clickhouse]# yum -y install ./clickhouse-*.rpm
[root@244 clickhouse]# systemctl enable clickhouse-server.service
[root@244 clickhouse]# systemctl start clickhouse-server.service
[root@244 clickhouse]# systemctl status clickhouse-server.service
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
Loaded: loaded (/usr/lib/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)
Active: active (running) since Sat 2024-04-13 16:59:54 CST; 1min 13s ago
Main PID: 3467476 (clickhouse-serv)
Tasks: 667 (limit: 1647559)
Memory: 480.0M
CGroup: /system.slice/clickhouse-server.service
├─3467475 clickhouse-watchdog --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid
└─3467476 /usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid
Apr 13 16:59:53 GNHK-11-1-73-244.h.abchost.local systemd[1]: Starting ClickHouse Server (analytic DBMS for big data)...
Apr 13 16:59:53 GNHK-11-1-73-244.h.abchost.local clickhouse-server[3467475]: Processing configuration file '/etc/clickhouse-server/config.xml'.
Apr 13 16:59:53 GNHK-11-1-73-244.h.abchost.local clickhouse-server[3467475]: Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Apr 13 16:59:53 GNHK-11-1-73-244.h.abchost.local clickhouse-server[3467475]: Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
Apr 13 16:59:53 GNHK-11-1-73-244.h.abchost.local systemd[1]: clickhouse-server.service: Supervising process 3467476 which is not our child. We'll most likely not notice when it exits.
Apr 13 16:59:54 GNHK-11-1-73-244.h.abchost.local systemd[1]: Started ClickHouse Server (analytic DBMS for big data).[root@244 clickhouse]# netstat -ntlp | grep clickhouse
tcp 0 0 127.0.0.1:8123 0.0.0.0:* LISTEN 3467476/clickhouse-
tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 3467476/clickhouse-
tcp 0 0 127.0.0.1:9004 0.0.0.0:* LISTEN 3467476/clickhouse-
tcp 0 0 127.0.0.1:9005 0.0.0.0:* LISTEN 3467476/clickhouse-
tcp 0 0 127.0.0.1:9009 0.0.0.0:* LISTEN 3467476/clickhouse-
tcp6 0 0 ::1:8123 :::* LISTEN 3467476/clickhouse-
tcp6 0 0 ::1:9000 :::* LISTEN 3467476/clickhouse-
tcp6 0 0 ::1:9004 :::* LISTEN 3467476/clickhouse-
tcp6 0 0 ::1:9005 :::* LISTEN 3467476/clickhouse-
tcp6 0 0 ::1:9009 :::* LISTEN 3467476/clickhouse- clickhouse-server监听端口说明:
8123：这是 ClickHouse 的 HTTP 接口端口。它用于 HTTP 客户端请求，包括查询执行和数据插入。这个端口允许用户通过 HTTP 协议发送 SQL 查询，是 ClickHouse 提供的一种便捷的访问方式。
9000：这是 ClickHouse 的原生客户端接口端口。它用于 ClickHouse 自己的客户端和其他支持原生协议的客户端工具。比 HTTP 接口更高效，适合大量数据的传输和查询。
9004：这个端口用于 ClickHouse Keeper 的通信。ClickHouse Keeper 是 ClickHouse 自己的高可用解决方案，用于替代 ZooKeeper。Keeper 用于协调分布式 ClickHouse 集群中的节点状态和元数据。
9005：在一些 ClickHouse 版本中，这个端口用于分布式DDL操作。它用于在 ClickHouse 集群中执行跨多个节点的DDL（数据定义语言）操作，如创建表、修改表结构等。
9009：这个端口用于 ClickHouse 的 interserver HTTP 接口。它用于 ClickHouse 集群内部的数据复制和分布式查询处理。当一个 ClickHouse 节点需要从另一个节点获取数据时，会使用这个端口。
/etc/clickhouse-server/config.xml 推荐配置修改：
<!-- Path to data directory, with trailing slash. --> <path>/var/lib/clickhouse/</path> --> 数据的目录路径修改： <path>/export/clickhouse/</path><!-- Path to temporary data for processing hard queries. --> <tmp_path>/var/lib/clickhouse/tmp/</tmp_path> --> 用于处理大型查询的临时数据的路径修改： <tmp_path>/export/clickhouse/tmp/</tmp_path><!-- Directory with user provided files that are accessible by 'file' table function. --> <user_files_path>/var/lib/clickhouse/user_files/</user_files_path> --> 包含用户文件的目录修改: <user_files_path>/export/clickhouse/user_files/</user_files_path><!-- Directory in <clickhouse-path> containing schema files for various input formats. The directory will be created if it doesn't exist. --> <format_schema_path>/var/lib/clickhouse/format_schemas/</format_schema_path> --> #包含输入格式文件（例如CapnProto格式的方案）的目录路径修改： <format_schema_path>/export/clickhouse/format_schemas/</format_schema_path><!-- Cache path for custom (created from SQL) cached disks --> <custom_cached_disks_base_directory>/var/lib/clickhouse/caches/</custom_cached_disks_base_directory> --> 自定义（从 SQL 创建）缓存磁盘的缓存路径修改： <custom_cached_disks_base_directory>/export/clickhouse/caches/</custom_cached_disks_base_directory><local_directory> <!-- Path to folder where users created by SQL commands are stored. --> <path>/var/lib/clickhouse/access/</path> --> 存储由 SQL 命令创建的用户的文件夹路径修改: <path>/export/clickhouse/access/</path> </local_directory>