pxc日常维护

 

1.导入到pxc集群的文件不能包含有lock tables

/opt/pxc/pxc5729/bin/mysql -h localhost -uroot -pmysql -P 23306 -S /opt/pxc/pxc5729/data/mysql.sock -D db_test</soft/app_message_0_20200521095850

ERROR 1105 (HY000) at line 49: Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE <table> WITH READ LOCK/FOR EXPORT with pxc_strict_mode = ENFORCING
解决办法:
--skip-add-locks --skip-lock-tables