软件准备
到https://packagecloud.io/Altinity/clickhouse下载适合自己服务器版本的RPM包
clickhouse-client-18.12.13-1.el6.x86_64.rpm
clickhouse-common-static-18.12.13-1.el6.x86_64.rpm
clickhouse-compressor-1.1.54336-3.el6.x86_64.rpm
clickhouse-debuginfo-18.12.13-1.el6.x86_64.rpm
clickhouse-server-18.12.13-1.el6.x86_64.rpm
clickhouse-server-common-18.12.13-1.el6.x86_64.rpm
clickhouse-test-18.12.13-1.el6.x86_64.rpm
yum -y install openssl unixODBC libicu
rpm -ivh clickhouse-server-common-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-server-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-common-static-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-compressor-1.1.54336-3.el6.x86_64.rpm
rpm -ivh clickhouse-debuginfo-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-client-18.12.13-1.el6.x86_64.rpm
rpm -ivh clickhouse-test-18.12.13-1.el6.x86_64.rpm
配置/etc/clickhouse-server/config.xml
配置:
<log>/var/log/clickhouse-server/clickhouse-server.log</log>
<errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
<path>/data/clickhouse/</path>
<tmp_path>/data/clickhouse/tmp/</tmp_path>
<user_files_path>/data/clickhouse/user_files/</user_files_path>
然后把各个目录都赋权给clickhouse
chown -R clickhouse:clickhouse 目录
启动
/etc/init.d/clickhouse-server start
[root@test clickhouse-server]# clickhouse-client
ClickHouse client version 18.12.13.
Connecting to localhost:9000.
Connected to ClickHouse server version 18.12.13 revision 54407.
test :) show databases;
SHOW DATABASES
┌─name────┐
│ default │
│ system │
└─────────┘
2 rows in set. Elapsed: 0.002 sec.
test :) use system;
USE system
Ok.
0 rows in set. Elapsed: 0.001 sec.
test :) show tables;
SHOW TABLES
┌─name───────────────────────────┐
│ aggregate_function_combinators │
│ asynchronous_metrics │
│ build_options │
│ clusters │
│ collations │
│ columns │
│ data_type_families │
│ databases │
│ dictionaries │
│ events │
│ formats │
│ functions │
│ graphite_retentions │
│ macros │
│ merge_tree_settings │
│ merges │
│ metrics │
│ models │
│ mutations │
│ numbers │
│ numbers_mt │
│ one │
│ parts │
│ parts_columns │
│ processes │
│ query_thread_log │
│ replicas │
│ replication_queue │
│ settings │
│ table_engines │
│ table_functions │
│ tables │
└────────────────────────────────┘
32 rows in set. Elapsed: 0.002 sec.
test :) desc tables;
DESCRIBE TABLE tables
┌─name───────────────────────┬─type──────────┬─default_type─┬─default_expression─┐
│ database │ String │ │ │
│ name │ String │ │ │
│ engine │ String │ │ │
│ is_temporary │ UInt8 │ │ │
│ data_path │ String │ │ │
│ metadata_path │ String │ │ │
│ metadata_modification_time │ DateTime │ │ │
│ dependencies_database │ Array(String) │ │ │
│ dependencies_table │ Array(String) │ │ │
│ create_table_query │ String │ │ │
│ engine_full │ String │ │ │
└────────────────────────────┴───────────────┴──────────────┴────────────────────┘
11 rows in set. Elapsed: 0.001 sec.
test :)
单点基本搭建完成