|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文件最后一行：</yandex>参数之上添加参数

<storage_configuration>
    <disks>
        <disk_hot1>
            <path>/var/lib/clickhouse/chbase/hotdata1/</path>
        </disk_hot1>
        <disk_hot2>
            <path>/var/lib/clickhouse/chbase/hotdata2/</path>
        </disk_hot2>
        <disk_cold>
            <path>/var/lib/clickhouse/chbase/colddata/</path>
        </disk_cold>
    </disks>
    <policies>
        <default_jbod>
            <volumes>
                <jbod>
                    <disk>disk_hot1</disk>:
                    <disk>disk_hot2</disk>
                </jbod>
            </volumes>
            <move_factor>0.2</move_factor>
        </default_jbod>
        <moving_from_hot_to_cold>
            <volumes>
                <hot>
                    <disk>disk_hot1</disk>
                    <max_data_part_size_bytes>1073741824</max_data_part_size_bytes>
                </hot>
                <cold>
                    <disk>disk_cold</disk>
                </cold>
            </volumes>
            <move_factor>0.2</move_factor>
        </moving_from_hot_to_cold>
        <moving_from_hot_to_cold_new>
            <volumes>
                <hot>
                    <disk>disk_hot2</disk>
                    <max_data_part_size_bytes>1048576</max_data_part_size_bytes>
                </hot>
                <cold>
                    <disk>disk_cold</disk>
                </cold>
            </volumes>
            <move_factor>0.2</move_factor>
        </moving_from_hot_to_cold_new>
    </policies>
</storage_configuration>

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

~~~     # 发送到其它所有主机
[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 
 
    <!-- 存放路径；没有优化之前的clickhouse之前的存放地址 -->
    <!-- Path to data directory, with trailing slash. -->
    <path>/var/lib/clickhouse/</path>
 
    <!-- Path to temporary data for processing hard queries. -->
    <tmp_path>/var/lib/clickhouse/tmp/</tmp_path>

---

 

 

 

 

 

 

 

 

 

---

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

---