怎樣進(jìn)行MySQL5.7.17-GroupReplication搭建

怎樣進(jìn)行MySQL5.7.17- Group Replication搭建，針對(duì)這個(gè)問(wèn)題，這篇文章詳細(xì)介紹了相對(duì)應(yīng)的分析和解答，希望可以幫助更多想解決這個(gè)問(wèn)題的小伙伴找到更簡(jiǎn)單易行的方法。

目前創(chuàng)新互聯(lián)公司已為上千多家的企業(yè)提供了網(wǎng)站建設(shè)、域名、雅安服務(wù)器托管、網(wǎng)站托管、企業(yè)網(wǎng)站設(shè)計(jì)、市北網(wǎng)站維護(hù)等服務(wù)，公司將堅(jiān)持客戶導(dǎo)向、應(yīng)用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶和合作伙伴齊心協(xié)力一起成長(zhǎng)，共同發(fā)展。

背景：

  • 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插入一些模擬數(shù)據(jù)

  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 往集群里面添加數(shù)據(jù)庫(kù)實(shí)例

  1. 3.1修改第二臺(tái)數(shù)據(jù)庫(kù)配置文件

    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啟動(dòng)數(shù)據(jù)庫(kù)進(jìn)行配置

    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操作相比少了兩個(gè)步驟，千萬(wàn)別執(zhí)行那兩個(gè)步驟！那兩個(gè)步驟是在搭建gp 初始化才需要執(zhí)行的兩個(gè)步驟

  2. 3.4檢驗(yàn)數(shù)據(jù)

    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 模擬數(shù)據(jù)庫(kù)down機(jī)

  1. 關(guān)閉247數(shù)據(jù)庫(kù)

  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;  ###重新打開(kāi)即可

  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)

至此，數(shù)據(jù)庫(kù)集群組搭建完畢！

關(guān)于怎樣進(jìn)行MySQL5.7.17- Group Replication搭建問(wèn)題的解答就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，如果你還有很多疑惑沒(méi)有解開(kāi)，可以關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道了解更多相關(guān)知識(shí)。

網(wǎng)站標(biāo)題：怎樣進(jìn)行MySQL5.7.17-GroupReplication搭建
當(dāng)前地址：http://muchs.cn/article2/ihghoc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供外貿(mào)建站、服務(wù)器托管、外貿(mào)網(wǎng)站建設(shè)、App設(shè)計(jì)、面包屑導(dǎo)航、網(wǎng)站內(nèi)鏈

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)

網(wǎng)站建設(shè)網(wǎng)站維護(hù)公司