- 积分
- 16843
在线时间 小时
最后登录1970-1-1
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？开始注册
x
pacemaker可以管理galera集群，当节点数据库被kill掉，或者无故宕机重启之后，可以被拉起来
$ q$ h2 U9 b/ g! I9 J但是如果第一个节点被弄宕机之后，是不会被拉起来的，' B1 N( c& n7 F; P; X
只能重新启动集群的方式启动数据库
* l( ~: {7 O6 Z- J1 ?/ _这时问题就来了，第一个节点再次被启动之后，其他两个节点的数据不会和该节点数据一致；使用lsof -i:4567就会发现：
% U" z. B3 D; ]2 \1 a( L( s[root@controller1 ~]# ps -ef |grep mysql
% L( J6 r* l$ y( i8 p2 |root 6111 2807 3 17:52 pts/1 00:00:00 /usr/libexec/mysqld --wsrep-new-cluster --user=root4 E4 X* u% w! ?, `) O' t1 }- \
root 6162 2807 0 17:52 pts/1 00:00:00 grep --color=auto mysql2 g' a% G' x& j2 }; M
[root@controller1 ~]# lsof -i:4567% \+ J% R& x4 V
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME9 c. q# D# f+ A: _( g/ V! W0 n
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN)" i# @- h8 j5 s% q3 l; k- u, l
[root@controller1 ~]# crm_mon -i1 -f ' ~+ M. @& d1 t* b' f
Connection to the CIB terminated1 s! V& t: U4 U+ o2 k3 n2 @
[root@controller1 ~]# lsof -i:4567+ ]0 A( X& G+ N
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME0 z" _7 M3 d1 c* o
mysqld 6111 root 11u IPv4 4596223 0t0 TCP *:tram (LISTEN); o1 L8 a2 G+ \6 e. D+ F4 S
mysqld 6111 root 25u IPv4 4609115 0t0 TCP controller1:tram->controller2:47986 (ESTABLISHED)$ A3 H% K* q p8 Z6 G
mysqld 6111 root 51u IPv4 4599863 0t0 TCP controller1:tram->controller3:46132 (ESTABLISHED)# ^" z* _* W! ~+ O
2 H$ g, M d6 j I: }5 c3 D _9 L N: K) l+ ?) Z3 h1 x* ~
8 j; ?+ S5 _* E7 \" W- d
第二个节点的状态如下：1 X5 T3 v% M& R+ [# i/ G9 t
[root@controller2 noarch]# ps -ef |grep mysql6 \8 m# R7 r# v4 j" [6 Z' c5 [' T
mysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr+ K4 a8 [9 o% B
root 29400 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql5 Y2 R' E8 v5 A
[root@controller2 noarch]# ps -ef |grep mysql8 q% V9 S$ B5 h+ Y, w' z `
mysql 29028 1 1 17:43 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
$ ~5 P( ]; O# E8 D3 qroot 29402 4880 0 17:49 pts/0 00:00:00 grep --color=auto mysql8 h! K) C U2 W" ?5 H5 |
[root@controller2 noarch]# lsof -i:45671 d5 Z0 H: M' ^7 l5 }
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
; z9 q1 q7 p- x( omysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
& A: n" |& j% F# D& z0 Lmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)" {/ L+ b f6 N$ w p& u y, B
[root@controller2 noarch]# lsof -i:4567
, h) ~) A3 p- a# C' \COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME' ?# ^; s' n1 l+ J$ |7 l. B7 t
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
& }+ y$ D$ V" d' ~; Y! n* [mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)8 b5 _0 q# h6 [3 P ]/ S. M
[root@controller2 noarch]# lsof -i:45671 X/ U- O- E# i' ~
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME' n3 |+ Z" p& Q( f- f0 q) F8 H
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)' L" F8 h+ V- Z
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
" P, N4 e' V. ]# ] [[root@controller2 noarch]# lsof -i:4567& y- N; \) M; q7 @5 {7 ^. c
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME2 X" O$ L8 m( d! J3 Q+ S
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
0 l- Y6 Q- ]; `! P n: hmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
# |% \" t' C' ~9 b6 t J4 v9 L[root@controller2 noarch]# lsof -i:4567
( K1 T. j8 R+ N- _& Z8 KCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME: a8 Q( }' q* m0 e ]# J
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
T9 i6 i; r; O: e# I" @7 Rmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)
1 T2 x2 O* a# i7 P- [6 O[root@controller2 noarch]# lsof -i:4567' t) c. s0 e& G, U% b3 p/ R, Y" U
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
, m" {0 R, z6 @$ I- @' kmysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)
$ {( @% `; b# O2 Qmysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)8 ]2 U( Q: _4 I! g ?* k& h U
[root@controller2 noarch]# lsof -i:4567# k9 \, N! q3 {) k- z+ ]
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
2 B& C" }- i# ?7 amysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)- b% ~. R& E% @& @3 g" v- H
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)' e$ Z; p9 H# i4 P4 D9 {" Z
[root@controller2 noarch]# lsof -i:4567
; k! `+ a8 N! h. K2 sCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME. G6 ^5 D. [. n" _/ F. D! m
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)' y" @% `+ f& x4 M/ N1 n
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)2 t2 [, {5 p% e5 A
[root@controller2 noarch]# lsof -i:4567) Z" G$ ~- z U# I: f& K
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME* m( R' N# c7 t4 E4 P* m
mysqld 29028 mysql 11u IPv4 4495884 0t0 TCP *:tram (LISTEN)) ^: m" {1 Q9 u: w2 m8 p$ G1 ]3 U
mysqld 29028 mysql 12u IPv4 4504890 0t0 TCP controller2:tram->controller3:55332 (ESTABLISHED)1 E7 z0 ?: ? _- g( e `: ?
[root@controller2 noarch]# ps -ef |grep mysql
[, v( @9 p8 W4 n' x' z @mysql 29028 1 1 17:43 ? 00:00:10 /usr/libexec/mysqld --basedir=/usr
. }2 U2 D, y, _( C2 l4 B" hroot 29544 4880 0 17:54 pts/0 00:00:00 grep --color=auto mysql4 n7 [& C: t8 f3 U. I5 K- N
[root@controller2 noarch]# kill -9 290288 X& O) {, b& x
[root@controller2 noarch]# ps -ef |grep mysql
4 K. c X) W. p! g) Pmysql 29632 1 1 17:54 ? 00:00:00 /usr/libexec/mysqld --basedir=/usr1 \! o- }; C+ q- v! Q% w
root 29641 4880 0 17:55 pts/0 00:00:00 grep --color=auto mysql
/ P1 A" M% z) z! i1 T3 I[root@controller2 noarch]# lsof -i:4567
+ K6 @& t: a$ R) @. X8 rCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME1 }2 K( H) c! ?
mysqld 29632 mysql 11u IPv4 4513297 0t0 TCP *:tram (LISTEN)* S: V8 {8 g& P6 f8 t
mysqld 29632 mysql 12u IPv4 4513641 0t0 TCP controller2:tram->controller3:40324 (ESTABLISHED)2 K. H5 N6 Y1 z. p+ A3 w
mysqld 29632 mysql 13u IPv4 4513720 0t0 TCP controller2:tram->controller1:40644 (ESTABLISHED)6 ?( ~* k8 ?: }" }: I7 V; `. F6 ]3 o
[root@controller2 noarch]# ps -ef |grep mysql
7 v& U9 T C4 B5 v% Cmysql 29632 1 1 17:54 ? 00:00:06 /usr/libexec/mysqld --basedir=/usr
+ m- l: v* x& o5 `' D6 v9 I Eroot 29953 4880 0 18:01 pts/0 00:00:00 grep --color=auto mysql- p! u/ P+ S- k( o9 m
1 L; [2 u2 S2 S
) Y( o7 s7 Y0 }/ c0 M- Z7 q- O" A第三个节点：: s3 R# t8 N! w% b9 O# E: |
[root@controller3 noarch]# ps -ef |grep mysql6 r/ A6 j/ f F6 {8 T0 l% U6 M
mysql 28955 1 1 17:55 ? 00:00:07 /usr/libexec/mysqld --basedir=/usr
) h* g# |( o \2 |root 29396 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql
* D* x' v8 s4 i l1 b/ x W% h[root@controller3 noarch]# kill -9 28955/ m6 r) S/ S# ^3 O5 b
[root@controller3 noarch]# ps -ef |grep mysql
8 ]6 B$ E: t7 \; froot 29426 4824 0 18:02 pts/0 00:00:00 grep --color=auto mysql) V- ^# N8 i# F- ]# C
[root@controller3 noarch]# lsof -i:4567/ }8 Y5 f9 |2 n( v* f5 z& ]" A1 P, I
[root@controller3 noarch]# lsof -i:4567
' X, x. g8 H9 x* o$ L[root@controller3 noarch]# lsof -i:4567$ V& _$ M6 o6 m6 K/ x( z( T
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
& E4 V# N/ y7 t! Q, q( amysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)7 f' V. F; R; R7 W; H
[root@controller3 noarch]# lsof -i:4567
# p+ @: | G- d" y% TCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME+ B7 T9 N8 s/ @. H- d. P
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)+ B; Q$ l* s& F a! g) {* O4 ]
[root@controller3 noarch]# lsof -i:4567
' H4 d, {+ J: l( xCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
8 C4 A' [: x x% ]2 K F& [mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)6 y& f" _- ?8 H# z! h
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
$ G9 Y; y& Z/ |# k0 B' k$ Z* L[root@controller3 noarch]# lsof -i:4567
3 |0 F: o0 T2 Q9 z4 V( W( A; QCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
[0 g& @# b" `% A9 C; [3 {mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)5 \( p6 p5 u& _ t: G* v0 i- u
mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED). z5 R( s- C$ i* j' k% w% i
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
7 O( A p0 j) j# \1 y2 j[root@controller3 noarch]# lsof -i:45670 |" S7 z/ }5 w' d
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME1 z" H5 e8 T7 `/ s1 t3 _- O
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
% s; f. q% p: y1 @ D. |2 zmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)( v- _# w% ?# u: s
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)/ O) y! O ^' M! F1 S: \1 U. H
[root@controller3 noarch]# lsof -i:4567
; X$ p1 Q8 B3 R9 K) TCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
. D, N2 q# \1 Q% B9 C9 _' t1 Vmysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
' c: x4 l$ W- |* emysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)0 E z% ?) l3 K; h$ Z% z
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
9 W) c* {; N" K7 h) @[root@controller3 noarch]# lsof -i:4567
3 d4 ]1 N b' y6 h- y/ QCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME. D$ p+ E( n: c& k, k1 p9 i
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
) o5 g2 J1 P5 K8 }7 S# R( fmysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)6 Z6 \+ x% c' c( Q. J, u
mysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED)
1 T& c& Q( u! b' r2 m/ D7 J$ J[root@controller3 noarch]# lsof -i:4567
! _. R6 I0 p& H4 G3 E! ?' tCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME0 k H/ I6 g' S4 n
mysqld 29487 mysql 11u IPv4 4519472 0t0 TCP *:tram (LISTEN)
' r0 q% Q( ]8 [mysqld 29487 mysql 12u IPv4 4519587 0t0 TCP controller3:36394->controller1:tram (ESTABLISHED)
" r- H8 e: P6 ^! x1 hmysqld 29487 mysql 13u IPv4 4519625 0t0 TCP controller3:58954->controller2:tram (ESTABLISHED), y# X+ \! L" M$ O7 D$ _' U
8 D. X0 Q' F8 e4 P% N1 S: W4 q9 \. s/ J! F& j
( I6 F+ s+ U9 I* J' H! M C: t也就是说，在第一个节点宕机之后，启动集群之后，第二三两个节点也必须kill掉，mysql的4567端口数据才会一致，否者就会出现第一个节点是一个状态，第二三个节点是另一个状态，就是我们说的脑裂现象。3 y" W1 J5 @7 y l- N4 D
|
|
/4 
|返回首页|Archiver|小黑屋|易陆发现技术论坛
( 蜀ICP备2026014127号-1 )
窥视卡
雷达卡
发表于 2018-7-29 22:18:03
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