Not the answer you need?
Register and ask your own question!

can we initial new node from a slave?

HongtaoHongtao EntrantInactive User Role Contributor
in case we have 3 node cluster(n1/n2/n3), and a slave s1 replicating from n1, and we want to add another node n4 to cluster, I did innobackupex full backup from s1, after apply-logs, i have
!1160 $ cat xtrabackup_galera_info
c11c2c75-6e7f-11e6-a8e4-f3070c514224:5975027

and make it in grastate.dat, but always go to SST, IST can not works, can you help us here?


2016-09-12 09:05:53 29469 [Note] WSREP: save pc into disk
2016-09-12 09:05:53 29469 [Note] WSREP: discarding pending addr without UUID: tcp://10.2.1.239:4567
2016-09-12 09:05:54 29469 [Note] WSREP: gcomm: connected
2016-09-12 09:05:54 29469 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2016-09-12 09:05:54 29469 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2016-09-12 09:05:54 29469 [Note] WSREP: Opened channel 'Cluster01'
2016-09-12 09:05:54 29469 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2016-09-12 09:05:54 29469 [Note] WSREP: Waiting for SST to complete.
2016-09-12 09:05:54 29469 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1c101e3d-78c8-11e6-b8c1-9bfa0f3f96d4
2016-09-12 09:05:54 29469 [Note] WSREP: STATE EXCHANGE: sent state msg: 1c101e3d-78c8-11e6-b8c1-9bfa0f3f96d4
2016-09-12 09:05:54 29469 [Note] WSREP: STATE EXCHANGE: got state msg: 1c101e3d-78c8-11e6-b8c1-9bfa0f3f96d4 from 0 (Node3)
2016-09-12 09:05:54 29469 [Note] WSREP: STATE EXCHANGE: got state msg: 1c101e3d-78c8-11e6-b8c1-9bfa0f3f96d4 from 1 (Node1)
2016-09-12 09:05:54 29469 [Note] WSREP: STATE EXCHANGE: got state msg: 1c101e3d-78c8-11e6-b8c1-9bfa0f3f96d4 from 2 (Node2)
2016-09-12 09:05:54 29469 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 24,
members = 2/3 (joined/total),
act_id = 8368131,
last_appl. = -1,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = c11c2c75-6e7f-11e6-a8e4-f3070c514224
2016-09-12 09:05:54 29469 [Note] WSREP: Flow-control interval: [28, 28]
2016-09-12 09:05:54 29469 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 8368131)
2016-09-12 09:05:54 29469 [Note] WSREP: State transfer required:
Group state: c11c2c75-6e7f-11e6-a8e4-f3070c514224:8368131
Local state: c11c2c75-6e7f-11e6-a8e4-f3070c514224:5975027
2016-09-12 09:05:54 29469 [Note] WSREP: New cluster view: global state: c11c2c75-6e7f-11e6-a8e4-f3070c514224:8368131, view# 25: Primary, number of nodes: 3, my index: 0, protocol version 3
2016-09-12 09:05:54 29469 [Warning] WSREP: Gap in state sequence. Need state transfer.
2016-09-12 09:05:54 29469 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address 'pxc03.stg' --datadir '/export/data/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '29469' --binlog 'mysql-bin' '
WSREP_SST: [INFO] Streaming with xbstream (20160912 09:05:54.230)
WSREP_SST: [INFO] Using socat as streamer (20160912 09:05:54.232)
WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20160912 09:05:54.263)
2016-09-12 09:05:54 29469 [Note] WSREP: Prepared SST request: xtrabackup-v2|pxc03.stg:4444/xtrabackup_sst//1
2016-09-12 09:05:54 29469 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-09-12 09:05:54 29469 [Note] WSREP: REPL Protocols: 7 (3, 2)
2016-09-12 09:05:54 29469 [Note] WSREP: Service thread queue flushed.
2016-09-12 09:05:54 29469 [Note] WSREP: Assign initial position for certification: 8368131, protocol version: 3
2016-09-12 09:05:54 29469 [Note] WSREP: Service thread queue flushed.
2016-09-12 09:05:54 29469 [Note] WSREP: IST receiver addr using tcp://pxc03.stg:4568
2016-09-12 09:05:54 29469 [Note] WSREP: Prepared IST receiver, listening at: tcp://10.2.1.238:4568
2016-09-12 09:05:54 29469 [Note] WSREP: Member 0.0 (Node3) requested state transfer from '*any*'. Selected 1.0 (Node1)(SYNCED) as donor.
2016-09-12 09:05:54 29469 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 8368131)
2016-09-12 09:05:54 29469 [Note] WSREP: Requesting state transfer: success, donor: 1
WSREP_SST: [INFO] Proceeding with SST (20160912 09:05:54.624)
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20160912 09:05:54.624)
WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20160912 09:05:54.626)
removed ‘/export/data/mysql/fwmrm_track/custom_report_schedule.frm’

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.