[摘要]+----+------+1 row in set (0.00 sec)mysql>然后在db2/db3上执行inert操作，则拒绝，因为db2、db3为readonlymysql> i...
+----+------+
1 row in set (0.00 sec)
mysql>
然后在db2/db3上执行inert操作，则拒绝，因为db2、db3为readonly
mysql> insert into t1 select 2,'b';
ERROR 1290 (HY000): The MySQL server isrunning with the --super-read-only option so it cannot execute this statement
mysql>
8，问题记录
8.1问题记录一
MySQL窗口报错：
ERROR 3092 (HY000): The server is notconfigured properly to be an active member of the group. Please see moredetails on error log.
后台ERROR LOG报错：
[ERROR] Plugin group_replication reported:'This member has more executed transactions than those present in the group.
Local transactions: f16f7f74-c283-11e6-ae37-fa163ee40410:1 > Grouptransactions: 3c992270-c282-11e6-93bf-fa163ee40410:1,
aaaaaa:1-5'
[ERROR]Plugin group_replication reported: 'The member contains transactions notpresent in the group. The member will now exit the group.'
[Note] Plugin group_replication reported: 'Toforce this member into the group you can use the group_replication_allow_local_disjoint_gtids_joinoption'
【解决办法】：
根据提示打开group_replication_allow_local_disjoint_gtids_join选项，mysql命令行执行：
mysql> set globalgroup_replication_allow_local_disjoint_gtids_join=ON;
再执行开启组复制：
mysql> start group_replication;
Query OK, 0 rows affected (7.89 sec)
mysql>
8.2 问题记录二RECOVERING
在db1上查询集群组成员
mysql> SELECT * FROM performance_schema.replication_group_members;
+---------------------------+--------------------------------------+----------------------+-------------+--------------+
关键词：详细介绍MySQL Group Replication[Single-Primary Mode]的搭建部署过程