ycg/mysql_web

mysql innodb问题 大神们看一下这是为啥

doncici opened this issue · 1 comments

版本: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

image

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

image

在通过mysqlshell 创建好集群后,把三台都加入了集群
image

现在问题就是,一台是online ,其他两台都是recovering的状态
其中online这一条自己是node,也是route

麻烦大神们看一下这个是什么问题呀。
感激不尽,困扰了两三天了

好像图片有点问题,集群状态如下,两个recovering

mysql-js> cluster.status();
{
"clusterName": "myCluster",
"defaultReplicaSet": {
"name": "default",
"primary": "db-node01:13306",
"status": "OK_NO_TOLERANCE",
"statusText": "Cluster is NOT tolerant to any failures. 2 members are not active",
"topology": {
"db-node01:13306": {
"address": "db-node01:13306",
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
},
"db-node02:13306": {
"address": "db-node02:13306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "RECOVERING"
},
"db-node03:13306": {
"address": "db-node03:13306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "RECOVERING"
}
}
}
}