[MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group.

error:

mysql> start group_replication;
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

reason:

节点包含了非group内的事务。

mysql>  show master status\G
*************************** 1. row ***************************
             File: mysql-bin.000002
         Position: 463
     Binlog_Do_DB: 
 Binlog_Ignore_DB: 
Executed_Gtid_Set: b464e627-5878-11eb-87de-0050562dda68:1
1 row in set (0.00 sec)

解决：

mysql> RESET MASTER;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='12345678' FOR CHANNEL 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> start group_replication;
Query OK, 0 rows affected (3.50 sec)