Local IP call to Galera-Mysql donor.

[Chatsiri Rattana]

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)

[alexey.y...@galeracluster.com]

wsrep_sst_receive_address specifies which address the donor needs to use
to connect to joiner.

But the best way seems to be to use domain names instead of IP addresses
in configuration and make sure the names resolve to correct IPs on the
nodes.