Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
doncici opened this issue Jan 10, 2020 · 1 comment
Open

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

doncici opened this issue Jan 10, 2020 · 1 comment

Comments

@doncici
Copy link

doncici commented Jan 10, 2020

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

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

@doncici
Copy link
Author

doncici commented Jan 10, 2020

好像图片有点问题,集群状态如下,两个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"
}
}
}
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant