Ubuntu安装ClickHouse

• 1）准备工作

更新、安装工具，更新apt源

apt update
apt install -y apt-transport-https ca-certificates dirmngr
apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754
echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee     /etc/apt/sources.list.d/clickhouse.list
apt update

• 2）部署ClickHouse

apt install -y clickhouse-server clickhouse-client
systemctl status clickhouse-server

• 3）修改配置

cd /etc/clickhouse-server/
users.xml
config.xml
metrika.xml
chown clickhouse:clickhouse *.xml

• 4）开放防火墙

ufw allow 8123,9000,9004,9005,9009/tcp

• 5）启动SQL方式认证

修改users.xml，在default用户下添加以下2行

            <s