Advanced MySQL 8

Combining group replication versions

In a scenario where we have multiple versions of MySQL installed on members, there are some constraints for the group replication to work, and all versions should be compatible in the same group.

You can identify the members and their MySQL version in the same member view:

mysql> select MEMBER_HOST, MEMBER_PORT, MEMBER_VERSION from performance_schema.replication_group_members;+-------------+-------------+----------------+ | member_host | member_port | member_version | +-------------+-------------+----------------+ | slavedb.com | 3306 | 8.0.13 | +-------------+-------------+----------------+

There are some rules when different major MySQL versions are used:

• You cannot join a member to a group when it ...