[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: |
|
||||
| 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 |