一、Clickhouse 的装置
1、增加 yum 源
yum-config-manager --add-repo http://repo.red-soft.biz/repos/clickhouse/repo/clickhouse-el6.repo
2、装置
yum install clickhouse-server clickhouse-client clickhouse-server-common clickhouse-compressor
3、启动服务
/etc/init.d/clickhouse-server start
4、登录测试
[root@db_server_yayun_01 ~]# clickhouse-client
ClickHouse client version 20.5.2.7 (official build).
Connecting to 127.0.0.1:9000 as user default.
Connected to ClickHouse server version 20.5.2 revision 54435.
VM_0_15_centos :)
VM_0_15_centos :)
VM_0_15_centos :)
VM_0_15_centos :)
二、Clickhouse 近程登录
1、批改配置文件
[root@db_server_yayun_01 ~]vi /etc/clickhouse-server/config.xml
找到 <listent_host>::</listen_host> 去掉正文
三、客户端连贯(DBeaver)
1、主机:Clickhouse 近程登录服务器的 IP
2、用户名、明码:默认 default,明码为空
3、Dbeaver 有社区版的,因为是客户端,操作起来会比 tabix 更不便、好用一些