May 13 2017

mgr要求innodb的表且有主键

mgr使用仅支持InnoDB表,并且每张表一定要有一个主键,用于做write set的冲突检测;

dbadmin@a 02:02:35>create table t(i int);
Query OK, 0 rows affected (0.03 sec)
dbadmin@a 02:02:53>insert into t values(1);
ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin.

查看alert.log
2017-12-13T06:03:00.082515Z 31 [ERROR] Plugin group_replication reported: ‘Table t does not have any PRIMARY KEY. This is not compatible with Group Replication’

MGR的限制

仅支持InnoDB表,并且每张表一定要有一个主键,用于做write set的冲突检测;
必须打开GTID特性,二进制日志格式必须设置为ROW,用于选主与write set
COMMIT可能会导致失败,类似于快照事务隔离级别的失败场景
目前一个MGR集群最多支持9个节点
不支持外键于save point特性,无法做全局间的约束检测与部分部分回滚
二进制日志不支持binlog event checksum



Copyright 2019. All rights reserved.

Posted 2017年5月13日 by ucjmh in category "mysql

Leave a Reply

Your email address will not be published. Required fields are marked *