|
先介绍一下，我使用的是mysqlshell 8.4.0(从MYSQL官网下载的），我的操作系统是CENTOS 7.6， ldd --version ldd (GNU libc) 2.17 Copyright (C) 2012 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Written by Roland McGrath and Ulrich Drepper. c.add_instance("192.168.200.136:3306") The safest and most convenient way to provision a new instance is through automatic clone provisioning, which will completely overwrite the state of '192.168.200.136:3306' with a physical snapshot from an existing cluster member. To use this method by default, set the 'recoveryMethod' option to 'clone'. The incremental state recovery may be safely used if you are sure all updates ever executed in the cluster were done with GTIDs enabled, there are no purged transactions and the new instance contains the same GTID set as the cluster or a subset of it. To use this method by default, set the 'recoveryMethod' option to 'incremental'. Incremental state recovery was selected because it seems to be safely usable. Validating instance configuration at 192.168.200.136:3306... This instance reports its own address as 192.168.200.136:3306 Instance configuration is suitable. NOTE: Group Replication will communicate with other members using '192.168.200.136:3306'. Use the localAddress option to override. * Checking connectivity and SSL configuration... A new instance will be added to the InnoDB Cluster. Depending on the amount of data on the cluster this might take from a few seconds to several hours. Adding instance to the cluster... Monitoring recovery process of the new cluster member. Press ^C to stop monitoring and let it continue in background. State recovery already finished for '192.168.200.136:3306' Traceback (most recent call last): File "<string>", line 1, in <module> RuntimeError: Cluster.add_instance: Unsupported GR member role value: ARBITRATOR 虽然MYSHELL不支持检测仲裁节点。后面我试一下，也无法删除这个仲裁节点。  但用SELECT查询时，却可以看到仲裁节点。 我认为是不是只有用社区的greatsql-shell-8.0.32-25-glibc2.28-x86_64.tar.xz才支持MYSHELL方式添加仲裁节点。 |
|
|
yejr
2024-5-26 16:13:52
| |
|
|
reddey
2024-5-26 16:48:41
| |
|
一个学艺不精的国产数据库爱好者
|
||
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
