MySQL5.8 Group Replication + F5实现高并发

 同城双活

、 环境介绍

系统版本：内核： ! "#$#

数据库版本：%&'""

机器配置：()*+,()-!"##. /"#01

%："

23：

机器 +(：" " ，" ""  4 类

9;@?*77:.%&'5%7:578%777.!5A=B!:8;%

C%&':D

9

9%.:=9:;%8E8;%%?:

955;&FG8E8::5:.G

9:6$6H$?$1I"

9

9%.:=9.&%?:=&?B*===

95;=;6&=6<653?

9=$6

9:$:$6H$1I"

::I7.767%&'

53I7.767%&'7%&'53

926=&%65!35%%::?.:5&3

&%65!3I

?I #

.$:I

=B:$%:IL

85$=B:$55&IL

%$8$?&IJEM-

!=?$?5B$=?$%  I  O546""!"6!#!68!

""8#O

!=?$?5B$$$6IH

!=?$?5B$5$::IO" " * #O

!=?$?5B$=?$:

IO" " * #" "* #""  4* # O

!=?$?5B$=$?%&$%:IH

=?$?5B$?$<;IO" " 7"" "7

""  47""7O9这里一定要在配置文件里写

=!I7.7=7%&'7%&':=

?:!AI7.77%&':7%&':?:

%$55$I

%$55BI

%$<:$?53I

:6$?$AI"9+?5A;%%%%6

6$?$55;$5     I  #              9  E  .  8   #  

5%%::&%;B&#%5

55$B%I9:8J;%685:;

;%&':.<855?5368?:=

<;M:;:;3

53$<$B%I 9%:53

:6$53$<$B%I9:6<53

<$B%I

5B.$B%I

:6$6H$?$5I

5B$BI-E2!+JJ-29-(-EJEM-!-E2

:6$P;$%;:I$2+-J

:6$A$?$6I

:6$?=$;:I98;%68;5%;

%.#

:6$P;$=$$$5%%I9:8

:6$6H$?$:$$?I

:6$?$$::53I

:6$$$=$%$1I9?5A??%;

18;%?&=A::=22?B

8+2M6



'&$55;$&?I9:8F

'&$55;$1I9

3&$6H$1I#

%?$6$1I#

=$<=I9:8N;;?:5<=

;=:6:

=$'&$B%I

<$'&$=I

=$<$:%$%I

=$<$.$%I

%$%:$<$%I9?8%5$5;%$:=$1

:8+:-;6'&:

5:<=

<$'&$=$AI<=