Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "what are the characteristics of mysql group replication". The editor shows you the operation process through an actual case, and the operation method is simple, fast and practical. I hope this article "what are the characteristics of mysql group replication" can help you solve the problem.

Application scenario

1. Flexible replication environment of database. Group replication can flexibly increase and decrease the number of database instances in the cluster.

2. High availability of database environment.

When most of the servers in the cluster are available, group replication allows the database instance to go down, and the entire database service is available.

3. Replace the traditional master-slave replication structure in the database environment.

Example

Vim / etc/mysql.cnf first delete the content added in the previous experiment. Then add the following thing: server_id=1 the first node gtid_mode=ONenforce_gtid_consistency=ONmaster_info_repository=TABLErelay_log_info_repository=TABLEbinlog_checksum=NONE # turn off binlog check log_slave_updates=ONlog_bin=binlogbinlog_format=ROW# group replication depends on the line-based replication format transaction_write_set_extraction=XXHASH64loose-group_replication_group_name= "uuid checked out" # # see / var/lib/mysql/auto.cnfloose-group_replication_start_on_boot=offloose-group_replication_local_address= "172.25.254.1 iploose-group_replication_group_seeds= 33061" whether the current node's loose-group_replication_bootstrap_group=off## plug-in "172.25.254.1" 33061172.25.254.2 "loose-group_replication_bootstrap_group=off## plugin automatically boots This option usually needs to be off off. It only needs to be enabled by the node that initiates the replication of the group, and only starts once. If it is on, a group with the same name will be generated the next time it is started. Brain fissure may occur. Loose-group_replication_ip_whitelist= "127.0.0.1172.25.254.0 loose-group_replication_enforce_update_everywhere_checks=ONloose-group_replication_single_primary_mode=OFF#" two lines after which are the parameters for turning on multi-master mode. This is the end of the content about "what are the characteristics of mysql replication". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.