mysql 组复制集群环境下执行insert 插入数据报错: [Err] 3098 - The table does not comply with the requirements by an external plugin.
报错原因: 通过建表查看到该表引擎为myisam, 通过语句修改表引擎后修复
修改语句:
alter table 库名.表名 engine=innodb;
后续工作:
- 通过mysql 配置文件添加下面一行,限制新建表的引擎类型
disabled_storage_engines=“MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY” - 添加zabbix监控,监控sql如下,触发条件是查询接口不为0 :
SELECT count(table_name) FROM information_schema.tables WHERE table_schema not in ('mysql','information_schem