分布式集群(MySQL)
来源:互联网 发布:淘宝有名的网红店 编辑:程序博客网 时间:2024/06/07 10:25
一、保证MySQL环境的纯净
删除MySQL的目录里面的所有内容:(即/var/lib/mysql)
[root@server2 ~]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@server2 ~]# cd /var/lib/mysql
[root@server2 mysql]# lsauto.cnf ibdata1 mysql-bin.000003 mysql-bin.000009 private_key.pem testca-key.pem ib_logfile0 mysql-bin.000004 mysql-bin.000010 public_key.pemca.pem ib_logfile1 mysql-bin.000005 mysql-bin.000011 server2-slow.logclient-cert.pem mysql mysql-bin.000006 mysql-bin.000012 server-cert.pemclient-key.pem mysql-bin.000001 mysql-bin.000007 mysql-bin.index server-key.pemib_buffer_pool mysql-bin.000002 mysql-bin.000008 performance_schema sys[root@server2 mysql]# rm -fr *[root@server2 mysql]# ls
二、更改MySQL配置
[root@server2 mysql]# vim /etc/my.cnf
server-id=2gtid_mode=ONenforce_gtid_consistency=ONmaster_info_repository=TABLErelay_log_info_repository=TABLEbinlog_checksum=NONElog_slave_updates=ONlog_bin=binlogbinlog_format=ROW#transaction_write_set_extraction=XXHASH64#loose-group_replication_group_name="5fc57337-7a83-11e7-8b68-525400848d33"#loose-group_replication_start_on_boot=on#loose-group_replication_local_address="172.25.39.2:24901"#loose-group_replication_group_seeds="172.25.39.2:24901,172.25.39.3:24902,172.25.39.4:24903"#loose-group_replication_bootstrap_group=off#loose-group_replication_single_primary_mode=FALSE#loose-group_replication_enforce_update_everywhere_check=TRUE#group_replication_ip_whitelist='172.25.39.0/24,127.0.0.1/8'#group_replication_allow_local_disjoint_gtids_join=on
三、MySQL的重启与应用
1)更改密码登录mysql,修改my.cnf文件
[root@server2 mysql]# /etc/init.d/mysqld start
Initializing MySQL database: [ OK ]
Installing validate password plugin: [ OK ]
Starting mysqld: [ OK ]
[root@server2 mysql]# grep password /var/log/mysqld.log 2017-08-06T08:37:17.141549Z 1 [Note] A temporary password is generated for root@localhost: sje?EMetK8=%
[root@server2 mysql]# mysql -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 9Server version: 5.7.17-logCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set sql_log_bin=0;----以下操作不计入日志文件Query OK, 0 rows affected (0.00 sec)mysql> alter user root@localhost identified by 'Westos+007';---更改密码Query OK, 0 rows affected (0.00 sec)mysql> select uuid();----随机获取uuid+--------------------------------------+| uuid() |+--------------------------------------+| 5fc57337-7a83-11e7-8b68-525400848d33 |+--------------------------------------+1 row in set (0.00 sec)mysql> exitBye
2)获取uuid后更改配置,重启
[root@server2 mysql]# vim /etc/my.cnf
server-id=2gtid_mode=ONenforce_gtid_consistency=ONmaster_info_repository=TABLErelay_log_info_repository=TABLEbinlog_checksum=NONElog_slave_updates=ONlog_bin=binlogbinlog_format=ROWtransaction_write_set_extraction=XXHASH64loose-group_replication_group_name="5fc57337-7a83-11e7-8b68-525400848d33"loose-group_replication_start_on_boot=on(开启开机自启动)loose-group_replication_local_address="172.25.39.2:24901"loose-group_replication_group_seeds="172.25.39.2:24901,172.25.39.3:24902,172.25.39.4:24903"loose-group_replication_bootstrap_group=offloose-group_replication_single_primary_mode=FALSEloose-group_replication_enforce_update_everywhere_check=TRUE
[root@server2 mysql]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@server2 mysql]# mysql -pWestos+007mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.17-log MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set sql_log_bin=0;Query OK, 0 rows affected (0.00 sec)mysql> grant replication slave on *.* to mysql@"%" identified by 'Westos+007';----------授权用户Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> set sql_log_bin=1;Query OK, 0 rows affected (0.00 sec)mysql> change master to master_user='mysql',master_password="Westos+007" for channel 'group_replication_recovery';----说明组的用户密码Query OK, 0 rows affected, 2 warnings (1.54 sec)mysql> install plugin group_replication SONAME 'group_replication.so';--安装组插件Query OK, 0 rows affected (0.47 sec)mysql> show plugins;+----------------------------+----------+--------------------+----------------------+---------+| Name | Status | Type | Library | License |+----------------------------+----------+--------------------+----------------------+---------+| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL || mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL || sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL || PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL || CSV | ACTIVE | STORAGE ENGINE | NULL | GPL || MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL || INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_TEMP_TABLE_INFO | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL || MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL || MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL || ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL || BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL || partition | ACTIVE | STORAGE ENGINE | NULL | GPL || ngram | ACTIVE | FTPARSER | NULL | GPL || validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL || group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | GPL |+----------------------------+----------+--------------------+----------------------+---------+46 rows in set (0.00 sec)mysql> set global group_replication_bootstrap_group=ON;Query OK, 0 rows affected (0.00 sec)mysql> set global group_replication_ip_whitelist='172.25.39.0/24,127.0.0.1/8';组的成员网段Query OK, 0 rows affected (0.00 sec)mysql> start group_replication;Query OK, 0 rows affected (2.22 sec)mysql> select * from performance_schema.replication_group_members;查看组成员+---------------------------+--------------------------------------+-------------+-------------+--------------+| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |+---------------------------+--------------------------------------+-------------+-------------+--------------+| group_replication_applier | 740789c9-7a82-11e7-8160-525400848d33 | server2 | 3306 | ONLINE |+---------------------------+--------------------------------------+-------------+-------------+--------------+1 row in set (0.00 sec)mysql> create database test;Query OK, 1 row affected (0.06 sec)mysql> use test;Database changedmysql> create table t1 (c1 int primary key,c2 text not null);Query OK, 0 rows affected (1.39 sec)mysql> insert into t1 values (1,'lusi');Query OK, 1 row affected (0.50 sec)mysql> select * from t1;+----+------+| c1 | c2 |+----+------+| 1 | lusi |+----+------+1 row in set (0.00 sec)mysql> show binlog events;+---------------+-----+----------------+-----------+-------------+---------------------------------------+| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |+---------------+-----+----------------+-----------+-------------+---------------------------------------+| binlog.000001 | 4 | Format_desc | 2 | 123 | Server ver: 5.7.17-log, Binlog ver: 4 || binlog.000001 | 123 | Previous_gtids | 2 | 150 | || binlog.000001 | 150 | Stop | 2 | 169 | |+---------------+-----+----------------+-----------+-------------+---------------------------------------+3 rows in set (0.00 sec)mysql> exitBye
四、在其他两个节点配置相同如下:
[root@server3 ~]# /etc/init.d/mysqld stopStopping mysqld: [ OK ][root@server3 ~]# cd /var/lib/mysql[root@server3 mysql]# lsauto.cnf ibdata1 mysql-bin.000003 public_key.pem sysca-key.pem ib_logfile0 mysql-bin.000004 server3-relay-bin.000001 testca.pem ib_logfile1 mysql-bin.000005 server3-relay-bin.000002client-cert.pem mysql mysql-bin.index server3-relay-bin.indexclient-key.pem mysql-bin.000001 performance_schema server-cert.pemib_buffer_pool mysql-bin.000002 private_key.pem server-key.pem[root@server3 mysql]# rm -fr *[root@server3 mysql]# vim /etc/my.cnfserver-id=3gtid_mode=ONenforce_gtid_consistency=ONmaster_info_repository=TABLErelay_log_info_repository=TABLEbinlog_checksum=NONElog_slave_updates=ONlog_bin=binlogbinlog_format=ROWtransaction_write_set_extraction=XXHASH64loose-group_replication_group_name="5fc57337-7a83-11e7-8b68-525400848d33"loose-group_replication_start_on_boot=onloose-group_replication_local_address="172.25.39.3:24901"loose-group_replication_group_seeds="172.25.39.2:24901,172.25.39.3:24902,172.25.39.4:24903"loose-group_replication_bootstrap_group=offloose-group_replication_single_primary_mode=FALSEloose-group_replication_enforce_update_everywhere_check=TRUEgroup_replication_ip_whitelist='172.25.39.0/24,127.0.0.1/8'group_replication_allow_local_disjoint_gtids_join=on
[root@server3 mysql]# /etc/init.d/mysqld start
Initializing MySQL database: [ OK ]
Installing validate password plugin: [ OK ]
Starting mysqld: [ OK ]
[root@server3 mysql]# grep password /var/lo
local/ lock/ log/
[root@server3 mysql]# grep password /var/log/mysqld.log
2017-08-06T09:11:06.930834Z 1 [Note] A temporary password is generated for root@localhost: !yU)d9&Lx/Sl
[root@server3 mysql]# mysql -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.7.17-logCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set sql_log_bin=0;Query OK, 0 rows affected (0.00 sec)mysql> alter user root@localhost identified by 'Westos+007';Query OK, 0 rows affected (0.00 sec)mysql> grant replication slave on *.* to mysql@"%" identified by 'Westos+007';Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> set sql_log_bin=1;Query OK, 0 rows affected (0.00 sec)mysql> change master to master_user='mysql',master_password="Westos+007" for channel 'group_replication_recovery';Query OK, 0 rows affected, 2 warnings (1.38 sec)mysql> install plugin group_replication SONAME 'group_replication.so';Query OK, 0 rows affected (0.19 sec)mysql> set global group_replication_ip_whitelist='172.25.39.0/24,127.0.0.1/8';Query OK, 0 rows affected (0.00 sec)mysql> set global group_replication_allow_local_disjoint_gtids_join=on;Query OK, 0 rows affected (0.00 sec)mysql> show plugins;+----------------------------+----------+--------------------+----------------------+---------+| Name | Status | Type | Library | License |+----------------------------+----------+--------------------+----------------------+---------+| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL || mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL || sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL || PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL || CSV | ACTIVE | STORAGE ENGINE | NULL | GPL || MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL || INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_TEMP_TABLE_INFO | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL || MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL || MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL || ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL || BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL || partition | ACTIVE | STORAGE ENGINE | NULL | GPL || ngram | ACTIVE | FTPARSER | NULL | GPL || validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL || group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | GPL |+----------------------------+----------+--------------------+----------------------+---------+46 rows in set (0.00 sec)mysql> uninstall plugin validate_password;Query OK, 0 rows affected (0.05 sec)mysql> start group_replication;Query OK, 0 rows affected (2.90 sec)
[root@server4 mysql]# mysql -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.7.17-logCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> set sql_log_bin=0;Query OK, 0 rows affected (0.00 sec)mysql> grant replication slave on *.* to mysql@"%" identified by 'Westos+007';ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> alter user root@localhost identified by 'Westos+007';Query OK, 0 rows affected (0.00 sec)mysql> grant replication slave on *.* to mysql@"%" identified by 'Westos+007';Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> set sql_log_bin=1;Query OK, 0 rows affected (0.00 sec)mysql> change master to master_user='mysql',master_password="Westos+007" for channel 'group_replication_recovery';Query OK, 0 rows affected, 2 warnings (0.38 sec)mysql> install plugin group_replication SONAME 'group_replication.so';Query OK, 0 rows affected (0.46 sec)mysql> show plugins;+----------------------------+----------+--------------------+----------------------+---------+| Name | Status | Type | Library | License |+----------------------------+----------+--------------------+----------------------+---------+| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL || mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL || sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL || PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL || CSV | ACTIVE | STORAGE ENGINE | NULL | GPL || MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL || INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_TEMP_TABLE_INFO | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL || INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL || MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL || MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL || ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL || BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL || partition | ACTIVE | STORAGE ENGINE | NULL | GPL || ngram | ACTIVE | FTPARSER | NULL | GPL || validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL || group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | GPL |+----------------------------+----------+--------------------+----------------------+---------+46 rows in set (0.01 sec)mysql> set global group_replication_ip_whitelist='172.25.39.0/24,127.0.0.1/8';Query OK, 0 rows affected (0.00 sec)mysql> start group_replication;ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.mysql> set global group_replication_allow_local_disjoint_gtids_join=on;Query OK, 0 rows affected (0.00 sec)mysql> stop group_replication;Query OK, 0 rows affected (11.63 sec)mysql> uninstall plugin validate_password;Query OK, 0 rows affected (0.05 sec)mysql> start group_replication;Query OK, 0 rows affected (2.90 sec)mysql> exitBye
当所有配置全部做好,那么在server2上显示便是这样的了:
mysql> select * from performance_schema.replication_group_members;+---------------------------+--------------------------------------+-------------+-------------+--------------+| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |+---------------------------+--------------------------------------+-------------+-------------+--------------+| group_replication_applier | 2de90de6-7a87-11e7-ab7d-525400b17b31 | server3 | 3306 | ONLINE || group_replication_applier | 54890852-7a87-11e7-ab58-52540054927a | server4 | 3306 | ONLINE || group_replication_applier | 740789c9-7a82-11e7-8160-525400848d33 | server2 | 3306 | ONLINE |+---------------------------+--------------------------------------+-------------+-------------+--------------+3 rows in set (0.00 sec)
这个时候就可以去测试啦~
无论在哪个主机上写,都可以同时同步到其他主机……
- 分布式集群(MySQL)
- Mysql分布式集群主从
- MySQL分布式集群搭建
- MySQL分布式集群搭建
- MySQL分布式集群搭建
- MySQL分布式集群搭建
- MySQL分布式集群搭建
- mysql 分布式集群方案
- mysql分布式集群实现原理
- MySQL分布式集群之MyCAT
- mysql分布式集群部署方案
- MySQL分布式集群之MyCAT(一)简介(修正)
- MySQL分布式集群之MyCAT(三)rule的分析
- MySQL分布式集群之MyCAT调优初探(四)
- 分布式 集群(优秀)
- 京东MYSQL分布式数据库:集群系统技术交流
- 分布式数据库集群中间件------为什么选择MySQL
- MySQL之——分布式集群
- 九.多项目构建
- ARM TrustZone技术简介 -- 3 (BL31 Secure Monitor简介)
- HDU 5952 Counting Cliques dfs + 思维
- Jzzhu and Cities CodeForces
- require/include/include_once/require_once()的区别
- 分布式集群(MySQL)
- Android——文本控件——Button
- 牧佑--FileBufferDemo----
- SignalR如何搭建SelfHost服务端(C#)
- java实现归并排序
- centos优化
- Qt代码创建分隔条
- 牧佑---bufferReader---
- 超神线段树 山海经