Details
Minor
Description
Apart from both of these variables not allowed to be 0, auto-increment-offset should not be allowed to be greater than auto-increment-increment as that would by definition create an invalid scenario.
For startup, this could be checked after the config/cmdline params are all processed - this to prevent chucking an error in case they're specified with offset first and increment second.
For live changes, it could be checked on the spot - although I'd question the sense/need of changing such params live.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
I'd reckon you can get duplicates, as the # you get at is no longer within the safe bounds that can't be touched by another master?
Not sure about your formula re how auto-inc-offset/increment work.
Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
can this request please get triaged and classified? as in, accepted as a bug report or feature request? thanks
Launchpad bug id: 682967
>> Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
>> I'd reckon you can get duplicates, as the # you get at is no longer within the safe bounds that can't be touched by another master?
I'm not sure how much danger is there in reality, since "If the value of auto_increment_offset is greater than that of auto_increment_increment, the value of auto_increment_offset is ignored." (http://dev.mysql.com/doc/refman/5.1/en/replication-options-master.html#sysvar_auto_increment_offset)
Anyway, valid or not, it's a FR, not a bug, moving to Tasks.
Re: [Bug 682967] [NEW] auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
Hi, Arjen!
>
> auto-increment-offset should not be allowed to be greater than
> auto-increment-increment as that would by definition create an invalid
> scenario.
It is not at all obvious to me that this situation "should not" be
allowed, and that it creates "by definition an invalid scenario".
Somehow I cannot derive A < B from the formula X = A + N*B.
Regards,
Sergei