共計 5216 個字符，預計需要花費 14 分鐘才能閱讀完成。
怎樣進行 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 插入一些模擬數據
mysql CREATE DATABASE test;
Query OK, 1 row affected (0.00 sec)
mysql use test;
Database changed
mysql CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL);
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO t1 VALUES (1, Luis
Query OK, 1 row affected (0.01 sec)
3 往集群里面添加數據庫實例
3.1 修改第二臺數據庫配置文件
[client]
port = 24802
socket = /home/data/mydata/3307/mysql.sock
[mysqld]
port = 24802
socket = /home/data/mydata/3307/mysql.sock
basedir = /home/data/mysql
datadir = /home/data/mydata/3307
pid-file = /home/data/mydata/3307/mysql.pid
##group replication####
server_id = 2
gtid_mode =ON
enforce_gtid_consistency = ON
master_info_repository = TABLE
relay_log_info_repository=TABLE
binlog_checksum = NONE
log_slave_updates = ON
log_bin=binlog
binlog_format=ROW
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name = 77e497e2-c59a-11e6-9a68-525400159185
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= 192.168.1.14:34062
loose-group_replication_group_seeds= 192.168.1.247:34061,192.168.1.14:34062,192.168.1.242:34063
loose-group_replication_bootstrap_group=off
loose-group_replication_single_primary_mode=false
loose-group_replication_enforce_update_everywhere_checks=TRUE
3.2 啟動數據庫進行配置
SET SQL_LOG_BIN=0;
CREATE USER rpl_user@ %
GRANT REPLICATION SLAVE ON *.* TO rpl_user@ % IDENTIFIED BY rpl_pass
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER= rpl_user , MASTER_PASSWORD= rpl_pass FOR CHANNEL group_replication_recovery
3.3 安裝引擎，加入 gp 組
mysql INSTALL PLUGIN group_replication SONAME group_replication.so
mysql START GROUP_REPLICATION;
mysql SELECT * FROM performance_schema.replication_group_members;
+—————————+————————————–+—————————+————-+————–+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+—————————+————————————–+—————————+————-+————–+
| group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |
| group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |
+—————————+————————————–+—————————+————-+————–+
注意：與 2 操作相比少了兩個步驟，千萬別執行那兩個步驟！那兩個步驟是在搭建 gp 初始化才需要執行的兩個步驟
3.4 檢驗數據
mysql show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+——————–+
5 rows in set (0.00 sec)
mysql select * from test.t1;
+—-+——+
| c1 | c2 |
+—-+——+
| 1 | Luis |
+—-+——+
1 row in set (0.00 sec)
4 模擬數據庫 down 機
關閉 247 數據庫
mysql SELECT * FROM performance_schema.replication_group_members;
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
| group_replication_applier | | | NULL | OFFLINE |
1 row in set (0.00 sec)
mysql start GROUP_REPLICATION; ### 重新打開即可
Query OK, 0 rows affected (3.50 sec)
mysql SELECT * FROM performance_schema.replication_group_members;
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
| group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |
| group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |
2 rows in set (0.00 sec)
mysql stop GROUP_REPLICATION;
Query OK, 0 rows affected (8.47 sec)
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 | OFFLINE |
1 row in set (0.00 sec)
mysql start GROUP_REPLICATION;
Query OK, 0 rows affected (5.49 sec)
mysql SELECT * FROM performance_schema.replication_group_members;
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
| group_replication_applier | 29a03be3-cccf-11e6-9dac-00163e2d2c29 | interface.test.haodai.com | 24802 | ONLINE |
| group_replication_applier | 550a7cbd-ccce-11e6-829a-a2d813521b2e | sh347 | 3307 | ONLINE |
2 rows in set (0.00 sec)
至此，數據庫集群組搭建完畢！
關于怎樣進行 MySQL5.7.17- Group Replication 搭建問題的解答就分享到這里了，希望以上內容可以對大家有一定的幫助，如果你還有很多疑惑沒有解開，可以關注丸趣 TV 行業資訊頻道了解更多相關知識。
