MGR CLONE ERROR 3869 (HY000)

一、描述
MGR 8.0.17 三節(jié)點集群，集群異常重啟后某個節(jié)點異常，在做clone的過程遇到的問題。報錯信息如下：

mysql> CLONE INSTANCE FROM 'donor_clone_user'@'196.55.7.36':3311 IDENTIFIED BY 'password';
ERROR 3869 (HY000): Clone system configuration: innodb_data_file_path: Recipient file count: 1 is less than Donor file count.

二、問題分析

看懂英文，不要上來就度娘，克隆的系統(tǒng)配置：innodb_data_file_path：接受者文件數(shù):1少于貢獻者的文件數(shù)。接下來查看數(shù)據(jù)庫參數(shù)：

--接受者
mysql> show variables like 'innodb_data_file_path';
+-----------------------+------------------------+
| Variable_name         | Value                  |
+-----------------------+------------------------+
| innodb_data_file_path | ibdata1:12M:autoextend |
+-----------------------+------------------------+
1 row in set (0.01 sec)

--貢獻者
mysql> show variables like 'innodb_data_File_path';
+-----------------------+------------------------------------+
| Variable_name         | Value                              |
+-----------------------+------------------------------------+
| innodb_data_file_path | ibdata1:12M;ibdata2:50M:autoextend |
+-----------------------+------------------------------------+
1 row in set (0.01 sec)

確實文件數(shù)不一樣，那么我們就需要把接受者的參數(shù)調(diào)整一下，然后重啟數(shù)據(jù)庫。

三、解決方法
修改參數(shù)，重啟數(shù)據(jù)庫，重新克隆

[root@roidb3 log]# grep "innodb_data" /zxdata/my3311/etc/my.cnf
innodb_data_home_dir               = /zxdata/my3311/data
innodb_data_file_path              = ibdata1:12M;ibdata2:50M:autoextend
[root@roidb3 log]# 

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@roidb3 log]# 
[root@roidb3 log]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/zxdata/my3311/etc/my.cnf &
[1] 3911
[root@roidb3 log]# 2020-01-12T03:14:30.338253Z mysqld_safe Logging to '/zxdata/my3311/log/error.log'.
2020-01-12T03:14:30.374790Z mysqld_safe Starting mysqld daemon with databases from /zxdata/my3311/data

[root@roidb3 log]#

--克隆完成，重啟組復制
mysql> start group_replication;
Query OK, 0 rows affected (5.07 sec)