怎樣進行MySQL5.7.17- Group Replication搭建，針對這個問題，這篇文章詳細介紹了相對應的分析和解答，希望可以幫助更多想解決這個問題的小伙伴找到更簡單易行的方法。

目前創新互聯公司已為上千多家的企業提供了網站建設、域名、雅安服務器托管、網站托管、企業網站設計、市北網站維護等服務，公司將堅持客戶導向、應用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶和合作伙伴齊心協力一起成長，共同發展。

背景：

• mysql>INSTALL PLUGIN group_replication SONAME 'group_replication.so'

• mysql> SHOW PLUGINS;
  +----------------------------+----------+--------------------+----------------------+-------------+
  | Name                       | Status   | Type               | Library              | License     |
  +----------------------------+----------+--------------------+----------------------+-------------+
  | binlog                     | ACTIVE   | STORAGE ENGINE     | NULL                 | PROPRIETARY |
  
  (...)
  
  | group_replication          | ACTIVE   | GROUP REPLICATION  | group_replication.so | PROPRIETARY |
  +----------------------------+----------+--------------------+----------------------+-------------+

  mysql> SET GLOBAL group_replication_bootstrap_group=ON;
  mysql> START GROUP_REPLICATION;
  mysql> SET GLOBAL group_replication_bootstrap_group=OFF;
  mysql> SELECT * FROM performance_schema.replication_group_members;
  +---------------------------+--------------------------------------+-------------+-------------+--------------+
  | CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
  +---------------------------+--------------------------------------+-------------+-------------+--------------+
  | group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347       |        3307 | ONLINE       |
  +---------------------------+--------------------------------------+-------------+-------------+--------------+
  1 row in set (0.00 sec)
  
  

2.4插入一些模擬數據

1. mysql> CREATE DATABASE test;

2. Query OK, 1 row affected (0.00 sec)

4. mysql> use test;

5. Database changed

6. mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL);

7. Query OK, 0 rows affected (0.00 sec)

9. mysql> INSERT INTO t1 VALUES (1, 'Luis');

10. Query OK, 1 row affected (0.01 sec)

3 往集群里面添加數據庫實例

1. 3.1修改第二臺數據庫配置文件

1. [client]

2. port = 24802

3. socket = /home/data/mydata/3307/mysql.sock

6. [mysqld]

7. port = 24802

8. socket = /home/data/mydata/3307/mysql.sock

9. basedir = /home/data/mysql

10. datadir = /home/data/mydata/3307

11. pid-file = /home/data/mydata/3307/mysql.pid

12. ##group replication####

13. server_id= 2

14. gtid_mode =ON

15. enforce_gtid_consistency = ON

16. master_info_repository = TABLE

17. relay_log_info_repository=TABLE

18. binlog_checksum = NONE

19. log_slave_updates = ON

20. log_bin=binlog

21. binlog_format=ROW

23. transaction_write_set_extraction=XXHASH64

24. loose-group_replication_group_name = "77e497e2-c59a-11e6-9a68-525400159185"

25. loose-group_replication_start_on_boot=off

26. loose-group_replication_local_address="192.168.1.14:34062"

27. loose-group_replication_group_seeds="192.168.1.247:34061,192.168.1.14:34062,192.168.1.242:34063"

28. loose-group_replication_bootstrap_group=off

29. loose-group_replication_single_primary_mode=false

30. loose-group_replication_enforce_update_everywhere_checks=TRUE

1. 3.2啟動數據庫進行配置

1. SET SQL_LOG_BIN=0;

2. CREATE USER rpl_user@'%';

3. GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';

4. SET SQL_LOG_BIN=1;

5. CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery'

1. 3.3 安裝引擎，加入gp組
   

1. mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';

2. mysql> START GROUP_REPLICATION;

3. mysql> SELECT * FROM performance_schema.replication_group_members;

4. +---------------------------+--------------------------------------+---------------------------+-------------+--------------+

5. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

6. +---------------------------+--------------------------------------+---------------------------+-------------+--------------+

7. | group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |

8. | group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |

9. +---------------------------+--------------------------------------+---------------------------+-------------+--------------+

10. 注意：與2操作相比少了兩個步驟，千萬別執行那兩個步驟！那兩個步驟是在搭建gp 初始化才需要執行的兩個步驟

2. 3.4檢驗數據

1. mysql> show databases;

2. +--------------------+

3. | Database |

4. +--------------------+

5. | information_schema |

6. | mysql |

7. | performance_schema |

8. | sys |

9. | test |

10. +--------------------+

11. 5 rows in set (0.00 sec)

13. mysql> select * from test.t1;

14. +----+------+

15. | c1 | c2 |

16. +----+------+

17. | 1 | Luis |

18. +----+------+

19. 1 row in set (0.00 sec)

4 模擬數據庫down機

1. 關閉247數據庫

2. mysql> SELECT * FROM performance_schema.replication_group_members;

4. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

6. | group_replication_applier | | | NULL | OFFLINE |

8. 1 row in set (0.00 sec)

10. mysql> start GROUP_REPLICATION;  ###重新打開即可

11. Query OK, 0 rows affected (3.50 sec)

13. mysql> SELECT * FROM performance_schema.replication_group_members;

15. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

17. | group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |

18. | group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |

20. 2 rows in set (0.00 sec)

22. mysql> stop GROUP_REPLICATION;

23. Query OK, 0 rows affected (8.47 sec)

25. mysql> SELECT * FROM performance_schema.replication_group_members;

27. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

29. | group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | OFFLINE |

31. 1 row in set (0.00 sec)

33. mysql> start GROUP_REPLICATION;

34. Query OK, 0 rows affected (5.49 sec)

36. mysql> SELECT * FROM performance_schema.replication_group_members;

38. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

40. | group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |

41. | group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |

43. 2 rows in set (0.00 sec)

至此，數據庫集群組搭建完畢！

關于怎樣進行MySQL5.7.17- Group Replication搭建問題的解答就分享到這里了，希望以上內容可以對大家有一定的幫助，如果你還有很多疑惑沒有解開，可以關注創新互聯行業資訊頻道了解更多相關知識。

網站標題：怎樣進行MySQL5.7.17-GroupReplication搭建
當前地址：http://www.2m8n56k.cn/article2/ihghoc.html

成都網站建設公司_創新互聯，為您提供外貿建站、服務器托管、外貿網站建設、App設計、面包屑導航、網站內鏈

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：[email protected]。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