修改clickhouse的默认存储路径_clickhouse日志路径

修改clickhouse的默认存储路径 /var/lib/clickhouse

1、创建存储目录
mkdir -p /home/service/clickhouse
1
2

2、停止服务
/etc/init.d/clickhouse-server stop
1
2

3、修改配置文件
cd /etc/clickhouse-server
sed -i 's#/var/lib/clickhouse#/home/service/clickhouse#g' config.xml
cat config.xml | grep /home/service
1
2
3
4

4、移动位置
mv /var/lib/clickhouse/* /home/service/clickhouse
1
2

5.查看metadata目录下原有全部库的软链接
说明：这些是原来库自动创建的软链接，以default为例子：default实际指向还是/var/lib/clickhouse/.../.../，需要重置为新位置的目录。
由于步骤3导致/var/lib/clickhouse/.../.../的目录不存在，ll查看的时候有问题的软链接会呈现闪烁状态。
1
2
3

6.重置metadata目录库的软链接指向
[root@master metadata]# unlink system
[root@master metadata]# unlink default
[root@master metadata]# ln -s /home/service/clickhouse/store/c42/c4289a7d-30ef-467a-9b69-fa1f0001d3eb/ default
[root@master metadata]# ln -s /home/service/clickhouse/store/3c7/3c7de3e1-0660-40b5-a416-fc082fe877bd/ system
[root@master metadata]# chown -h clickhouse:clickhouse system  default
[root@master metadata]#

1
2
3
4
5
6
7
8

注意，chown一定要加上-h参数，不然更改的权限目标实际上是软链接对应的真正的位置

7.查看data目录下全部库的全部表的原有软链接,重置为新位置的目录(以system为例)

[root@master system]# unlink asynchronous_metric_log 
[root@master system]# unlink metric_log 
[root@master system]# unlink part_log 
[root@master system]# unlink query_log 
[root@master system]# unlink query_thread_log 
[root@master system]# unlink session_log 
[root@master system]# unlink trace_log 
[root@master system]#  ln -s /home/service/clickhouse/store/9f9/9f9305da-c681-40ac-8f15-2e51ea432dc6/ asynchronous_metric_log
[root@master system]# ln -s /home/service/clickhouse/store/f14/f147845b-3b2e-458c-b187-fb4aaf12a35b/ metric_log
[root@master system]# ln -s /home/service/clickhouse/store/654/654261a3-207f-4c6d-ac9a-e9b462754efc/ part_log
[root@master system]# ln -s /home/service/clickhouse/store/fe4/fe466008-f926-4e1c-ac67-89bb54b7aebf/ query_log
[root@master system]# ln -s /home/service/clickhouse/store/90d/90d7140a-687f-46ee-ae45-66b18d982f33/ query_thread_log
[root@master system]# ln -s /home/service/clickhouse/store/036/036ec99d-346f-449b-b612-1a909f0613b4/ session_log
[root@master system]# ln -s /home/service/clickhouse/store/8b5/8b5616cb-c081-4e0f-baee-e940a437fdaa/ trace_log
[root@master system]# chown -h clickhouse:clickhouse asynchronous_metric_log metric_log part_log query_thread_log session_log trace_log
[root@master system]#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

8.启动数据库
  /etc/init.d/clickhouse-server start
1
2

9.查看数据字典
# clickhouse-client --host 127.0.0.1 --user clickhouse_operator --password clickhouse_operator_password
select * from system.databases;
1
2
3

10、修改日志文件位置
mkdir -p /home/service/clickhouse/clickhouse-server
chown -h clickhouse:clickhouse clickhouse-server/
11、修改配置文件路径
sed -i 's#/var/log/clickhouse-server#/home/service/clickhouse/clickhouse-server#g' config.xml
重启服务，查看服务
1
2
3
4
5
6