Hello all,
[Galera-Mysql Joiner, Local IP: 192.168.3.10 ] <--||--> [Galera-Mysql Donor, Public IP]
I use Galera db joiner in local IP connect to Galera-Mysql donor used to public IP. Donor is public ip received connection from local ip success but, Rsync reference local IP connection. Error as below.
rsync: failed to connect to 192.168.3.10 (192.168.3.10): No route to host (113)
rsync error: error in socket IO (code 10) at clientserver.c(122) [sender=3.0.9]
WSREP_SST: [ERROR] rsync returned code 10: (20151119 12:30:35.730)
How to changes 192.168.3.10 to external IP(27.55.160.106) of local IP?
Thank you,
R.Chatsiri
2015-11-19 12:30:31 28974 [Note] WSREP: (9a98e6d6, 'tcp://
0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2015-11-19 12:30:31 28974 [Note] WSREP: declaring a66a0a19 at tcp://
27.55.160.106:4567 stable
2015-11-19 12:30:31 28974 [Note] WSREP: Node 9a98e6d6 state prim
2015-11-19 12:30:32 28974 [Note] WSREP: view(view_id(PRIM,9a98e6d6,2) memb {
9a98e6d6,0
a66a0a19,0
} joined {
} left {
} partitioned {
})
2015-11-19 12:30:32 28974 [Note] WSREP: save pc into disk
2015-11-19 12:30:32 28974 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2015-11-19 12:30:32 28974 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a6d2a021-8e7e-11e5-beda-1b46a1fa45bc
2015-11-19 12:30:32 28974 [Note] WSREP: STATE EXCHANGE: sent state msg: a6d2a021-8e7e-11e5-beda-1b46a1fa45bc
2015-11-19 12:30:32 28974 [Note] WSREP: STATE EXCHANGE: got state msg: a6d2a021-8e7e-11e5-beda-1b46a1fa45bc from 0 (
db01.dr.bike.promptnow.com)
2015-11-19 12:30:32 28974 [Note] WSREP: STATE EXCHANGE: got state msg: a6d2a021-8e7e-11e5-beda-1b46a1fa45bc from 1 (pn.cluster.db10)
2015-11-19 12:30:32 28974 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 16,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = a46505e6-8a75-11e5-a30c-da4cd77205e1
2015-11-19 12:30:32 28974 [Note] WSREP: Flow-control interval: [23, 23]
2015-11-19 12:30:32 28974 [Note] WSREP: New cluster view: global state: a46505e6-8a75-11e5-a30c-da4cd77205e1:16, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3
2015-11-19 12:30:32 28974 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2015-11-19 12:30:32 28974 [Note] WSREP: REPL Protocols: 7 (3, 2)
2015-11-19 12:30:32 28974 [Note] WSREP: Service thread queue flushed.
2015-11-19 12:30:32 28974 [Note] WSREP: Assign initial position for certification: 16, protocol version: 3
2015-11-19 12:30:32 28974 [Note] WSREP: Service thread queue flushed.
2015-11-19 12:30:32 28974 [Note] WSREP: Member 1.0 (pn.cluster.db10) requested state transfer from '*any*'. Selected 0.0 (
db01.dr.bike.promptnow.com)(SYNCED) as donor.
2015-11-19 12:30:32 28974 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 16)
2015-11-19 12:30:32 28974 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2015-11-19 12:30:32 28974 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '
192.168.3.10:4444/rsync_sst' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/usr/my.cnf' --defaults-group-suffix '' '' --gtid 'a46505e6-8a75-11e5-a30c-da4cd77205e1:16''
2015-11-19 12:30:32 28974 [Note] WSREP: sst_donor_thread signaled with 0
2015-11-19 12:30:32 28974 [Note] WSREP: Flushing tables for SST...
2015-11-19 12:30:32 28974 [Note] WSREP: Provider paused at a46505e6-8a75-11e5-a30c-da4cd77205e1:16 (5)
2015-11-19 12:30:32 28974 [Note] WSREP: Tables flushed.
2015-11-19 12:30:34 28974 [Note] WSREP: (9a98e6d6, 'tcp://
0.0.0.0:4567') turning message relay requesting off
rsync: failed to connect to 192.168.3.10 (192.168.3.10): No route to host (113)
rsync error: error in socket IO (code 10) at clientserver.c(122) [sender=3.0.9]
WSREP_SST: [ERROR] rsync returned code 10: (20151119 12:30:35.730)
2015-11-19 12:30:35 28974 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '
192.168.3.10:4444/rsync_sst' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/usr/my.cnf' --defaults-group-suffix '' '' --gtid 'a46505e6-8a75-11e5-a30c-da4cd77205e1:16'
2015-11-19 12:30:35 28974 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '
192.168.3.10:4444/rsync_sst' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/usr/my.cnf' --defaults-group-suffix '' '' --gtid 'a46505e6-8a75-11e5-a30c-da4cd77205e1:16': 255 (Unknown error 255)
2015-11-19 12:30:35 28974 [Note] WSREP: resuming provider at 5
2015-11-19 12:30:35 28974 [Note] WSREP: Provider resumed.
2015-11-19 12:30:35 28974 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '
192.168.3.10:4444/rsync_sst' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/usr/my.cnf' --defaults-group-suffix '' '' --gtid 'a46505e6-8a75-11e5-a30c-da4cd77205e1:16'
2015-11-19 12:30:35 28974 [Warning] WSREP: 0.0 (
db01.dr.bike.promptnow.com): State transfer to 1.0 (pn.cluster.db10) failed: -255 (Unknown error 255)
2015-11-19 12:30:35 28974 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 16)
2015-11-19 12:30:35 28974 [Note] WSREP: Member 0.0 (
db01.dr.bike.promptnow.com) synced with group.
2015-11-19 12:30:35 28974 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 16)
2015-11-19 12:30:35 28974 [Note] WSREP: Synchronized with group, ready for connections
2015-11-19 12:30:35 28974 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2015-11-19 12:30:36 28974 [Note] WSREP: forgetting a66a0a19 (tcp://
27.55.160.106:4567)
2015-11-19 12:30:36 28974 [Note] WSREP: Node 9a98e6d6 state prim
2015-11-19 12:30:36 28974 [Note] WSREP: view(view_id(PRIM,9a98e6d6,3) memb {
9a98e6d6,0
} joined {
} left {
} partitioned {
a66a0a19,0
})
2015-11-19 12:30:36 28974 [Note] WSREP: save pc into disk
2015-11-19 12:30:36 28974 [Note] WSREP: forgetting a66a0a19 (tcp://
27.55.160.106:4567)
2015-11-19 12:30:36 28974 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2015-11-19 12:30:36 28974 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a9af5a8e-8e7e-11e5-8c94-be5da3ac44a8
2015-11-19 12:30:36 28974 [Note] WSREP: STATE EXCHANGE: sent state msg: a9af5a8e-8e7e-11e5-8c94-be5da3ac44a8
2015-11-19 12:30:36 28974 [Note] WSREP: STATE EXCHANGE: got state msg: a9af5a8e-8e7e-11e5-8c94-be5da3ac44a8 from 0 (
db01.dr.bike.promptnow.com)
2015-11-19 12:30:36 28974 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 2,
members = 1/1 (joined/total),
act_id = 16,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = a46505e6-8a75-11e5-a30c-da4cd77205e1
2015-11-19 12:30:36 28974 [Note] WSREP: Flow-control interval: [16, 16]
2015-11-19 12:30:36 28974 [Note] WSREP: New cluster view: global state: a46505e6-8a75-11e5-a30c-da4cd77205e1:16, view# 3: Primary, number of nodes: 1, my index: 0, protocol version 3
2015-11-19 12:30:36 28974 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2015-11-19 12:30:36 28974 [Note] WSREP: REPL Protocols: 7 (3, 2)
2015-11-19 12:30:36 28974 [Note] WSREP: Service thread queue flushed.
2015-11-19 12:30:36 28974 [Note] WSREP: Assign initial position for certification: 16, protocol version: 3
2015-11-19 12:30:36 28974 [Note] WSREP: Service thread queue flushed.
2015-11-19 12:30:42 28974 [Note] WSREP: cleaning up a66a0a19 (tcp://
27.55.160.106:4567)