MariaDB Galera Cluster启动失败

Question

MariaDB Galera Cluster部署在两个节点，做双主。mysql启动时报错，希望各位大神帮忙看看什么问题？

日志信息如下所示

150714 11:01:21 [Note] WSREP: Tables flushed.

rsync: failed to connect to 192.168.1.102 (192.168.1.102): 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: (20150714 11:01:22.059)

150714 11:01:22 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '192.168.1.102:4444/rsync_sst' --auth 'sst:Mandofin123' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix ''   '' --gtid 'c409ed77-2957-11e5-9447-a6420e2c9010:0'

150714 11:01:22 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '192.168.1.102:4444/rsync_sst' --auth 'sst:Mandofin123' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix ''   '' --gtid 'c409ed77-2957-11e5-9447-a6420e2c9010:0': 255 (Unknown error 255)

150714 11:01:22 [Note] WSREP: resuming provider at 17

150714 11:01:22 [Note] WSREP: Provider resumed.

150714 11:01:22 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '192.168.1.102:4444/rsync_sst' --auth 'sst:Mandofin123' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix ''   '' --gtid 'c409ed77-2957-11e5-9447-a6420e2c9010:0'

150714 11:01:22 [Warning] WSREP: 1.0 (master): State transfer to 0.0 (slave) failed: -255 (Unknown error 255)

150714 11:01:22 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)

150714 11:01:23 [Note] WSREP: forgetting 9e032949 (tcp://192.168.1.102:4567)

150714 11:01:23 [Note] WSREP: Node a2a96332 state prim

150714 11:01:23 [Note] WSREP: view(view_id(PRIM,a2a96332,7) memb {

        a2a96332,0

} joined {

} left {

} partitioned {

        9e032949,0

})

150714 11:01:23 [Note] WSREP: save pc into disk

150714 11:01:23 [Note] WSREP: forgetting 9e032949 (tcp://192.168.1.102:4567)

150714 11:01:23 [Note] WSREP: Member 1.0 (master) synced with group.

150714 11:01:23 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)

150714 11:01:23 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1

150714 11:01:23 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 9befb3db-29d4-11e5-bba8-ee0ac86e43b2

150714 11:01:23 [Note] WSREP: STATE EXCHANGE: sent state msg: 9befb3db-29d4-11e5-bba8-ee0ac86e43b2

150714 11:01:23 [Note] WSREP: STATE EXCHANGE: got state msg: 9befb3db-29d4-11e5-bba8-ee0ac86e43b2 from 0 (master)

150714 11:01:23 [Note] WSREP: Quorum results:

        version    = 3,

        component  = PRIMARY,

        conf_id    = 6,

        members    = 1/1 (joined/total),

        act_id     = 0,

        last_appl. = 0,

        protocols  = 0/7/3 (gcs/repl/appl),

        group UUID = c409ed77-2957-11e5-9447-a6420e2c9010

150714 11:01:23 [Note] WSREP: Flow-control interval: [16, 16]

150714 11:01:23 [Note] WSREP: Synchronized with group, ready for connections

150714 11:01:23 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

150714 11:01:23 [Note] WSREP: New cluster view: global state: c409ed77-2957-11e5-9447-a6420e2c9010:0, view# 7: Primary, number of nodes: 1, my index: 0, protocol version 3

150714 11:01:23 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

150714 11:01:23 [Note] WSREP: REPL Protocols: 7 (3, 2)

150714 11:01:23 [Note] WSREP: Service thread queue flushed.

150714 11:01:23 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3

150714 11:01:23 [Note] WSREP: Service thread queue flushed.

150714 11:01:24 [Note] WSREP: (a2a96332, 'tcp://0.0.0.0:4567') turning message relay requesting off

150714 11:01:28 [Note] WSREP:  cleaning up 9e032949 (tcp://192.168.1.102:4567)

Answer 1

双主容易脑裂，三主会好一些。