Bug #86669 GR overrides auto_increment_increment=1 and auto_increment_offset=1

• Submitted: 13 Jun 2017 4:47
• Modified: 18 Sep 2017 11:36
• Reporter: Alfredo Kojima
• Status: Closed
• Category: MySQL Server: Group Replication
• Severity: S3 (Non-critical)
• Version: 8.0.2
• OS: Any
• CPU Architecture: Any

[13 Jun 2017 4:47] Alfredo Kojima

Description:
As a side-effect of WL#8445, configuration values of auto_increment_increment=1 and auto_increment_offset=1 will be overridden by the GR plugin and set to server_id and 7, respectively.

It is understood that this behavior is to prevent different group members from generating colliding auto_increment values; but that concern does not exist in single-primary mode.

How to repeat:
Configure GR, set auto_increment_increment=1 and auto_increment_offset=1 and enable single_primary mode, start GR.

Suggested fix:
Do not override auto_increment_increment and auto_increment_offset values if single_primary mode is enabled.

[18 Sep 2017 11:36] David Moss

Posted by developer:
 
Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 8.0.3 changelog:
The Group Replication plugin no longer sets auto_increment_increment and auto_increment_offset variables when single primary mode is active.