Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MySQL Orchestrator does not support new semi-sync variables introduced in MySQL 8.0.26

Description

MySQL 8.0.26 introduced new plugins for semi-synchronous replication that resulted in the following variable name changes:

  • rpl_semi_sync_slave_enabled is replaced by rpl_semi_sync_replica_enabled

  • rpl_semi_sync_slave_trace_level is replaced by rpl_semi_sync_replica_trace_level

  • rpl_semi_sync_master_wait_for_slave_count is replaced by rpl_semi_sync_source_wait_for_replica_count

  • rpl_semi_sync_master_enabled is replaced by rpl_semi_sync_source_enabled

  • rpl_semi_sync_master_timeout is replaced by rpl_semi_sync_source_timeout

  • rpl_semi_sync_master_trace_level is replaced by rpl_semi_sync_source_trace_level

  • rpl_semi_sync_master_wait_point is replaced by rpl_semi_sync_source_wait_point

This was reported upstream by as #1416 - Support new semi-sync variables in MySQL 8.0.26. A preliminary patch is proposed here: Fix enabling/disabling semi-sync on MySQL 8.0.26

As we include MySQL Orchestrator in our distribution, we need to ensure that it supports the latest version of Percona Server.

Environment

None

Smart Checklist

Activity

Show:

Kamil Holubicki August 3, 2022 at 5:49 PM

This is the PR containing the fix for this issue:

https://github.com/percona/orchestrator/pull/2

Kamil Holubicki December 3, 2021 at 3:00 PM

Status variables used by Orchestrator which are affected as well:
Rpl_semi_sync_master_status -> Rpl_semi_sync_source_status
Rpl_semi_sync_master_clients -> Rpl_semi_sync_source_clients
Rpl_semi_sync_slave_status -> Rpl_semi_sync_replica_status
 
Preliminary patch attached will not work as expected, because it does not consider the following:
1. After the upgrade 8.0.25 -> 8.0.26, the old plugin will be still installed, and old variables will be still available (however, the patch will switch to the new naming convention)
2. patch touches only enable/disable source/replica part, other variables are not fixed, so for example 

will not report semi-sync replication used.

Done

Details

Assignee

Reporter

Time tracking

2d 4h 30m logged46m remaining

Components

Fix versions

Affects versions

Priority

Smart Checklist

Created November 25, 2021 at 8:04 AM
Updated March 5, 2024 at 11:16 AM
Resolved December 27, 2021 at 10:35 AM