clickhouse部署

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

8123
9000
::

4096
3
100

sudo vi users.xml

   ::/0

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

        

        

        
                            3eba49e429e2a53b48b4f9b1914a30c55d0ef4616d629ec6823a900bf2a0e534
                
                        ::/0
                 
                 default
                 default
       

8.3登录

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