溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

PXC搭建問題有哪些

發布時間:2021-09-28 14:14:40 來源:億速云 閱讀:173 作者:柒染 欄目:MySQL數據庫

本篇文章給大家分享的是有關PXC搭建問題有哪些,小編覺得挺實用的,因此分享給大家學習,希望大家閱讀完這篇文章后可以有所收獲,話不多說,跟著小編一起來看看吧。

  1. 無法啟動第一個節點

    2017-11-18T15:53:00.732400Z 0 [Note] WSREP: gcomm: connecting to group 'zrz', peer '192.168.1.101:'
    2017-11-18T15:53:00.733049Z 0 [Note] WSREP: (8dec793b, 'tcp://0.0.0.0:4567') connection established to 8dec793b tcp://192.168.1.101:4567
    2017-11-18T15:53:00.733073Z 0 [Warning] WSREP: (8dec793b, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.101:4567' points to own listening address, blacklisting
    2017-11-18T15:53:03.733022Z 0 [Note] WSREP: (8dec793b, 'tcp://0.0.0.0:4567') connection to peer 8dec793b with addr tcp://192.168.1.101:4567 timed out, no messages seen in PT3S
    2017-11-18T15:53:03.733131Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
    2017-11-18T15:53:03.733151Z 0 [Note] WSREP: Current view of cluster as seen by this node
    view (view_id(NON_PRIM,8dec793b,1)
    memb {
            8dec793b,0
            }
    joined {
            }
    left {
            }
    partitioned {
            }
    )
    2017-11-18T15:53:04.233267Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50093S), skipping check
    2017-11-18T15:53:33.736202Z 0 [Note] WSREP: Current view of cluster as seen by this node
    view ((empty))
    2017-11-18T15:53:33.736368Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
             at gcomm/src/pc.cpp:connect():158
    2017-11-18T15:53:33.736383Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
    2017-11-18T15:53:33.736618Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1463: Failed to open channel 'zrz' at 'gcomm://192.168.1.101': -110 (Connection timed out)
    2017-11-18T15:53:33.736631Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
    2017-11-18T15:53:33.736636Z 0 [ERROR] WSREP: Provider/Node (gcomm://192.168.1.101) failed to establish connection with cluster (reason: 7)
    2017-11-18T15:53:33.736641Z 0 [ERROR] Aborting

    2017-11-18T15:53:33.736651Z 0 [Note] Giving 0 client threads a chance to die gracefully
    2017-11-18T15:53:33.736656Z 0 [Note] WSREP: Waiting for active wsrep applier to exit
    2017-11-18T15:53:33.736659Z 0 [Note] WSREP: Service disconnected.
    2017-11-18T15:53:33.736664Z 0 [Note] WSREP: Waiting to close threads......
    2017-11-18T15:53:38.736758Z 0 [Note] WSREP: Some threads may fail to exit.
    2017-11-18T15:53:38.736807Z 0 [Note] Binlog end
    2017-11-18T15:53:38.737048Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

    問題主要描述:錯誤日志提示無法成功加入節點

    原因:第一個節點啟動時需要指定自己為作為集群啟動

    解決辦法:加--wsrep-new-cluster參數啟動,官方指定的bootstrap-pxc參數并不生效

  2. 第二個節點無法加入

    2017-11-19T15:55:29.227793Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '192.168.1.103:4444/xtrabackup_sst//1' --socket '/data/mysql/3306/tmp/mysql3306.sock' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix ''  --binlog 'mysql-bin' --gtid 'df47a753-cd3d-11e7-85b5-66f48d655632:0': 32 (Broken pipe)
    2017-11-19T15:55:29.227868Z 0 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '192.168.1.103:4444/xtrabackup_sst//1' --socket '/data/mysql/3306/tmp/mysql3306.sock' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix ''  --binlog 'mysql-bin' --gtid 'df47a753-cd3d-11e7-85b5-66f48d655632:0'
    問題描述:無法成功傳輸SST

     在mysql/bin目錄下執行wsrep_sst_xtrabackup-v2 --role 'donor' --address '192.168.1.103:4444/xtrabackup_sst//1' --socket '/data/mysql/3306/tmp/mysql3306.sock' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix ''  --binlog 'mysql-bin' --gtid 'df47a753-cd3d-11e7-85b5-66f48d655632:0'

    提示:

       which: no socat in (/usr/sbin:/sbin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin:/usr/local/pxc/bin:/root/bin)      

    原因:缺少依賴組件socat

    解決辦法:yum -y install socat

  3. 第二個幾點無法加入

    2017-11-19T15:15:11.735984Z 2 [Note] WSREP: New cluster view: global state: 50970ac2-cc82-11e7-8b90-c716227b4ac7:0, view# 8: Primary, number of nodes: 2, my index: 0, protocol version 3
    2715-2017-11-19T15:15:11.735993Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
    2716-2017-11-19T15:15:11.736057Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_rsync --role 'joiner' --address '192.168.1.102' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix '' --parent '3104' --binlog 'mysql-bin' )
    2717:which: no lsof in (/usr/sbin:/sbin:/usr/local/Percona-XtraDB-Cluster-5.7.18-rel15-29.20.1.Linux.x86_64.ssl101/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin:/root/bin)
    2718-2017-11-19T15:15:11.874860Z 0 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '192.168.1.102' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix '' --parent '3104' --binlog 'mysql-bin'
    2719:    Read: ''lsof' not found in PATH'
    2720-2017-11-19T15:15:11.874912Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '192.168.1.102' --datadir '/data/mysql/3306/data/' --defaults-file '/data/mysql/3306/my.cnf' --defaults-group-suffix '' --parent '3104' --binlog 'mysql-bin' : 2 (No such file or directory)
    2721-2017-11-19T15:15:11.874964Z 2 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
    2722-2017-11-19T15:15:11.874987Z 2 [ERROR] Aborting
    2723-
    2724-2017-11-19T15:15:11.874993Z 2 [Note] Giving 2 client threads a chance to die gracefully
    問題描述:無法傳輸SST

    原因:缺少依賴組件lsof

    解決辦法:yum -y install lsof

  4. 建議:1.先單機啟動,更改完root賬號,并創建好sst傳輸賬號后,再啟動第一個節點

          2.若xtrabackup-v2傳輸方式總是報錯,可以改用rsync,并注釋掉auth行

          3.第二第三個節點啟動失敗,可以暴力一點刪掉data目錄下面的文件后重新初始化

          4.可以刪除data目錄下面g開頭的兩個集群信息文件重新啟動進行嘗試排錯

          5.telnet主節點的4567端口判斷網絡和主節點的mysqld服務是否正常。

          6.libaio,openssl也可以考慮安裝

以上就是PXC搭建問題有哪些,小編相信有部分知識點可能是我們日常工作會見到或用到的。希望你能通過這篇文章學到更多知識。更多詳情敬請關注億速云行業資訊頻道。

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

亚洲午夜精品一区二区_中文无码日韩欧免_久久香蕉精品视频_欧美主播一区二区三区美女