Linux Enterprise-mysql read/write separation, group replication group-based Replication (2)

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-EGSjcKPAAAv86HuwiE831.png "style=" float : none; "title=" screenshot from 2017-09-29 10-37-58.png "alt=" Wkiom1nq-egsjckpaaav86huwie831.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/A6/83/wKioL1nQ9_yxWhOmAABn35AWl4Q336.png "style=" float : none; "title=" screenshot from 2017-09-29 10-40-44.png "alt=" Wkiol1nq9_yxwhomaabn35awl4q336.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/A6/83/wKioL1nQ9_2jfZjpAABt-v0E34Q445.png "style=" float : none; "title=" screenshot from 2017-09-29 10-43-21.png "alt=" Wkiol1nq9_2jfzjpaabt-v0e34q445.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-ELjDvHHAAB-92NVTpQ922.png "style=" float : none; "title=" screenshot from 2017-09-29 10-43-25.png "alt=" Wkiom1nq-eljdvhhaab-92nvtpq922.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-ELiLiO4AAA5EBxiplM025.png "style=" float : none; "title=" screenshot from 2017-09-29 10-43-42.png "alt=" Wkiom1nq-elilio4aaa5ebxiplm025.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/A6/83/wKioL1nQ9_2g9rk5AAA8SsRjUmU159.png "style=" float : none; "title=" screenshot from 2017-09-29 10-47-57.png "alt=" Wkiol1nq9_2g9rk5aaa8ssrjumu159.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/A6/83/wKioL1nQ9_2AfK0yAAAXQ2eYbrQ269.png "style=" float : none; "title=" screenshot from 2017-09-29 11-31-33.png "alt=" Wkiol1nq9_2afk0yaaaxq2eybrq269.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-EOypyEfAABXrNMTmNU094.png "style=" float : none; "title=" screenshot from 2017-09-29 11-31-43.png "alt=" Wkiom1nq-eoypyefaabxrnmtmnu094.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-EOyR7UpAABbAgHZmag939.png "style=" float : none; "title=" screenshot from 2017-09-29 11-31-53.png "alt=" Wkiom1nq-eoyr7upaabbaghzmag939.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/A6/83/wKioL1nQ9_7wgA6sAAAlXxNqiOs104.png "style=" float : none; "title=" screenshot from 2017-09-29 11-34-17.png "alt=" Wkiol1nq9_7wga6saaalxxnqios104.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/A6/83/wKioL1nQ9_7ChyClAABUjweER00562.png "style=" float : none; "title=" screenshot from 2017-09-29 11-34-24.png "alt=" Wkiol1nq9_7chyclaabujweer00562.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-EPC2juyAABgV4fwVAI418.png "style=" float : none; "title=" screenshot from 2017-09-29 11-36-25.png "alt=" Wkiom1nq-epc2juyaabgv4fwvai418.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/A6/83/wKioL1nQ9_6SCJ6pAAAWYfCBO_8769.png "style=" float : none; "title=" screenshot from 2017-09-29 11-36-32.png "alt=" Wkiol1nq9_6scj6paaawyfcbo_8769.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-EOgsrI8AABYHq9YE9Y878.png "style=" float : none; "title=" screenshot from 2017-09-29 11-39-43.png "alt=" Wkiom1nq-eogsri8aabyhq9ye9y878.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/A6/83/wKioL1nQ9_7gp7bHAABYfdVCyp8577.png "style=" float : none; "title=" screenshot from 2017-09-29 11-39-48.png "alt=" Wkiol1nq9_7gp7bhaabyfdvcyp8577.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-ESC-DAhAAAgyp3dFYk905.png "style=" float : none; "title=" screenshot from 2017-09-29 11-40-45.png "alt=" Wkiom1nq-esc-dahaaagyp3dfyk905.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/A6/83/wKioL1nQ9_-gUDlXAAAsajKGJdM804.png "style=" float : none; "title=" screenshot from 2017-09-29 11-41-19.png "alt=" Wkiol1nq9_-gudlxaaasajkgjdm804.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-ESweNzbAADzAYF83cM259.png "style=" float : none; "title=" screenshot from 2017-09-29 11-42-17.png "alt=" Wkiom1nq-eswenzbaadzayf83cm259.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-ESCbO3UAAA4OA-uwXY107.png "style=" float : none; "title=" screenshot from 2017-09-29 11-45-48.png "alt=" Wkiom1nq-escbo3uaaa4oa-uwxy107.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/A6/83/wKioL1nQ9__S6iyGAABfCMcvMWI794.png "style=" float : none; "title=" screenshot from 2017-09-29 11-53-36.png "alt=" Wkiol1nq9__s6iygaabfcmcvmwi794.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-G7iHokbAACVuGYNlIQ081.png "style=" float : none; "title=" screenshot from 2017-09-29 14-37-36.png "alt=" Wkiol1nq-g7ihokbaacvugynliq081.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-LPQJqReAABDuKdzU6A037.png "style=" float : none; "title=" screenshot from 2017-09-29 14-40-58.png "alt=" Wkiom1nq-lpqjqreaabdukdzu6a037.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-G6ia1KEAAC1DEfUKTE255.png "style=" float : none; "title=" screenshot from 2017-09-29 14-43-38.png "alt=" Wkiol1nq-g6ia1keaac1defukte255.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-LOQporAAABO8MefhR0337.png "style=" float : none; "title=" screenshot from 2017-09-29 14-44-42.png "alt=" Wkiom1nq-loqporaaabo8mefhr0337.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-LTiCyqGAADT1HDCihY907.png "style=" float : none; "title=" screenshot from 2017-09-29 14-44-55.png "alt=" Wkiom1nq-lticyqgaadt1hdcihy907.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-G-T2k5lAAC6_do01MU784.png "style=" float : none; "title=" screenshot from 2017-09-29 14-45-13.png "alt=" Wkiol1nq-g-t2k5laac6_do01mu784.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-LSi6cvSAADGjgQclLQ288.png "style=" float : none; "title=" screenshot from 2017-09-29 14-52-28.png "alt=" Wkiom1nq-lsi6cvsaadgjgqcllq288.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-G-zle46AACfxqlEsHo431.png "style=" float : none; "title=" screenshot from 2017-09-29 15-25-30.png "alt=" Wkiol1nq-g-zle46aacfxqlesho431.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-LTjLUZSAAA--V_HWNI152.png "style=" float : none; "title=" screenshot from 2017-09-29 15-27-02.png "alt=" Wkiom1nq-ltjluzsaaa--v_hwni152.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-G-wZfcbAABJVNZwsxQ583.png "style=" float : none; "title=" screenshot from 2017-09-29 15-27-07.png "alt=" Wkiol1nq-g-wzfcbaabjvnzwsxq583.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-G-g2PfOAAAk8J8FwHI332.png "style=" float : none; "title=" screenshot from 2017-09-29 15-29-15.png "alt=" Wkiol1nq-g-g2pfoaaak8j8fwhi332.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-LXSUMLZAACe693JKeI411.png "style=" float : none; "title=" screenshot from 2017-09-29 15-30-14.png "alt=" Wkiom1nq-lxsumlzaace693jkei411.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-LXhuqdEAAGaVGgW5Lw840.png "style=" float : none; "title=" screenshot from 2017-09-29 15-41-36.png "alt=" Wkiom1nq-lxhuqdeaagavggw5lw840.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-HDhJB2RAAFWtZ_3yHk358.png "style=" float : none; "title=" screenshot from 2017-09-29 15-41-55.png "alt=" Wkiol1nq-hdhjb2raafwtz_3yhk358.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-LbAe_K6AACiVnPk-4s828.png "style=" float : none; "title=" screenshot from 2017-09-29 15-42-24.png "alt=" Wkiom1nq-lbae_k6aacivnpk-4s828.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-HGiP0_oAAAdAtRZhBI227.png "style=" float : none; "title=" screenshot from 2017-09-29 15-42-59.png "alt=" Wkiol1nq-hgip0_oaaadatrzhbi227.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-HGhyzW5AABLXOAB5x4996.png "style=" float : none; "title=" screenshot from 2017-09-29 15-46-14.png "alt=" Wkiol1nq-hghyzw5aablxoab5x4996.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-Laye3h7AAB6oWky89A344.png "style=" float : none; "title=" screenshot from 2017-09-29 15-46-21.png "alt=" Wkiom1nq-laye3h7aab6owky89a344.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-LaAKOimAACPpiV5nUE460.png "style=" float : none; "title=" screenshot from 2017-09-29 15-46-58.png "alt=" Wkiom1nq-laakoimaacppiv5nue460.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-HGzYGZzAAAfvhVRKXc631.png "style=" float : none; "title=" screenshot from 2017-09-29 15-50-00.png "alt=" Wkiol1nq-hgzygzzaaafvhvrkxc631.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-HGCrkIhAACVQKChPSY467.png "style=" float : none; "title=" screenshot from 2017-09-29 15-50-04.png "alt=" Wkiol1nq-hgcrkihaacvqkchpsy467.png "/>

