[MDEV-32566] auto_increment_offset docu is confusing Created: 2023-10-24  Updated: 2023-12-13

Status: Open
Project: MariaDB Server
Component/s: Documentation, Replication
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Oli Sennhauser Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: auto_increment, documentation, replication

Issue Links:
PartOf

 Description   

In the documentation for auto_increment_offset the comment is confusing and is wrong:

"Should be smaller than auto_increment_increment, except when both variables are 1 (default setup)."

This is technically wrong. In a Master/Master set-up auto_increment_increment is typically set to 2 and auto_increment_offset is set to 1 and 2 (0 is not allowed according to the docu).

So correct would be: "Should be smaller or equal than auto_increment_increment, ...".

To make the docu more useful a good example would help. For example:

"Frequent seen settings for auto_increment_increment is 2 for both masters on a master/master set-up."

and

" Frequent seen settings for auto_increment_offset is 1 on one master and 2 on the other master on a master/master set-up"



 Comments   
Comment by Oli Sennhauser [ 2023-10-24 ]

Sorry, I forgot the link: https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#auto_increment_increment

Generated at Thu Feb 08 10:32:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.