clickhouse 部署
·
一.单机版
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4 # optional
echo "deb http://repo.yandex.ru/clickhouse/deb/stable/ main/" | sudo tee /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update
sudo apt-get install -y clickhouse-server clickhouse-client
sudo service clickhouse-server start
clickhouse-client
二.集群版
1.按照单机版的模式分别在每台机器上安装
2.修改配置文件
/etc/metrika.xml
<yandex>
<clickhouse_remote_servers>
<perftest_3shards_1replicas>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>isec-hdp01</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>isec-hdp02</host>
<port>9000</port>
</replica>
</shard>
<shard>
<internal_replication>true</internal_replication>
<replica>
<host>isec-hdp03</host>
<port>9000</port>
</replica>
</shard>
</perftest_3shards_1replicas>
</clickhouse_remote_servers>
<zookeeper-servers>
<node index="1">
<host>192.168.121.41</host>
<port>2181</port>
</node>
<node index="2">
<host>192.168.121.42</host>
<port>2181</port>
</node>
<node index="3">
<host>192.168.121.43</host>
<port>2181</port>
</node>
</zookeeper-servers>
<macros>
<replica>192.168.121.41</replica>
</macros>
/etc/clickhouse-server/config.xml 70行左右
<listen_host>::1</listen_host>
<listen_host>isec-hdp01</listen_host>
/etc/clickhouse-server/users.xml 最大查询内存
<max_memory_usage>50000000000</max_memory_usage>
3.启动
service clickhouse-server stop
service clickhouse-server start
clickhouse-client --host 192.168.121.41 --port 9000 --multiline
更多推荐


所有评论(0)