|
|
pacemaker可以管理galera集群，当节点数据库被kill掉，或者无故宕机重启之后，可以被拉起来- T$ y$ U. o- C2 G. c+ A1 H; {
但是如果第一个节点被弄宕机之后，是不会被拉起来的，
! n- O1 c4 a/ L) R1 R' E$ a只能重新启动集群的方式启动数据库
5 h, G9 P/ k" X- c. X0 E2 Q这时问题就来了，第一个节点再次被启动之后，其他两个节点的数据不会和该节点数据一致；使用lsof -i:4567就会发现：
# Y' X* x& I6 `! n' t[root@controller1 ~]# ps -ef |grep mysql7 b6 |5 X' i4 {/ t3 e% c5 m
root 6111 2807 3 17:52 pts/1 00:00:00 /usr/libexec/mysqld --wsrep-new-cluster --user=root
4 v! [9 b, u7 _2 w" [1 nroot 6162 2807 0 17:52 pts/1 00:00:00 grep --color=auto mysql
/ L. x: N n `8 |- ~, C+ j[root@controller1 ~]# lsof -i:4567
: \' J( |! W1 V6 }9 q; _COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME& u1 ?/ U" z+ Z7 @
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN)0 [ L" v/ ]8 q9 D9 D i/ Z& K
[root@controller1 ~]# crm_mon -i1 -f
p, \; M# L4 H& `% E. TConnection to the CIB terminated# A" _1 \8 B4 B9 R' h+ l6 d. q# w' @; Q
[root@controller1 ~]# lsof -i:4567
( f( _7 m# L) ^% H& U9 cCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME3 k+ L7 z! W1 N( y5 B6 Z
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN)
5 z% ?. M$ l- w) g" S- [. Nmysqld 6111 root 25u IPv4 4609115 0t0 TCP controller1:tram->controller2:47986 (ESTABLISHED); i5 n5 ~8 C& @
mysqld 6111 root 51u IPv4 4599863 0t0 TCP controller1:tram->controller3:46132 (ESTABLISHED)) @( }2 T3 o; a8 B
, U) s; l9 c/ }( g. w" m1 M0 g r- n2 C% E/ I# x" t6 B9 D
6 J" V, W! Z$ Q+ a9 @( \
第二个节点的状态如下：( `, H3 ^; n" O, e, q" n( h$ c
[root@controller2 noarch]# ps -ef |grep mysql, J8 N d' m+ v
mysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr% E' d/ G- P N" h4 W4 q
root 29400 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql
* q; G# e- S" Y$ a5 W! G- S[root@controller2 noarch]# ps -ef |grep mysql
' H! y3 M2 K( R$ R7 v3 I7 vmysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
+ p% i9 U4 F& l0 b Froot 29402 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql! _" ]' y5 x' i2 K4 q7 G
[root@controller2 noarch]# lsof -i:4567
8 j1 l! Q! w `COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME: t. N5 u! N' r4 |# ^5 h
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
7 Q5 {. k" d7 o* ]7 t6 I+ f/ e6 I. Mmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)2 O4 C2 H7 K+ _! Q
[root@controller2 noarch]# lsof -i:45679 h# l7 L$ j$ Y) z
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME: P% ~% o' `" s- i% i
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)% L# C, A1 q6 A" X
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
; q6 F- A! _$ ~$ Z[root@controller2 noarch]# lsof -i:4567
4 _. W X' u6 O0 K Y% o$ mCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME* {% s& r6 \# W
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
% J! p, l: [" C3 w8 [mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED) H1 S, e' }4 U i8 l5 q
[root@controller2 noarch]# lsof -i:4567
; \- V* f9 d# M) V- sCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME7 C8 M3 }* ]* H5 ^
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN). b, E, C4 Q. v0 L
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
. Q0 I$ ^( y( E# t[root@controller2 noarch]# lsof -i:4567
/ z- g' ~6 t$ i# |6 z5 SCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME5 A6 C5 y O- ^# G2 E
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
$ [4 e: \( F1 \% |3 C' Z4 E, cmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
: Y% t( l4 o0 m& } X1 U M' ]/ q[root@controller2 noarch]# lsof -i:4567
/ m. }( e! y" f8 G5 CCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME: g# g$ d8 c. o6 r) S0 }1 @- w
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)' d ~1 e* u& X
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
( G, D) Y! L/ K& V[root@controller2 noarch]# lsof -i:4567! _# L3 h2 w4 O9 K2 k
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME4 q$ |/ O4 f: }* o7 V! q+ o& a
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
) y) c! Q1 E: l& p' wmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED) } q1 v# ?. Z: h
[root@controller2 noarch]# lsof -i:4567, ^* Q, f9 h8 f4 k: q! v; i
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME# k0 W6 J) H( a( U
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
- @4 F. u0 p% {mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)& T, Z! o3 @5 d! X; v T
[root@controller2 noarch]# lsof -i:45675 [1 r3 j1 o. s3 u
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME& Q- E' I+ p+ J- _+ N4 g; {- l
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)$ q5 w& V! Z# n6 m; x0 n( J/ v" Q
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
/ Z2 N7 U% Z1 E[root@controller2 noarch]# ps -ef |grep mysql 6 T+ ^" M6 R3 K& P
mysql 29028 1 1 17:43 ? 00:00:10 /usr/libexec/mysqld --basedir=/usr4 H4 L5 X B6 h& C
root 29544 4880 0 17:54 pts/0 00:00:00 grep --color=auto mysql
. X( W, N. U* s& v" m7 ?/ x! }. M. B# R[root@controller2 noarch]# kill -9 29028
) t, v. r* G$ Y[root@controller2 noarch]# ps -ef |grep mysql
$ o% |# _& b) L: j, }mysql 29632 1 1 17:54 ? 00:00:00 /usr/libexec/mysqld --basedir=/usr
$ g: r3 N/ w# b8 o1 ^7 vroot 29641 4880 0 17:55 pts/0 00:00:00 grep --color=auto mysql
& f- G6 ?" S- S- G& h# z$ x: N$ x[root@controller2 noarch]# lsof -i:45673 Q1 ?6 X# V! x2 c9 \
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
" O1 \* {' p* u- y8 |mysqld 29632 mysql 11u IPv4 4513297 0t0 TCP *:tram (LISTEN)4 v% f2 Q9 [7 r: b$ {9 l. Y0 i
mysqld 29632 mysql 12u IPv4 4513641 0t0 TCP controller2:tram->controller3:40324 (ESTABLISHED)) c) v; J ?7 u4 |; y: o7 {1 T4 ^
mysqld 29632 mysql 13u IPv4 4513720 0t0 TCP controller2:tram->controller1:40644 (ESTABLISHED)+ r) K3 j7 x% A# m, B! W! I
[root@controller2 noarch]# ps -ef |grep mysql
# W) j+ m* m; L* c, j( Q- @+ `mysql 29632 1 1 17:54 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
& f7 f) ~* ^4 i0 l) q' X P% rroot 29953 4880 0 18:01 pts/0 00:00:00 grep --color=auto mysql" u5 b3 ^5 P. c* C ^
' B/ ]+ {4 n: M- r
2 B' @9 z' K8 d4 _第三个节点：, t1 y- k6 O1 t% q
[root@controller3 noarch]# ps -ef |grep mysql4 w2 v$ w" x/ Y6 {; _3 B5 t
mysql 28955 1 1 17:55 ? 00:00:07 /usr/libexec/mysqld --basedir=/usr$ z5 `% i% w8 A' x
root 29396 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql4 g5 R! ^2 K# b- _# W( P6 d
[root@controller3 noarch]# kill -9 28955
' \8 n) m9 L3 ]/ h7 y[root@controller3 noarch]# ps -ef |grep mysql
7 `# _; A& ?4 v' H2 ?root 29426 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql b8 v. p$ v/ K0 b7 ^% L
[root@controller3 noarch]# lsof -i:4567
" N6 F6 s* ]' g& m7 w[root@controller3 noarch]# lsof -i:4567' ^2 f/ d* x0 F9 ]6 M
[root@controller3 noarch]# lsof -i:4567' F" [8 f. R: {
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
5 A* Y* U5 a$ i3 F1 |2 o9 tmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)* e+ | ]! Z6 x+ @* e6 d; ]
[root@controller3 noarch]# lsof -i:4567- P4 i" p8 b5 Z% s; d! L: X# X
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
9 N* m9 f% ?* A8 w% Tmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
, F+ W1 }1 ?: q t; }/ |7 d[root@controller3 noarch]# lsof -i:4567 }( y C& g i$ D/ |0 X
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
9 {7 S4 r; _/ s$ w8 e. Y- D! w2 vmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
8 y( ? g9 D f7 v. U" [' C1 l( V; nmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
+ V. m4 `( _# y[root@controller3 noarch]# lsof -i:4567, }) O& ^) Z% K1 F
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME3 d ?! B1 `+ \, l- r: N! u# L7 V
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
4 h) ]( C4 z3 p( W3 |, m% {: Xmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
1 `" b( M$ `3 Amysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
2 v2 e9 D% Z5 s[root@controller3 noarch]# lsof -i:4567
7 H7 T9 }) ^0 }( n& d! O; ?. PCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
( d0 O6 q. q8 e: n. zmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN) N% `6 U; K- N% W. ~2 a& |" r
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
. T5 d3 E- W. k3 `" w, ?5 c! |$ Nmysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
; A* D6 y' d) t2 _[root@controller3 noarch]# lsof -i:4567
) s' X4 v) \- T" x/ y$ ]. J" J1 ZCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
. L" s, A9 K5 ~/ L7 m& ?mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)- R1 e( }2 I4 A! y: R
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)+ w# ?& m X# a' u( K
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
1 ~* M" ]& m% ?[root@controller3 noarch]# lsof -i:4567
6 c! \5 F s! F" nCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
/ F7 ~* F) a B$ h2 emysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
$ j2 [/ p4 |4 p$ \- Z. D) Zmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
3 Q* P; o6 g! J7 ] {mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
" m6 i0 s, n6 j2 t[root@controller3 noarch]# lsof -i:4567
8 f+ t2 p4 k$ }# G0 z- c. vCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
3 L# ?+ }8 ^6 C: Rmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)9 w3 _1 |; y+ i* M7 f' S& b4 I7 y4 s
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)9 ]: L' v& _) s8 X* b" i# [
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
0 K$ Q) K6 ]: Q
% x: S$ ^! W1 |5 \5 o; U P* _/ U8 q
0 Y0 w$ g! h# k8 P5 u$ m) C- k也就是说，在第一个节点宕机之后，启动集群之后，第二三两个节点也必须kill掉，mysql的4567端口数据才会一致，否者就会出现第一个节点是一个状态，第二三个节点是另一个状态，就是我们说的脑裂现象。
, \& W/ m0 A2 G6 y% W) H5 @ |
|
发表于 2018-7-29 22:18:03