Shulou(Shulou.com)06/01 Report--

I. description

MGR 8.0.17 three-node cluster. After an abnormal restart of the cluster, a node is abnormal, and the problem encountered in the process of clone. The error message is as follows:

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.

Second, problem analysis

Understand English, do not come up to du Niang, clone system configuration: innodb_data_file_path: the number of files of the recipient: 1 less than the number of contributors. Next, look at the database parameters:

-- recipient mysql > show variables like 'innodb_data_file_path' +-+ | Variable_name | Value | +-+ | innodb_data _ file_path | ibdata1:12M:autoextend | +-+ 1 row in set (0.01sec)-- contributor 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)

It is true that the number of files is different, so we need to adjust the parameters of the recipient, and then restart the database.

III. Solutions

Modify parameters, restart database, re-clone

[root@roidb3 log] # grep "innodb_data" / zxdata/my3311/etc/my.cnfinnodb_data_home_dir = / zxdata/my3311/datainnodb_data_file_path = ibdata1:12M;ibdata2:50M:autoextend [root@roidb3 log] # mysql > shutdown Query OK 0 rows affected (0.00 sec) mysql > exitBye [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] #-cloning completed Restart group replication mysql > start group_replication Query OK, 0 rows affected (5.07 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.