我正在尝试使用组复制功能设置MySQL HA。来自 https://dev.mysql.com/doc/refman/8.0/en/group-replication.html 的转介指示。多次阅读并尝试所有步骤，以确保正确遵循所有步骤，但始终遵循相同的消息。 问题解决后，我还将添加第 3 和第 4 个节点。一旦在Windows上完成此设置，我将在Linux上重复，然后是生产(Linux(
在组中添加第二个成员时的错误日志
一(
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.
二( 第二个 MySQL 数据库服务器的服务器日志
2020-01-05T10:45:13.734994Z 0 [ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: 1aaf20e2-2fa5-11ea-a9f1-040e3c9a1821:1 > Group transactions: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,
f28d474c-2fa1-11ea-8748-040e3c9a1821:1'
2020-01-05T10:45:13.744824Z 0 [ERROR] [MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'
(三(( 第一个 MySQL 数据库服务器的服务器日志
2020-01-05T10:13:07.033377Z 11 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2020-01-05T10:45:15.735673Z 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: L-156179931:3326'
第二个成员具有主服务器上不存在的事务，并且无法加入组。
您应该尝试了解导致事务的原因，在每个命令后检查GTID_EXECUTED(SELECT @@global.gtid_executed;(并查看罪魁祸首。