部署数据库

设置软件源
sudo apt-get install -y apt-transport-https ca-certificates dirmngr GNUPGHOME=$(mktemp -d) sudo GNUPGHOME="$GNUPGHOME" gpg --no-default-keyring --keyring /usr/share/keyrings/clickhouse-keyring.gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 8919F6BD2B48D754 sudo rm -rf "$GNUPGHOME" sudo chmod +r /usr/share/keyrings/clickhouse-keyring.gpg echo "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg] https://packages.clickhouse.com/deb stable main" | sudo tee \ /etc/apt/sources.list.d/clickhouse.list sudo apt-get update
安装ClickHouse Server 和 Client
sudo apt-get install -y clickhouse-server clickhouse-client
从下载地址下载clickhouse-common-static_xxx_amd64.deb, clickhouse-server_xxx_amd64.deb, clickhouse-client_xxx_amd64.deb 按如下顺序安装:
1. sudo dpkg -i ./clickhouse-common-static_xxx_amd64.deb
2. sudo dpkg -i ./clickhouse-server_xxx_amd64.deb
3. sudo dpkg -i ./clickhouse-client_xxx_amd64.deb
设置数据库远程连接
编辑/etc/clickhouse-server/config.xml文件: 取消
<listen_host>::</listen_host> <listen_host>0.0.0.0</listen_host>
这两行的注释
启动ClickHouse数据库服务
sudo service clickhouse-server start clickhouse-client # 或者 clickhouse-client --password 如果设置了密码的话

配置数据库主从备份

更多关于ClickHouse配置请参考ClickHouse官方文档

Last modified: 27 October 2024