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

I. Environment

MGR 8.0.17 Three-node, roidb1, roidb2, roidb3

II. Testing

1. Default group_replication_member_weight=502. Set the weight of roidb2 to 100. Set global group_replication_member_weight=100. 3. Close the main library and shutdown. 4. View the main library, and roidb2 automatically fails over as the main mysql> select member_host,member_role from replication_group_members;+-------------| member_host | member_role |+-------------+-------------+| roidb2 | PRIMARY || roidb1 | SECONDARY |+-------------+-------------+2 rows in set (0.00 sec)

III. Knowledge Points

Set this slave parameter to control the order of single-master mode switching, provided that the version of MGR multi-node is unified. group_replication_member_weightProperty ValueCommand-Line Format --group-replication-member-weight=#Introduced 8.0.2System Variable group_replication_member_weightScope GlobalDynamic YesSET_VAR Hint Applies NoType IntegerDefault Value 50Minimum Value 0Maximum Value 100

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.