Group-based replication (group-based Replication) is a technology that is used in fault-tolerant systems. Replication-group (replication groups) are made up of multiple servers (nodes) that can communicate with each other.

At the communication layer, Group replication implements a series of mechanisms, such as atomic messages (atomic message delivery) and full-order messages (totalordering of messages).

These atomization, abstract mechanisms provide strong support for more advanced database replication scenarios.

MySQL Group replication is based on these technologies and concepts to achieve a multi-master full-update replication protocol.

In short, a replication-group is a set of nodes, each of which can perform transactions independently, while read and write transactions are reconciled after the other nodes in the group commit.

Therefore, when a transaction is ready to commit, an atomic broadcast is automatically made within the group informing the other nodes what has changed/what transaction has been performed.

This kind of atomic broadcasting means that the transaction is kept in the same order on each node.

This means that each node receives the same transaction log in the same order, so each node repeats the transaction logs in the same order, and eventually the entire group remains in a completely consistent state.

However, there is a possibility of resource contention between transactions executed on different nodes. This behavior is easily seen on two different concurrent transactions.

If you have two concurrent transactions on different nodes and you update the same row of data, resource contention will occur.

In this case, the group replication determines that the first committed transaction is a valid transaction, repeats itself throughout the group, and then commits a transaction that is either directly interrupted or rolled back, and finally discarded.

