Clickhouse安装步骤

南潇如梦

已于 2022-03-18 10:06:41 修改

阅读量4.3k

点赞数

分类专栏：运维文章标签： linux 运维服务器

于 2022-03-09 17:06:54 首次发布

本文链接：https://blog.csdn.net/weixin_45682261/article/details/123381739

版权

首先要自己把四个安装包上传到本地

链接：https://pan.baidu.com/s/1h1d38zU7YrAgDQdlpMMMHw
提取码：0aij
--来自百度网盘超级会员V1的分享

测试一下系统能不能装

grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"

安装（就是先进入那四个文件所在的文件夹目录，再执行下面的代码）

rpm -ivh ./clickhouse-*.rpm

安装成功之后会显示两个路径

我们就需要进去/etc/clickhouse-server查看两个配置文件

ll /etc/clickhourse-server

然后可以修改config.xml和users.xml的内容

修改config.xml

<?xml version="1.0"?>

<yandex>
    <logger>
        
        <level>trace</level>
        <log>/var/log/clickhouse-server/clickhouse-server.log</log>
        <errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
        <size>1000M</size>
        <count>10</count>
         
    </logger>
     
    <http_port>8123</http_port>
    <tcp_port>9999</tcp_port>
    <mysql_port>9004</mysql_port>
    
    

    
    <openSSL>
        <server> 
            
            <certificateFile>/etc/clickhouse-server/server.crt</certificateFile>
            <privateKeyFile>/etc/clickhouse-server/server.key</privateKeyFile>
            
            <dhParamsFile>/etc/clickhouse-server/dhparam.pem</dhParamsFile>
            <verificationMode>none</verificationMode>
            <loadDefaultCAFile>true</loadDefaultCAFile>
            <cacheSessions>true</cacheSessions>
            <disableProtocols>sslv2,sslv3</disableProtocols>
            <preferServerCiphers>true</preferServerCiphers>
        </server>

        <client> 
            <loadDefaultCAFile>true</loadDefaultCAFile>
            <cacheSessions>true</cacheSessions>
            <disableProtocols>sslv2,sslv3</disableProtocols>
            <preferServerCiphers>true</preferServerCiphers>
            
            <invalidCertificateHandler>
                
                <name>RejectCertificateHandler</name>
            </invalidCertificateHandler>
        </client>
    </openSSL>

    
    

    
    <interserver_http_port>9009</interserver_http_port>

    
    

    
    
    
    

    

    <listen_host>::1</listen_host>
    <listen_host>0.0.0.0</listen_host>

    
    

    
    

    

    <max_connections>4096</max_connections>
    <keep_alive_timeout>3</keep_alive_timeout>

    
    <max_concurrent_queries>100</max_concurrent_queries>

    
    

    <!-- Size of cache of uncompressed blocks of data, used in tables of MergeTree family.
         In bytes. Cache is single for server. Memory is allocated only on demand.
         Cache is used when 'use_uncompressed_cache' user setting turned on (off by default).
         Uncompressed cache is advantageous

最低0.47元/天解锁文章

南潇如梦

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
Clickhouse安装步骤

首先要自己把四个安装包上传到本地链接：https://pan.baidu.com/s/1h1d38zU7YrAgDQdlpMMMHw提取码：0aij--来自百度网盘超级会员V1的分享测试一下系统能不能装grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"安装（就是先进入那四个文件所在的文件夹目录，再执行下面的代码）rpm -ivh ./cli
复制链接

扫一扫