aduit组件导致clone失败问题处理

mysql> SET GLOBAL clone_valid_donor_list = '172.16.88.21:3307';
Query OK, 0 rows affected (0.00 sec)

mysql> CLONE INSTANCE FROM 'donor_clone'@'172.16.88.21':3307 IDENTIFIED BY '*********' ;
ERROR 3870 (HY000): Clone Donor plugin AUDIT is not active in Recipient.
mysql> SET GLOBAL clone_valid_donor_list = '172.16.88.20:3307';
ERROR 4031 (HY000): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.
No connection. Trying to reconnect...
Enter password:
Connection id: 298
Current database: *** NONE ***

Query OK, 0 rows affected (4.11 sec)

mysql> CLONE INSTANCE FROM 'donor_clone'@'172.16.88.20':3307 IDENTIFIED BY 'Root00--' ;


目标端：
mysql> CLONE INSTANCE FROM 'donor_clone'@'172.16.88.21':3307 IDENTIFIED BY 'Root00--' ;
ERROR 3870 (HY000): Clone Donor plugin AUDIT is not active in Recipient.

源端：
mysql> show variables like '%audit_json_file%';

+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| audit_json_file | ON |
| audit_json_file_bufsize | 1 |
| audit_json_file_flush | OFF |
| audit_json_file_retry | 60 |
| audit_json_file_sync | 0 |
+-------------------------+-------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%audit%';
+-------------+----------------+---------------+-------------+---------------------+--------------------+------------------------+------------------+--------------------------------------------------------------+----------------+-------------+
| PLUGIN_NAME | PLUGIN_VERSION | PLUGIN_STATUS | PLUGIN_TYPE | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY | PLUGIN_LIBRARY_VERSION | PLUGIN_AUTHOR | PLUGIN_DESCRIPTION | PLUGIN_LICENSE | LOAD_OPTION |
+-------------+----------------+---------------+-------------+---------------------+--------------------+------------------------+------------------+--------------------------------------------------------------+----------------+-------------+
| AUDIT | 1.0 | ACTIVE | AUDIT | 4.1 | libaudit_plugin.so | 1.9 | Musarubra US LLC | AUDIT plugin, creates a file mysql-audit.log to log activity | GPL | ON |
+-------------+----------------+---------------+-------------+---------------------+--------------------+------------------------+------------------+--------------------------------------------------------------+----------------+-------------+
1 row in set (0.00 sec)

mysql>

解决（目标端）
上传文件至/data/mysql/install/lib/plugin/libaudit_plugin.so
mysql> system chown -R mysql.mysql /data/

mysql> INSTALL PLUGIN audit SONAME 'libaudit_plugin.so';
Query OK, 0 rows affected (2.09 sec)

mysql> SET GLOBAL clone_valid_donor_list = '172.16.88.22:3307';
Query OK, 0 rows affected (0.00 sec)

mysql> CLONE INSTANCE FROM 'donor_clone'@'172.16.88.22':3307 IDENTIFIED BY '*********' ;