Therefore, this is also a non-shared replication scheme, where each node holds a complete copy of the data. Look at 01.png, describe the specific work flow, can be concise and other options to compare. This replication scheme is somewhat similar to the replication method of the database state machine (DBSM).

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-O2ipdTZAADTUK4Em48542.png "style=" float : none; "title=" screenshot from 2017-10-01 16-06-31.png "alt=" Wkiom1nq-o2ipdtzaadtuk4em48542.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-KiSBxEoAABFZJIuIsY056.png "style=" float : none; "title=" screenshot from 2017-10-01 16-06-54.png "alt=" Wkiol1nq-kisbxeoaabfzjiuisy056.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-O2RwFqCAAEN0HMcJpY348.png "style=" float : none; "title=" screenshot from 2017-10-01 16-07-07.png "alt=" Wkiom1nq-o2rwfqcaaen0hmcjpy348.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-O7BO1dRAAEeOLG5cr8284.png "style=" float : none; "title=" screenshot from 2017-10-01 16-09-54.png "alt=" Wkiom1nq-o7bo1draaeeolg5cr8284.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-KnzGM71AAEDNnAbbUY664.png "style=" float : none; "title=" screenshot from 2017-10-01 16-10-38.png "alt=" Wkiol1nq-knzgm71aaednnabbuy664.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-KnT3v3JAAAksvDnk3E638.png "style=" float : none; "title=" screenshot from 2017-10-01 16-13-26.png "alt=" Wkiol1nq-knt3v3jaaaksvdnk3e638.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-O7D8QvUAAAo1uk34t8680.png "style=" float : none; "title=" screenshot from 2017-10-01 16-13-41.png "alt=" Wkiom1nq-o7d8qvuaaao1uk34t8680.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-O6RqpUiAAAxR5sFyWw552.png "style=" float : none; "title=" screenshot from 2017-10-01 16-13-52.png "alt=" Wkiom1nq-o6rqpuiaaaxr5sfyww552.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-KmiItibAABcP2iBT0A600.png "style=" float : none; "title=" screenshot from 2017-10-01 16-14-12.png "alt=" Wkiol1nq-kmiitibaabcp2ibt0a600.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-KqSxeMsAAD0fJy0Plg240.png "style=" float : none; "title=" screenshot from 2017-10-01 16-14-31.png "alt=" Wkiol1nq-kqsxemsaad0fjy0plg240.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-O-hGZIrAAAdJlfMbPo586.png "style=" float : none; "title=" screenshot from 2017-10-01 16-14-40.png "alt=" Wkiom1nq-o-hgziraaadjlfmbpo586.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-KqRE33XAAAsmA4_674017.png "style=" float : none; "title=" screenshot from 2017-10-01 16-14-47.png "alt=" Wkiol1nq-kqre33xaaasma4_674017.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-O_i8Z19AAC1PXktSMo197.png "style=" float : none; "title=" screenshot from 2017-10-01 16-14-56.png "alt=" Wkiom1nq-o_i8z19aac1pxktsmo197.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-PCSnzAaAACNknpTapY156.png "style=" float : none; "title=" screenshot from 2017-10-01 16-15-30.png "alt=" Wkiom1nq-pcsnzaaaacnknptapy156.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-KqTHNWgAACC59Tkt7U968.png "style=" float : none; "title=" screenshot from 2017-10-01 16-15-40.png "alt=" Wkiol1nq-kqthnwgaacc59tkt7u968.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-KvzGzQXAACLKKjgUno375.png "style=" float : none; "title=" screenshot from 2017-10-01 16-16-14.png "alt=" Wkiol1nq-kvzgzqxaaclkkjguno375.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-PCAXxjeAAD3PSMBRfw120.png "style=" float : none; "title=" screenshot from 2017-10-01 16-16-22.png "alt=" Wkiom1nq-pcaxxjeaad3psmbrfw120.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-Kvw_0n-AABweOUu-nk989.png "style=" float : none; "title=" screenshot from 2017-10-01 16-16-27.png "alt=" Wkiol1nq-kvw_0n-aabweouu-nk989.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-PDyR2NmAABnufTX5pY786.png "style=" float : none; "title=" screenshot from 2017-10-01 16-16-34.png "alt=" Wkiom1nq-pdyr2nmaabnuftx5py786.png "/>

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/07/D1/wKiom1nQ-PGjyQ_RAADm3q7b_HA287.png "style=" float : none; "title=" screenshot from 2017-10-01 16-17-03.png "alt=" Wkiom1nq-pgjyq_raadm3q7b_ha287.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/A6/83/wKioL1nQ-KzDstITAACM1Eqnhac373.png "style=" float : none; "title=" screenshot from 2017-10-01 16-18-38.png "alt=" Wkiol1nq-kzdstitaacm1eqnhac373.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-PHAMi2iAAET_Ey-Nu0182.png "style=" float : none; "title=" screenshot from 2017-10-01 16-18-45.png "alt=" Wkiom1nq-phami2iaaet_ey-nu0182.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-KzglSJIAACKrw8JaL0687.png "style=" float : none; "title=" screenshot from 2017-10-01 16-18-52.png "alt=" Wkiol1nq-kzglsjiaackrw8jal0687.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/07/D1/wKiom1nQ-PLQslHcAABFX2dGitc690.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-01.png "alt=" Wkiom1nq-plqslhcaabfx2dgitc690.png "/>

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/A6/83/wKioL1nQ-K3BJ5TYAABc9gsBpA4454.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-06.png "alt=" Wkiol1nq-k3bj5tyaabc9gsbpa4454.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-K2xqvGMAAAeszYRidU443.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-22.png "alt=" Wkiol1nq-k2xqvgmaaaeszyridu443.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-PKSTZyFAABJAHRCiRk478.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-27.png "alt=" Wkiom1nq-pkstzyfaabjahrcirk478.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/A6/83/wKioL1nQ-K3h4Sk1AAA8lMy2R04952.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-42.png "alt=" Wkiol1nq-k3h4sk1aaa8lmy2r04952.png "/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/07/D1/wKiom1nQ-POjKHsdAAEBgyqcRD4570.png "style=" float : none; "title=" screenshot from 2017-10-01 16-19-55.png "alt=" Wkiom1nq-pojkhsdaaebgyqcrd4570.png "/>

Linux Enterprise-mysql read-write separation, group replication group-based Replication (2)