Clickhouse绗旇锛堜簩锛?闆嗙兢鎼缓

fangxinyzj.com 2025-05-30 10:52:06

0.闆嗙兢瑙勫垝

鎿嶄綔绯荤粺浣跨敤ubuntu2204server锛?C8G100G銆?/p>

鑺傜偣鍒嗙墖閮ㄧ讲
192.168.50.5鍒嗙墖1鍓湰1clickhouse-server/clickhouse-client/keeper
192.168.50.6鍒嗙墖1鍓湰2clickhouse-server/clickhouse-client/keeper
192.168.60.7鍒嗙墖2鍓湰1clickhouse-server/clickhouse-client/keeper
192.168.50.25鍒嗙墖2鍓湰2clickhouse-server/clickhouse-client

鍥涘彴涓绘満閮戒綔涓烘暟鎹垎鐗囷紝姣忎釜鏁版嵁鍒嗙墖鏈変袱涓壇鏈€俴eeper 閮ㄧ讲鍒颁笁涓妭鐐逛笂锛屽鏁拌妭鐐圭敤浜庡疄鐜?ClickHouse Keeper 涓姹傜殑绁ㄩ€夋暟銆?/p>

1.鍑嗗鑺傜偣

  • 鍑嗗鎿嶄綔绯荤粺 ubuntu 鎴朿entos锛屽敖閲忓拰浣犵敓浜х幆澧冪殑鎿嶄綔绯荤粺鐗堟湰涓€鑷?/li>
  • 缁熶竴鏃跺尯锛岄厤缃甆TP锛堟祴璇曠幆澧冨彲浠ョ畝鐣ワ紝鍙鑺傜偣鐨勬椂鍖虹粺涓€鍗冲彲锛?/li>
  • 閰嶇疆ssh鍏嶅瘑鐧诲綍锛堝彲閫夛級
1.1 浣跨敤鎸囧畾鐨勭増鏈?/h5>

鏍规嵁瀹為檯鎯呭喌瀹夎鎸囧畾鐗堟湰鐨刢lickhouse.浣跨敤鍛戒护curl https://clickhouse.com/ | sh瀹夎鐨刢lickhouse榛樿鏄渶鏂扮増鏈殑锛屼絾鏄湁鏃舵垜浠渶瑕佸畨瑁呮寚瀹氱殑绋冲畾鐗堟湰锛岀櫥褰?https://packages.clickhouse.com/ 鍙互鎵惧埌clickhouse涓轰笉鍚宭inux鍙戣鐗堟湰鍑嗗鐨勫悇涓増鏈殑.

1.2 浣跨敤绗笁鏂圭増鏈?/h5>

涔熷彲浠ヤ娇鐢ˋltinity鐨勭ǔ瀹氱増鏈?https://builds.altinity.cloud/

sudo apt update
sudo apt install -y curl gnupg2 apt-transport-https ca-certificates dialog
sudo sh -c 'mkdir -p /usr/share/keyrings && curl -s https://builds.altinity.cloud/apt-repo/pubkey.gpg | gpg --dearmor > /usr/share/keyrings/altinity-archive-keyring.gpg'
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/altinity-archive-keyring.gpg] https://builds.altinity.cloud/apt-repo stable main" > /etc/apt/sources.list.d/altinity.list'
sudo apt update
sudo apt install -y clickhouse-server clickhouse-client

v24.4.1.2088-stable

馃枈 涓婇潰涓ょ瀹夎鏂瑰紡浠婚€変竴绉嶏紝鍦ㄦ瘡鍙版湇鍔″櫒涓婂畨瑁卌lickhouse銆?/p>

瀹夎瀹屾垚鍚庝娇鐢ㄤ笅闈㈢殑鍛戒护鍚姩clickhouse.

sudo -u alfiy clickhouse server

涔熷彲浠ヤ互鏈嶅姟鐨勬柟寮忓惎鍔?/p> 

sudo service clickhouse-server start

2.閰嶇疆闆嗙兢

