WL#14539: GR: Specify the UUID used to log View_change_log_event

Affects: Server-8.0   —   Status: Complete

EXECUTIVE SUMMARY

This worklog shall provide a option for DBAs/operators to configure the UUID that will be used by Group Replication when logging View_change_log_event.

USER STORIES

As MySQL DBA, I want to :

  • distinguish the GTIDs assigned to transactions from the ones assigned to automatic group operations, more precisely Group Replication members joining which logs a View_change_log_event, with a group GTID on the binary log.

Scope

The work described in this document does:

  • implement group replication variable group_replication_view_change_uuid with uuid that will be used on group replication View_change_log_event on the binary log

  • implement validation on variable group_replication_view_change_uuid, shall be different from server uuid, group replication name and uuid assigned to anonymous transactions[1].

High Level Description

When a member joins a group in Group Replication, it logs a View_change_log_event, with Group Replication group name uuid.

We will introduce an option that will use a different uuid when logging View_change_log_event on binary log.

[1] ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html