Configure OpenStack MySQL HA centos7

See the official website configuration instructions are a bit different from the actual (CENTOS7), after some groping, the configuration process to record down

1. Download Mariadb-galera-server xinetd, the official website of the document is Mariadb-galera-server, after the search only Mariadb-galera-server, and after installing it, The previous mariadb will be replaced;

A.mariadb.repo

B.yum--enablerepo=mariadb.repo install-y mariadb-galera-server xinetd

2. Configuring Clustercheck and Galera See http://docs.openstack.org/zh_CN/high-availability-guide/content/ha-aa-db-mariadb-galera-rh.html

(The first node Start command is a bit different, the document is/USR/LIBEXEC/MYSQLD, I use the/usr/sbin/mysqld, this search mysqld location to determine)

3. After installation, there is a problem, except the first node, the other two are Qibulai Mysql.service:

151020 15:30:01 [Note] wsrep:new cluster View:global state:969b16ae-77a4-11e5-98d9-eea35bd653ec:5857, view# 12:primary , number of Nodes:2, my index:0, protocol version 3
151020 15:30:01 [Warning] wsrep:gap in state sequence. Need state transfer.
151020 15:30:01 [note] wsrep:running: ' Wsrep_sst_rsync--role ' joiner '--address ' 172.16.5.74 '--auth '--datadir '/var/ lib/mysql/'--defaults-file '/etc/my.cnf '--defaults-group-suffix '--parent ' 30117 '
151020 15:30:01 [ERROR] wsrep:failed to read ' Ready <addr> ' From:wsrep_sst_rsync--role ' joiner '--address ' 172.16 .5.74 '--auth '--datadir '/var/lib/mysql/'--defaults-file '/etc/my.cnf '--defaults-group-suffix ' '--parent ' 30117 '
Read: ' (null) '
151020 15:30:01 [ERROR] wsrep:process completed with Error:wsrep_sst_rsync--role ' joiner '--address ' 172.16.5.74 '--aut H '--datadir '/var/lib/mysql/'--defaults-file '/etc/my.cnf '--defaults-group-suffix '--parent ' 30117 ': 2 (No such File or directory)
151020 15:30:01 [ERROR] wsrep:failed to prepare for ' rsync ' SST. Unrecoverable.
151020 15:30:01 [ERROR] Aborting

151020 15:30:03 [Note] wsrep:closing send monitor ...
151020 15:30:03 [Note] wsrep:closed send monitor.
151020 15:30:03 [Note] WSREP:gcomm:terminating thread
151020 15:30:03 [Note] WSREP:gcomm:joining thread
151020 15:30:03 [Note] WSREP:gcomm:closing Backend
151020 15:30:04 [Note] Wsrep: (5C8FD4FD, ' tcp://0.0.0.0:4567 ') turning message relay requesting off
151020 15:30:05 [Note] Wsrep:view (view_id (non_prim,5c8fd4fd,26) memb {
5c8fd4fd,0
} joined {
} left {
} partitioned {
9e2b15dd,0
})
151020 15:30:05 [Note] Wsrep:view ((empty))
151020 15:30:05 [Note] WSREP:gcomm:closed
151020 15:30:05 [Note] wsrep:new component:primary = no, bootstrap = no, My_idx = 0, Memb_num = 1
151020 15:30:05 [Note] wsrep:flow-control interval: [16, 16]
151020 15:30:05 [Note] wsrep:received non-primary.
151020 15:30:05 [Note] wsrep:shifting PRIMARY, OPEN (to:5858)
151020 15:30:05 [Note] wsrep:received self-leave message.
151020 15:30:05 [Note] wsrep:flow-control interval: [0, 0]
151020 15:30:05 [Note] wsrep:received self-leave. Closing connection.
151020 15:30:05 [Note] wsrep:shifting OPEN, CLOSED (to:5858)
151020 15:30:05 [Note] wsrep:recv thread exiting 0:success
151020 15:30:05 [Note] Wsrep:recv_thread () joined.
151020 15:30:05 [Note] wsrep:closing replication queue.
151020 15:30:05 [Note] wsrep:closing slave action queue.
151020 15:30:05 [Note] wsrep:service disconnected.
151020 15:30:05 [Note] wsrep:rollbacker thread exiting
151020 15:30:06 [Note] wsrep:some threads may fail to exit.
151020 15:30:06 [Note]/usr/sbin/mysqld:shutdown complete

Error in My_thread_global_end (): 1 threads didn ' t exit
151020 15:30:11 mysqld_safe mysqld from PID File/var/lib/mysql/mysql4.pid ended

Previously thought that the installation process has a problem, so re-installed a few times, found that the problem still exists, then it is not accidental events, searched for the N-long Google did not search, and later changed the configuration of the/etc/my.cnf in feedback, restart after the good-.-

[Mysqld]

Feedback=on

Configure OpenStack MySQL HA centos7