-
Notifications
You must be signed in to change notification settings - Fork 26
Description
版本:mysql-5.7.26
环境 centos 7.3
一共三台机器,搭建innodb集群
配置文件如下:
[mysqld]
datadir = /usr/local/mysql/data
socket = /usr/local/mysql/socket/mysql.sock
port=13306
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
#复制框架
server_id=3
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
log_bin=binlog
log_slave_updates=ON
binlog_format=ROW
master_info_repository=TABLE
relay_log_info_repository=TABLE
#组复制设置
#server必须为每个事务收集写集合,并使用XXHASH64哈希算法将其编码为散列
transaction_write_set_extraction=XXHASH64
#告知插件加入或创建组命名,UUID
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
#server启动时不自启组复制,为了避免每次启动自动引导具有相同名称的第二个组,所以设置为OFF。
loose-group_replication_start_on_boot = OFF
#告诉插件使用IP地址,端口24901用于接收组中其他成员转入连接
loose-group_replication_local_address="192.168.101.196:24901"
#启动组server,种子server,加入组应该连接这些的ip和端口;其他server要加入组得由组成员同意
loose-group_replication_group_seeds="192.168.101.193:24901,192.168.101.195:24901,192.168.101.196:24901"
loose-group_replication_bootstrap_group=off
使用MGR的单主模式
loose-group_replication_single_primary_mode = on
disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,CSV,ARCHIVE
report_port=13306
loose-group_replication_allow_local_disjoint_gtids_join=on
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.101.193 db-node01
192.168.101.195 db-node02
192.168.101.196 db-node03
192.168.101.193 db-route01
在通过mysqlshell 创建好集群后,把三台都加入了集群
现在问题就是,一台是online ,其他两台都是recovering的状态
其中online这一条自己是node,也是route
麻烦大神们看一下这个是什么问题呀。
感激不尽,困扰了两三天了