Rechercher dans le manuel MySQL

Chapter 18 Group Replication

Table of Contents     [+/-]

18.1 Group Replication Background     [+/-]
18.1.1 Replication Technologies
18.1.2 Group Replication Use Cases
18.1.3 Multi-Primary and Single-Primary Modes
18.1.4 Group Replication Services
18.1.5 Group Replication Plugin Architecture
18.2 Getting Started     [+/-]
18.2.1 Deploying Group Replication in Single-Primary Mode
18.2.2 Deploying Group Replication Locally
18.3 Monitoring Group Replication     [+/-]
18.3.1 Group Replication Server States
18.3.2 The replication_group_members Table
18.3.3 The replication_group_member_stats Table
18.4 Group Replication Operations     [+/-]
18.4.1 Configuring an Online Group
18.4.2 Transaction Consistency Guarantees
18.4.3 Distributed Recovery
18.4.4 Network Partitioning
18.4.5 Support For IPv6 And For Mixed IPv6 And IPv4 Groups
18.4.6 Using MySQL Enterprise Backup with Group Replication
18.5 Group Replication Security     [+/-]
18.5.1 Group Replication IP Address Whitelisting
18.5.2 Group Replication Secure Socket Layer (SSL) Support
18.6 Group Replication Performance     [+/-]
18.6.1 Fine Tuning the Group Communication Thread
18.6.2 Flow Control
18.6.3 Message Compression
18.6.4 Message Fragmentation
18.6.5 XCom Cache Management
18.6.6 Responses to Failure Detection and Network Partitioning
18.7 Upgrading Group Replication     [+/-]
18.7.1 Combining Different Member Versions in a Group
18.7.2 Group Replication Offline Upgrade
18.7.3 Group Replication Online Upgrade
18.8 Group Replication System Variables
18.9 Requirements and Limitations     [+/-]
18.9.1 Group Replication Requirements
18.9.2 Group Replication Limitations
18.10 Frequently Asked Questions

This chapter explains MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies.

Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently.

There is a built-in group membership service that keeps the view of the group consistent and available for all servers at any given point in time. Servers can leave and join the group and the view is updated accordingly. Sometimes servers can leave the group unexpectedly, in which case the failure detection mechanism detects this and notifies the group that the view has changed. This is all automatic.

The chapter is structured as follows:


Find a PHP function

Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-group-replication.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

  1. View the html document Language of the document:en Manuel MySQL : https://dev.mysql.com/

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut