- 积分
- 16843
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
pacemaker可以管理galera集群，当节点数据库被kill掉，或者无故宕机重启之后，可以被拉起来 o) `+ T& X( w4 E* O* B
但是如果第一个节点被弄宕机之后，是不会被拉起来的，
; r4 C) x/ x* O$ a只能重新启动集群的方式启动数据库; Y% l! C9 R& b5 M6 u) _
这时问题就来了，第一个节点再次被启动之后，其他两个节点的数据不会和该节点数据一致；使用lsof -i:4567就会发现：
$ \2 ~" f: |: m* ?[root@controller1 ~]# ps -ef |grep mysql! C: q7 N% T' g
root 6111 2807 3 17:52 pts/1 00:00:00 /usr/libexec/mysqld --wsrep-new-cluster --user=root) [( |6 |; w1 P8 B* i. \
root 6162 2807 0 17:52 pts/1 00:00:00 grep --color=auto mysql
o* J2 j5 f. i8 ~9 r# P; f. m[root@controller1 ~]# lsof -i:4567
9 j4 z5 C4 f& Y6 yCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME: S: H6 p: T3 u7 p" O; M/ n; U
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN)% |6 s! A7 t6 k/ q) R- @3 y, w
[root@controller1 ~]# crm_mon -i1 -f % t5 l4 P) D/ r J! [, c
Connection to the CIB terminated
# ?0 I. _% x2 f$ [[root@controller1 ~]# lsof -i:45675 c$ u: z A# Q. b, H8 k) g
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME8 W: j) i3 l2 B4 T# m+ R1 l
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN)
7 w1 B# z5 K" z% S' j6 jmysqld 6111 root 25u IPv4 4609115 0t0 TCP controller1:tram->controller2:47986 (ESTABLISHED)
6 h/ |& b) W3 \7 D6 h# _( y/ _mysqld 6111 root 51u IPv4 4599863 0t0 TCP controller1:tram->controller3:46132 (ESTABLISHED)
5 v. \) E. z# { v8 P2 h; Z G* l; M$ S
$ `! K4 N4 \5 x( B. d r& Z9 Y+ m
6 p. E, d& y" | q1 @第二个节点的状态如下：2 B; x) m4 L* }' K- K$ v0 ^
[root@controller2 noarch]# ps -ef |grep mysql
, d5 W# R! @- _, T. C1 Z- @& zmysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
" J% M/ q$ H! R: Y7 Zroot 29400 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql
8 L) y5 h1 m' w' c7 S[root@controller2 noarch]# ps -ef |grep mysql
4 u2 v( F+ g- F. F8 Fmysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
& p# X( z2 a4 E5 V, droot 29402 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql- |4 m$ T3 u4 A6 e% i) Z: }
[root@controller2 noarch]# lsof -i:4567
. M# i" t4 H) D; K& t) V# gCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME. Y& n: C6 X+ s
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)% B4 \: V( x4 m2 p
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)# l* Y8 ]( }: d
[root@controller2 noarch]# lsof -i:4567- Y% O% ~/ S% h5 i: C+ M
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
# `" }) @8 k; H) v( Xmysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
% ^. H R5 o) l4 a, S# h1 Jmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
/ W- ]7 a. q/ ^[root@controller2 noarch]# lsof -i:4567
2 z& D* x7 [# h' W UCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME8 @* k4 A5 U+ ~7 U9 e' H
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
. u( o- ~" [7 S7 l8 B( T# F* ~mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)( S! b% j$ l% U: X/ N; G
[root@controller2 noarch]# lsof -i:4567
5 {- O1 X; n" E8 m7 k; PCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
5 i, C' U5 p- N; J5 F$ K; rmysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)& v, U2 e, D) P* h4 V2 a+ w( Z( @# C4 B
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
1 t3 ?% ^0 c; Y" X[root@controller2 noarch]# lsof -i:4567
3 r% m1 x' ~9 T4 D8 G) M& sCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
1 G; ~! u* v; ?0 S5 pmysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
+ t! ]) M+ e. P2 g& a8 x1 Omysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
: }1 j0 ^9 y+ p4 \! Y6 d6 m[root@controller2 noarch]# lsof -i:4567: g5 u8 |, b1 C
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
, h* q$ W% s) `mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)& G) j1 ?; v+ B F, E
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
; n$ @3 ^; K& W0 J3 ^! Y[root@controller2 noarch]# lsof -i:4567
6 J2 |" T# q& t8 o+ x% d6 ?COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
. C# V+ f- B) {- |mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN) C; m4 q P' |( Q0 ^# `8 ?
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
/ y1 l8 i9 f( _0 ^. P7 d* k, j[root@controller2 noarch]# lsof -i:4567% R# m" u. V. h% b" F: V; w; D
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME1 J3 M0 j+ W! r& V6 d. I/ n
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
. h' ?7 \" F! a$ S! ymysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
* _( d0 E' k" `5 U' D5 K/ u3 R! m[root@controller2 noarch]# lsof -i:45675 |- u0 p: L! `+ e: b! H* t% a
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
2 ^, H1 c: M. ~" Q) y2 Lmysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)7 Y7 M$ u/ P1 L* @: S% P/ u' S
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)& a) _+ P3 R; N( M6 X5 C7 V- ] D
[root@controller2 noarch]# ps -ef |grep mysql
# ~4 p# t* w, e' L6 ?# b. Amysql 29028 1 1 17:43 ? 00:00:10 /usr/libexec/mysqld --basedir=/usr
N! A5 b8 j! aroot 29544 4880 0 17:54 pts/0 00:00:00 grep --color=auto mysql8 i5 N2 {2 \; r0 ~4 J0 H2 i& V
[root@controller2 noarch]# kill -9 29028( M" \7 N# V# N% ]/ i& [ Z
[root@controller2 noarch]# ps -ef |grep mysql
L' u& _- X! e- d4 k Pmysql 29632 1 1 17:54 ? 00:00:00 /usr/libexec/mysqld --basedir=/usr( `6 t6 ~: \) ~7 R% N" e) d6 ~
root 29641 4880 0 17:55 pts/0 00:00:00 grep --color=auto mysql
2 r4 p! ~2 d1 M- q6 S[root@controller2 noarch]# lsof -i:4567- t! T9 L/ R5 v1 O; N
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
, X% J$ I; ?! [5 `' rmysqld 29632 mysql 11u IPv4 4513297 0t0 TCP *:tram (LISTEN)8 O u& t2 i4 { g$ X3 [
mysqld 29632 mysql 12u IPv4 4513641 0t0 TCP controller2:tram->controller3:40324 (ESTABLISHED)
2 I+ ?8 v9 Z/ w* }mysqld 29632 mysql 13u IPv4 4513720 0t0 TCP controller2:tram->controller1:40644 (ESTABLISHED)+ a9 v' p6 k8 S
[root@controller2 noarch]# ps -ef |grep mysql 0 V) x7 I7 [2 P7 ?
mysql 29632 1 1 17:54 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
1 r3 C. b. Z5 g! [3 `( _. \" z0 {root 29953 4880 0 18:01 pts/0 00:00:00 grep --color=auto mysql
/ l4 {7 a6 l7 N0 `- e
( b( R$ y1 k% _5 B5 J
5 a; i3 [+ m% o# Q第三个节点：% c: U+ r" i1 M$ [2 a0 n
[root@controller3 noarch]# ps -ef |grep mysql
. q3 K9 p# I7 ^mysql 28955 1 1 17:55 ? 00:00:07 /usr/libexec/mysqld --basedir=/usr& G+ n& _7 D7 K' Y# [
root 29396 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql" S3 h% Z e. i" X8 Q
[root@controller3 noarch]# kill -9 28955
/ \6 f- {" }* `3 V- F# k2 q[root@controller3 noarch]# ps -ef |grep mysql8 v0 d! {/ Q( K$ g+ Z
root 29426 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql; b1 b2 r9 x2 r. h, |
[root@controller3 noarch]# lsof -i:4567
) X4 ~# ~) P) G. V[root@controller3 noarch]# lsof -i:4567
`) V# E& ]# o1 V8 F3 v[root@controller3 noarch]# lsof -i:4567" l0 N) t$ G9 R# H4 t' `8 I9 u
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
+ r1 W) C/ Y- Gmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
, i( p8 @' ?6 |5 p7 p[root@controller3 noarch]# lsof -i:4567
* r d- t: A1 r* @$ cCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
. @1 M) o$ @( d! W" v3 y9 A5 _mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)3 O3 Y( y8 A! I' l. ~0 [8 b
[root@controller3 noarch]# lsof -i:45672 A2 {% t9 g. Z( ?, Q! y7 N7 U
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME8 n* V1 \# A5 L, `" W( A
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
& m' N0 z& ]' Y b' S$ z4 Lmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)& {6 X8 e) F) J5 q
[root@controller3 noarch]# lsof -i:4567
" d2 a! N1 {" e( @: e, w) ]4 wCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME4 [, p# @2 h' P) n# T
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
& B4 `: O0 l" j, d; _$ Lmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
; Q) ^4 s( `- a& qmysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED). K6 |8 ~% V: V9 b l# e8 _
[root@controller3 noarch]# lsof -i:4567$ q2 i8 f3 R( K" U
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME2 K$ h( Q5 D( Q% Y
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
3 v" ^: \4 ~( w" d3 @0 M8 vmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
. L G; c% D! r3 j amysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
5 @& N0 {5 }. x% X2 b. U[root@controller3 noarch]# lsof -i:4567
7 T2 k9 p- z8 O* B: j% [ ^4 ^" b, _COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME$ w: k7 ^9 V$ |, f" m' }2 T
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
5 Q7 Q& l9 c- I6 l/ f" ^& Vmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
% N9 ?# a) r# i2 I7 }4 emysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)5 j7 @6 A4 n. \& } w* a
[root@controller3 noarch]# lsof -i:4567
4 n9 @! F" E2 [. @& KCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
8 T1 t( Q) h3 \& z8 Pmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
0 D3 B: K3 o6 B3 r) Pmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
" S) N2 D: Z3 Y, m+ }mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
( Z% T0 ~7 t+ d# ^: X' I[root@controller3 noarch]# lsof -i:45673 {5 C; k! m- Z0 f
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME+ _- \' d" ?: Z- }5 O
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)* P( p' f7 Q+ ?; e3 W
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
5 Y. I* [& z, w4 J' emysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
( K! Y: a! b3 j# v5 B' n1 r% c9 m9 m4 C% L( e9 I, h
8 f; o9 X6 X, {2 c4 j/ R; A; q7 k: O
" ]7 Q/ l, q4 D: ^5 \
也就是说，在第一个节点宕机之后，启动集群之后，第二三两个节点也必须kill掉，mysql的4567端口数据才会一致，否者就会出现第一个节点是一个状态，第二三个节点是另一个状态，就是我们说的脑裂现象。 ? O$ X* r* F) I/ |" A M q
|
|
/4 
|返回首页|Archiver|小黑屋|易陆发现技术论坛
( 蜀ICP备2026014127号-1 )
窥视卡
雷达卡
发表于 2018-7-29 22:18:03
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