娉ㄦ剰锛孋lickHouse 瑕佹眰姣忎釜鍒嗙墖鐨勬瘡涓壇鏈繀椤婚厤缃湪鍗曠嫭鐨勫疄渚嬩笂锛屼篃灏辨槸璇村湪鏁翠釜闆嗙兢鑼冨洿鍐咃紝涓€鍏辨湁澶氬皯涓壇鏈紝灏遍渶瑕佸垱寤哄灏戜釜 ClickHouse 瀹炰緥銆傛渶浣冲疄璺垫槸3鍒嗙墖2鍓湰6瀹炰緥銆?/p>

2.0 淇敼hosts

濡傛灉鍦╟lickhouse鐨勯厤缃腑锛屼娇鐢ㄤ簡鍩熷悕閰嶇疆鑰屼笉鏄疘P鍦板潃锛岄櫎闈炰綘鐨勫煙鍚嶇湡瀹炲瓨鍦紝鍚﹀垯闇€瑕佷慨鏀规湰鏈虹殑hosts鏂囦欢銆傜敱浜庢垜鍚屾椂娴嬭瘯浜嗕娇鐢ㄥ煙鍚嶅拰IP涓ょ閰嶇疆鏂瑰紡锛屾墍浠ュ湪鏈緥涓渶瑕佸悓鏃朵慨鏀瑰洓涓妭鐐圭殑hosts鏂囦欢銆?/p>

鎵撳紑/etc/hosts鏂囦欢锛屾坊鍔犱互涓嬪唴瀹广€?/p> 

192.168.50.5 node1
192.168.50.6 node2
192.168.50.7 node3
192.168.50.25 node4

淇敼瀹屾垚鍚庯紝鍙互浣跨敤ping node1鍛戒护鏌ョ湅hosts鏄惁鐢熸晥锛屽鏋滅敓鏁堝氨鑳藉ping鐨勯€氥€?/p>

2.1淇敼node1鐨勯厤缃?/h5>

鍦╪ode2鐨?code>/etc/clickhouse-server/config.xml鏂囦欢鐨勬爣绛句腑娣诲姞浠ヤ笅鍐呭銆?/p> 

    
    <listen_host>0.0.0.0listen_host>

    
    <zookeeper>
        <node>
            <host>192.168.50.5host>
            <port>9181port>
        node>
        <node>
            <host>192.168.50.6host>
            <port>9181port>
        node>
        <node>
            <host>192.168.60.7host>
            <port>9181port>
        node>
    zookeeper>

    <remote_servers>
        
        <cluster_2S_2R>
            <shard>
                <replica>
                    <host>192.168.50.5host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>192.168.50.6host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
            <shard>
                <replica>
                    <host>192.168.50.7host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>192.168.50.25host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
        cluster_2S_2R>
    remote_servers>
    <macros>
        
        <shard>01shard>
        <replica>01replica>
    macros>

馃枈 1 瀵瑰簲node1 2瀵瑰簲node23瀵瑰簲node3

2.2 淇敼node2鐨勯厤缃?/h5>

鍦╪ode2鐨?code>/etc/clickhouse-server/config.xml鏂囦欢鐨勬爣绛句腑娣诲姞浠ヤ笅鍐呭銆?/p> 

    
    <listen_host>0.0.0.0listen_host>

    
    <keeper_server>
        <tcp_port>9181tcp_port>
        <server_id>2server_id>
        <log_storage_path>/var/lib/clickhouse/coordination/loglog_storage_path>
        <snapshot_storage_path>/var/lib/clickhouse/coordination/snapshotssnapshot_storage_path>

        <coordination_settings>
            <operation_timeout_ms>10000operation_timeout_ms>
            <session_timeout_ms>30000session_timeout_ms>
            <raft_logs_level>warningraft_logs_level>
        coordination_settings>

        
    <zookeeper>
        <node>
            <host>node1host>
            <port>9181port>
        node>
        <node>
            <host>node2host>
            <port>9181port>
        node>
        <node>
            <host>node3host>
            <port>9181port>
        node>
    zookeeper>

    <remote_servers>
        <cluster_2S_2R>
            <shard>
                <replica>
                    <host>node1host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>node2host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
            <shard>
                <replica>
                    <host>node3host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>node4host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
        cluster_2S_2R>
    remote_servers>
    <macros>
        <shard>01shard>
        <replica>02replica>
    macros>
2.3 淇敼node3鐨勯厤缃?/h5>

