新建的一个2节点PXC MySQL集群在导入数据时出现报错:
ERROR 1105 (HY000): Percona-XtraDB-Cluster prohibits use of DML command on a table (jeecmsv93.org_depart_funct_bak) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER
这是由于PXC每个表必须要有主键,如果没有主键,可能造成集群中每个节点的data page里的数据不一样。
默认的配置选项PXC Strict Mode设置为ENFORCING,如果验证失败拒绝操作并抛出错误。可以修改为PERMISSIVE,如果失败,记录警告并继续正常运行。
SET GLOBAL pxc_strict_mode=PERMISSIVE;
再次导入,数据导入成功,提示TRIGGER错误:
[root@internetdb1:/home/data]mysql -uinspur -ppasswd --default-character-set=UTF8 jeecmsv93 < jeecmsv93.sql mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1419 (HY000) at line 81716: You do not have the SUPER privilege (you *might* want to use the less safe log_bin_trust_function_creators variable)
查看数据文件81716行:
CREATE TRIGGER triggerCom