建网站前期设计用那软件,网站备案安全承诺书,wordpress 扩展数据库,张家港网站建设目录
一、准备工作
1、确定防火墙处于关闭状态
2、CentOS 取消打开文件数限制
3、安装依赖
4、CentOS取消SELINUX
二、单机安装
2.1、下载安装
2.2、安装这4个rpm包
2.3、修改配置文件
2.4、启动服务
2.5、关闭开机自启
2.6、使用Client连接server 一、准备工作
1…目录
一、准备工作
1、确定防火墙处于关闭状态
2、CentOS 取消打开文件数限制
3、安装依赖
4、CentOS取消SELINUX
二、单机安装
2.1、下载安装
2.2、安装这4个rpm包
2.3、修改配置文件
2.4、启动服务
2.5、关闭开机自启
2.6、使用Client连接server 一、准备工作
1、确定防火墙处于关闭状态
[roothallo102 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemonLoaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)Active: inactive (dead)Docs: man:firewalld(1)
[roothallo102 ~]#
2、CentOS 取消打开文件数限制
在 /etc/security/limits.conf 文件的末尾加入以下内容
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
第一列是限制的用户和用户组soft软限制hard硬限制nofile打开文件数nproc用户进程数
在/etc/security/limits.d/20-nproc.conf文件的末尾加入以下内容
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
退出当前用户重启登录ulimit -a查看打开文件数和用户进程数是否更改 [roothallo102 ~]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 11687 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimitedopen files (-n) 65536 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimitedmax user processes (-u) 131072 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [roothallo102 ~]# 3、安装依赖 [roothallo102 ~]# yum install -y libtool [roothallo102 ~]# yum install -y *unixODBC* 4、CentOS取消SELINUX [roothallo102 ~]# vim /etc/selinux/config SELINUXdisabled 修改完重启服务器 二、单机安装
官网https://clickhouse.tech/
下载地址https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/
2.1、下载安装
需要以下四个rpm包 clickhouse-client-21.7.3.14-2.noarch.rpm clickhouse-common-static-21.7.3.14-2.x86_64.rpm clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm clickhouse-server-21.7.3.14-2.noarch.rpm 2.2、安装这4个rpm包
[roothallo102 clickhouse]# rpm -ivh *.rpm
[roothallo102 clickhouse]# ll
总用量 938164
-rw-r--r-- 1 root root 78074 11月 16 21:40 clickhouse-client-21.7.3.14-2.noarch.rpm
-rw-r--r-- 1 root root 174283244 11月 16 21:40 clickhouse-common-static-21.7.3.14-2.x86_64.rpm
-rw-r--r-- 1 root root 786208040 11月 16 21:40 clickhouse-common-static-dbg-21.7.3.14-2.x86_64.rpm
-rw-r--r-- 1 root root 101969 11月 16 21:40 clickhouse-server-21.7.3.14-2.noarch.rpm
[roothallo102 clickhouse]# rpm -ivh *.rpm
2.3、修改配置文件
[roothallo102 clickhouse]# cd /etc/clickhouse-server/
[roothallo102 clickhouse-server]# chmod 777 config.xml
[roothallo102 clickhouse-server]# ls
config.d config.xml users.d users.xml
[roothallo102 clickhouse-server]# vim config.xml
把listen_host0.0.0.0/listen_host的注释打开这样的话才能让ClickHouse被除本机之外的服务器访问
这个配置文件中ClickHouse一些默认路径配置
数据文件路径path/var/lib/clickhouse//path日志文件路径log/var/log/clickhouse-server/clickhouse-server.log/log
2.4、启动服务
[roothallo102 clickhouse-server]# systemctl start clickhouse-server
或者
[roothallo102 clickhouse-server]# clickhouse start
[roothallo102 clickhouse-server]# systemctl status clickhouse-server
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)Active: active (running) since 六 2024-11-16 21:59:16 CST; 3s agoMain PID: 2343 (clckhouse-watch)Tasks: 157CGroup: /system.slice/clickhouse-server.service├─2343 clickhouse-watchdog --config/etc/clickhouse-server/config.xml --pid-file/run/clickhouse-server/clickhouse-server.pid└─2346 /usr/bin/clickhouse-server --config/etc/clickhouse-server/config.xml --pid-file/run/clickhouse-server/clickhouse-server.pid11月 16 21:59:16 hallo102 systemd[1]: Started ClickHouse Server (analytic DBMS for big data).
11月 16 21:59:16 hallo102 systemd[1]: Starting ClickHouse Server (analytic DBMS for big data)...
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file /etc/clickhouse-server/config.xml.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Logging trace to /var/log/clickhouse-server/clickhouse-server.log
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file /etc/clickhouse-server/config.xml.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Saved preprocessed configuration to /var/lib/clickhouse/preprocessed_configs/config.xml.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Processing configuration file /etc/clickhouse-server/users.xml.
11月 16 21:59:17 hallo102 clickhouse-server[2343]: Saved preprocessed configuration to /var/lib/clickhouse/preprocessed_configs/users.xml.
[roothallo102 clickhouse-server]#
2.5、关闭开机自启 [roothallo102 clickhouse-server]# systemctl disable clickhouse-server Removed symlink /etc/systemd/system/multi-user.target.wants/clickhouse-server.service. [roothallo102 clickhouse-server]# 2.6、使用Client连接server
[roothallo102 clickhouse-server]# clickhouse-client -m
ClickHouse client version 21.7.3.14 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.7.3 revision 54449.hallo102 :) show databases;SHOW DATABASESQuery id: 29827428-607c-42d3-84f7-24333732908c┌─name────┐
│ default │
│ system │
└─────────┘2 rows in set. Elapsed: 0.006 sec.hallo102 :)
