mariadb, 4번째 galera 노드 추가 실패

mariadb, 4번째 galera 노드 추가 실패

저는 세 개를 가지고 있어요.node지난 몇 달간 완벽하게 설정하고 실행할 수 있었습니다.최근에 하나 더 추가하고 싶습니다.node다른 곳에 있는데 왠지 자꾸 오류가 나요.

처음에는 이 자습서를 따르고 있었습니다(몇 달 전 처음 설정한 곳에서) https://www.howtoforge.com/tutorial/how-to-install-and-configure-galera-cluster-on-ubuntu-1604/ 처음부터 모든 노드를 다시 시작한 것은 아니고 파일을 찾아야 합니다./mysql/conf.d/galera.cnf나머지 세 곳에서는nodes새로 추가했습니다.nodes앞의 세 개를 입력합니다.그래서 네 번째로 저는./etc/mysql/conf.d/galera.cnf마치...처럼...

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="galera_cluster"
wsrep_cluster_address="gcomm://node1_ip,node2_ip,node3_ip,node4_ip"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="xx.xx.xxx.xxx"
wsrep_node_name="Node4"

어찌된 영문인지 나는 엄청난 실수를 당하고 있습니다.

        Group state: e3ade7e7-e682-11e7-8d16-be7d28cda90e:36273
         Local state: 00000000-0000-0000-0000-000000000000:-1
  [Note] WSREP: New cluster view: global state: e3ade7e7-e682-11e7-8d16-be7d28cda90e:36273, view# 122: Primary, number of nodes: 4, my
  [Warning] WSREP: Gap in state sequence. Need state transfer.
  [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address 'xxx.node.4.ip' --datadir '/var/lib/mysql/'   --parent '22828'  ''
 rsyncd version 3.1.1 starting, listening on port 4444
  [Note] WSREP: Prepared SST request: rsync|xxx.node.4.ip:4444/rsync_sst
  [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  [Note] WSREP: REPL Protocols: 7 (3, 2)
  [Note] WSREP: Assign initial position for certification: 36273, protocol version: 3
  [Note] WSREP: Service thread queue flushed.
  [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not
          at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
  [Note] WSREP: Member 0.0 (Node4) requested state transfer from '*any*'. Selected 1.0 (Node1)(SYNCED) as donor.
  [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 36273)
  [Note] WSREP: Requesting state transfer: success, donor: 1
  [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> e3ade7e7-e682-11e7-8d16-be7d28cda90e:36273
 [Note] WSREP: (7642cf37, 'tcp://0.0.0.0:4567') connection to peer 7642cf37 with addr tcp://xxx.node.4.ip:4567 timed out, no messages
 [Note] WSREP: (7642cf37, 'tcp://0.0.0.0:4567') turning message relay requesting off
 mariadb.service: Start operation timed out. Terminating.
 Terminated
 WSREP_SST: [INFO] Joiner cleanup. rsync PID: 22875 
 sent 0 bytes  received 0 bytes  total size 0
 WSREP_SST: [INFO] Joiner cleanup done. 
  [ERROR] WSREP: Process was aborted.
  [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address 'xxx.node.4.ip' --datadir '/var/lib/mysql/'
  [ERROR] WSREP: Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script.
  [ERROR] WSREP: SST failed: 2 (No such file or directory)
  [ERROR] Aborting
 Error in my_thread_global_end(): 1 threads didn't exit
 mariadb.service: Main process exited, code=exited, status=1/FAILURE
 Failed to start MariaDB 10.1.33 database server.

이전 3개 노드의 PS maria db 버전은 10.1.29이고 새 노드는 10.1.33입니다.

어떤 제안이든 미리 감사드립니다.

언급URL : https://stackoverflow.com/questions/50498092/mariadb-add-4th-galera-node-failed