鍦╪ode3鐨?code>/etc/clickhouse-server/config.xml鏂囦欢鐨勬爣绛句腑娣诲姞浠ヤ笅鍐呭銆?/p> 

    
    <listen_host>0.0.0.0listen_host>
    
    <keeper_server>
        <tcp_port>9181tcp_port>
        <server_id>2server_id>
        <log_storage_path>/var/lib/clickhouse/coordination/loglog_storage_path>
        <snapshot_storage_path>/var/lib/clickhouse/coordination/snapshotssnapshot_storage_path>

        <coordination_settings>
            <operation_timeout_ms>10000operation_timeout_ms>
            <session_timeout_ms>30000session_timeout_ms>
            <raft_logs_level>warningraft_logs_level>
        coordination_settings>

        
    <zookeeper>
        <node>
            <host>node1host>
            <port>9181port>
        node>
        <node>
            <host>node2host>
            <port>9181port>
        node>
        <node>
            <host>node3host>
            <port>9181port>
        node>
    zookeeper>

    <remote_servers>
        <cluster_2S_2R>
            <shard>
                <replica>
                    <host>node1host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>node2host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
            <shard>
                <replica>
                    <host>node3host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
                <replica>
                    <host>node4host>
                    <port>9000port>
                    <user>defaultuser>
                    <password>your_passwordpassword>
                replica>
            shard>
        cluster_2S_2R>
    remote_servers>
    <macros>
        <shard>02shard>
        <replica>01replica>
    macros>

浠庝互涓婇厤缃枃浠朵腑鍙互鐪嬪嚭锛宯ode1,node2,node3鐨勫尯鍒彧鏄?code>鏍囩涓殑鍖哄埆銆?/p>

2.4 淇敼node4鐨勯厤缃?/h5>

鍦╪ode4鐨?code>/etc/clickhouse-server/config.xml鏂囦欢鐨勬爣绛句腑娣诲姞浠ヤ笅鍐呭銆?/p> 


<listen_host>0.0.0.0listen_host>


<zookeeper>
    <node>
        <host>node1host>
        <port>9181port>
    node>
    <node>
        <host>node2host>
        <port>9181port>
    node>
    <node>
        <host>node3host>
        <port>9181port>
    node>
zookeeper>

<remote_servers>
    <cluster_2S_2R>
        <shard>
            <replica>
                <host>node1host>
                <port>9000port>
                <user>defaultuser>
                <password>your_passwordpassword>
            replica>
            <replica>
                <host>node2host>
                <port>9000port>
                <user>defaultuser>
                <password>your_passwordpassword>
            replica>
        shard>
        <shard>
            <replica>
                <host>node3host>
                <port>9000port>
                <user>defaultuser>
                <password>your_passwordpassword>
            replica>
            <replica>
                <host>node4host>
                <port>9000port>
                <user>defaultuser>
                <password>your_passwordpassword>
            replica>
        shard>
    cluster_2S_2R>
remote_servers>
<macros>
    <shard>02shard>
    <replica>02replica>
macros>

3.鏌ョ湅闆嗙兢

闆嗙兢鍚姩鍚庯紝鍙互浣跨敤clickhouse client鐧诲綍瀹㈡埛绔紝浣跨敤浠ヤ笅鍛戒护鏌ョ湅闆嗙兢鐨勭浉鍏充俊鎭€?/p> 

SHOW CLUSTERS;

SELECT *
FROM system.zookeeper
WHERE path IN ('/', '/clickhouse');

杩欎釜鏌ヨ鏃堕棿鏈夌偣闀?/p> 

SELECT
    cluster,
    shard_num,
    replica_num,
    host_name,
    is_local,
    user,
    database_shard_name,
    database_replica_name
FROM system.clusters;

Clickhouse绗旇锛堜簩锛?闆嗙兢鎼缓

Clickhouse绗旇锛堜簩锛?闆嗙兢鎼缓

上一篇：i5 8500b（cpui58500b360m的主板，能不能换个i99900的cpu）
下一篇：Linux版Black Basta勒索病毒针对VMware ESXi服务器
Copyright © 2007-2024 翔大跳伞俱乐部 版权所有 豫ICP备11006092号-1 XML