05-PXC MGC MGR 原理与实践对比-罗小波
- 格式：pdf
- 大小：13.24 MB
- 文档页数：41
D :
A>:
A
U ce[X[USe[`_ r
M C
& G U
R C
G U
0 2
8 1
r hc[e &d e r U` c`]]TSU\QUTp
ac[ Sc r ac[ Sc [eQUTp Saa] QUT hc[e &d eq
hc[e &d e
U`
r [eQUT
q
D :
A>:
A
M C
& G U
R C
slave_parallel_workers=16 slave_parallel_type=LOGICAL_CLOCK slave_preserve_commit_order=ON
A
M C
& G U
XXHASH64
R C
# ……
r db]VQdSX &&V XSf]ed&X[] 5( eU(
G U
ac[
M C
& G U
R C
G U
0 2
8 1
杭州沃趣科技股份有限公司
Hangzhou WOQU Technology Co., Ltd.
D :
A>:
A
M C
& G U
R C
G U
0 2
8 1
A>F
Yc`fa , CB@ B r
G* Yc`fa
G+
G,r
A
M C
& G U
R C
G U
0 2
8 1
A>F
r (ScUZ[g (TSU\fa r \ [__`TSU\fa i &&V XSf]ed&X[] 5( eU( 'U_X &&d]Sg &[_X` &&YS] cS[_X` O &&fd c5iecSTSU\fa &&aSddh`cV5iecSTSU\faaSdd &&_`&e[ deS a O &&dec S 5eSc '( l ddZ c``e7*)'*)'2)'*1) USe & 6 (ScUZ[g (TSU\fa(TSU\faQRVSe V d _U A GE@ 6 d e Y]`TS] hdc aQV d _U5C==4
A
M C
& G U
R C
&&hdc a&_ h&U]fde c ac[ Sc r db]VQdSX &&V XSf]ed&X[] 5( eU( _ h&U]fde c
G U
_`V * ac[
0 2
8 1
'U_X &&hdc a&
Sc "
r ac[ Sc A GE@ 6 dZ`h deSefd ][\ mhdc aQU]fde cQdeSefdm4
G # * YUSUZ 'd[k # +
_`V , r r GE@ i[V r G
YS] cS _`V ,
r
VSeS(YcSdeSe 'VSe
i[V r YcSdeSe 'VSe YS] cS
hdc a
A>F
_`V *
# IP server_id
MySQL Group Replication loose-group_replication_local_address
w
A
M C
& G U
R C
G U
0 2
8 1
f
A
M C
& G U
R C
G U
0 2
8 1
A
2015.11.03
M C
& G U
R C
G U
0 2
8 1
杭州沃趣科技股份有限公司
Hangzhou WOQU Technology Co., Ltd.
D :
A>:
_`V *
r u v>S] cS rw hdc aQ_`V QSVVc dd D hdc aQ`_5`_ hdc aQac`g[V c5(fdc(]`US]( db](][T(YS] cS(][TYS] cSQd 'd` hdc aQac`g[V cQ`ae[`_d5 YUSUZ 'd[k 5*>4n hdc aQU]fde cQ_S 5hbY]cQ)))* hdc aQU]fde cQSVVc dd5YU` 3((*)'*)'2)'*/03-./0%*)'*)'2)'*0-3-. /0%*)'*)'2)'*1)3-./0 hdc aQ_`V QSVVc dd5*)'*)'2)'*/03-./0 hdc aQddeQ eZ`V5iecSTSU\fa&g+ hdc aQddeQSfeZ5 iecSTSU\fa3iecSTSU\faaSddn hdc aQd]Sg QeZc SVd51
_`V ,r _`V + Saa] &]`Y r w r iecSTSU\faQYS] cSQ[_X` r YcSdeSe 'VSe Nc``e7]`US]Z`de TSU\faP USe (VSeS( db]VSeS*( VSeS(iecSTSU\faQYS] cSQ[_X` 0VVX0T)S&+U)0&** 1&2X..&-+2 1,+ S-VU3.))*,,+1 II ; .))*,,+1 v r YcSdeSe 'VSe r VSeSV[c Nc``e7ST)2*,2S&1TV*&-X )&SX2,&--T.U V,,S11 TSU\faP USe (VSeS( db]VSeS*( >8@ F8 dSg V deSe g cd[`_3 +'* ff[V3 0VVX0T)S&+U)0&** 1&2X..&-+2 1,+ S-VU d b_`3 .))*,,+1 U ceQ[_V i3
A
M C
t
r w
7 :E7lT
& G U
>S] cS r Wn
R C
gaP
A>FsA GE@ >c`fa F a][USe[`_ DSi`d A GE@ Yc`fa c a][USe[`_ qp r w
G U
r Wn
0 2
UcSdZy t
8 1
wSo
D :
A>:
A>F
A
M C
& G U
PXC MGC & MGR -
# server_id = 3306197 log-bin = /opt/mysql/data/binlog/mysql-bin binlog-format = ROW binlog-checksum = NONE master-info-repository = TABLE relay-log-info-repository = TABLE log_slave_updates=ON # ZSdZ 64 transaction_write_set_extraction=XXHASH64 gtid-mode = on enforce-gtid-consistency = true
A>:
_`V ,
r
u
v>S] cS
rw
hdc aQ_`V QSVVc dd
D oo hdc aQ_`V QSVVc dd5*)'*)'2)'*1)3-./0 iecSTSU\fa V d _U p _`V +q X]fdZ eST] h[eZ c SV ]`U\
r
A GE@ 6 d e Y]`TS] hdc aQV d _U5CB4
# group_replication_local_address IP loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "10.10.90.197:24901" loose-group_replication_group_seeds= "10.10.90.197:24901,10.10.90.186:24901,10.10.90.181:24901" loose-group_replication_bootstrap_group= off
G U
_`V +
0 2
'U_X _`V +
8 1
V`_`c rGG
r ac[ Sc A GE@ 6 dZ`h deSefd ][\ mhdc aQU]fde cQdeSefdm4 r G _U V
A GE@ 6 dZ`h deSefd ][\ mhdc aQ]`US]QdeSe QU`
_em4
D :
D :
A>:
A
M C
& G U
R C
G U
0 2
8 1
r r d]Sg bf f
