|NO.Z.00002|——————————|Deployment|——|Hadoop&OLAP数据库管理系统.v02|——|ClickHouse.v02|表引擎|MergeTree存储策略|默认策略

一、MergeTree存储策略配置

### --- 整体配置：配置mergetree存储配置方案
~~~     所有主机创建mergetree存储目录

[root@hadoop01 ~]# mkdir -p /var/lib/clickhouse/chbase/colddata
[root@hadoop01 ~]# mkdir -p /var/lib/clickhouse/chbase/hotdata1
[root@hadoop01 ~]# mkdir -p /var/lib/clickhouse/chbase/hotdata2
 
[root@hadoop01 ~]# cd /var/lib/clickhouse/
[root@hadoop01 clickhouse]# chown -R clickhouse:clickhouse chbase/

~~~     # MergeTree存储配置

[root@hadoop01 ~]# vim /etc/clickhouse-server/config.xml 

~~~ 在config.xml文件最后一行：参数之上添加参数


    
        
            /var/lib/clickhouse/chbase/hotdata1/
        
        
            /var/lib/clickhouse/chbase/hotdata2/
        
        
            /var/lib/clickhouse/chbase/colddata/
        
    
    
        
            
                
                    disk_hot1:
                    disk_hot2
                
            
            0.2
        
        
            
                
                    disk_hot1
                    1073741824
                
                
                    disk_cold
                
            
            0.2
        
        
            
                
                    disk_hot2
                    1048576
                
                
                    disk_cold
                
            
            0.2

### --- 发送到其它并重启服务

~~~     # 发送到其它所有主机
[root@hadoop01 ~]# rsync-script /etc/clickhouse-server/config.xml
~~~     # 所有节点重启服务
[root@hadoop01 ~]# systemctl restart clickhouse-server

一、默认策略

### --- 默认策略
~~~     # MergeTree默认策略
~~~     19.15之前,只能单路径存储，存储位置为在config.xml配置文件中指定
~~~     19.15之后，支持多路径存储策略的自定义存储策略，目前有三类策略：

[root@hadoop01 ~]# vim /etc/clickhouse-server/config.xml 
 
    
    
    /var/lib/clickhouse/
 
    
    /var/lib/clickhouse/tmp/

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart ——W.S.Landor

dov005-olap

|NO.Z.00002|——————————|Deployment|——|Hadoop&OLAP数据库管理系统.v02|——|ClickHouse.v02|表引擎|MergeTree存储策略|默认策略

相关

标签