Shulou(Shulou.com)06/03 Report--

This article introduces the relevant knowledge of "what are the characteristics of mysql group replication". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. High consistency.

Group replication technology based on local replication and paxos protocol, provided by plug-ins to provide consistent data security

2. High fault tolerance. You can continue to work as long as most of the nodes are not bad.

There is an automatic detection mechanism. When there is a resource conflict between different nodes, there is no error. According to the principle of first come first, automatic brain crack protection mechanism is built in.

3. High expansibility.

The new node is automatic except for the node. after the new node is added, it will automatically synchronize with the other nodes until the new node is consistent with the other nodes. if a node is removed, the other nodes will automatically update the group information and maintain the new group information automatically.

4. Highly flexible. There are single-master mode and multi-master mode, single-master mode will automatically select master, and all update operations will be carried out in main mode.

In multi-master mode, all server can be updated simultaneously.

Example

Mysql > show databases; mysql > SET SQL_LOG_BIN=0; # disable binary date to mysql > CREATE USER rpl_user@'%' IDENTIFIED BY 'Bgg+2019'; # create user mysql > GRANT REPLICATION SLAVE ON *. * TO rpl_user@'%'; # plus user rights mysql > FLUSH PRIVILEGES; # refresh data mysql > SET SQL_LOG_BIN=1; # enable binary date to mysql > CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='Szy+123en' FOR CHANNEL' group_replication_recovery' # when the user is configured, use the CHANGE MASTER TO statement to make SET SQL_LOG_BIN=0; copy the given credentials of the channel with group_replication_recovery for the next time the server needs to restore state from other members, issue the following command, replacing rpl_user and password mysql with the value directly used when creating the user > INSTALL PLUGIN group_replication SONAME 'group_replication.so'; # install group plug-in mysql > SHOW PLUGINS;mysql > SET GLOBAL group_replication_bootstrap_group=ON Open it on # master first, and then open it after opening group replication (not on slave) mysql > START GROUP_REPLICATION; # Open group replication mysql > SET GLOBAL group_replication_bootstrap_group=OFF; "what are the characteristics of mysql group replication"? thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.