clickhouse部署

1.下载

clickhouse-client-20.8.3.18-1.el7.x86_64.rpm
clickhouse-common-static-20.8.3.18-1.el7.x86_64.rpm
clickhouse-odbc-1.1.10-1.el7.x86_64.rpm
clickhouse-server-20.8.3.18-1.el7.x86_64.rpm
clickhouse-server-common-20.8.3.18-1.el7.x86_64.rpm

clickhouse-test-20.8.3.18-1.el7.x86_64.rpm

2. 部署依赖包

yum install libicu unixODBC

3.test问题

clickhouse-test-20.8.3.18-1.el7.x86_64.rpm

需要更多依赖，将其移出

4.rpm部署

sudo rpm -ivh *.rpm

5.配置

cd /etc/clickhouse-server/

sudo vi config.xml

<http_port>8123</http_port>
<tcp_port>9000</tcp_port>
<listen_host>::</listen_host>

<max_connections>4096</max_connections>
<keep_alive_timeout>3</keep_alive_timeout>
<max_concurrent_queries>100</max_concurrent_queries>

sudo vi users.xml

<networks incl="networks" replace="replace">
   <ip>::/0</ip>
</networks>

6.启停服务

sudo service clickhouse-server start

sudo service clickhouse-server stop

sudo service clickhouse-server status

7.客户端访问

clickhouse-client --port 9000 --host 10.88.1.231 --multiline

8.设置用户名和密码

8.1

# PASSWORD='syan11318!'; echo "$PASSWORD";echo -n "$PASSWORD" | sha256sum | tr -d '-'
syan11318!
3eba49e429e2a53b48b4f9b1914a30c55d0ef4616d629ec6823a900bf2a0e534

8.2 修改users.xml

<users>

        <default>

        </default>

        <camera>
                            <password_sha256_hex>3eba49e429e2a53b48b4f9b1914a30c55d0ef4616d629ec6823a900bf2a0e534</password_sha256_hex>
                <networks incl="networks" replace="replace">
                        <ip>::/0</ip>
                 </networks>
                 <profile>default</profile>
                 <quota>default</quota>
        </camera>

</users>

8.3登录

clickhouse-client --port 9000 --host 10.88.1.231 -u camera --password syan11318! --multiline