On Tue, Nov 15, 2011 at 04:44:23PM +0800, Yan Chunlu wrote:
> I would like to implement two master db with even-odd id sharding. in
> mysql it is fairly easy by using the configuration:
>
> auto_increment_offset = 1
> auto_increment_increment = 2
>
>
> but I have searched a lot didn't find anything related to this, some users
> doing this via trigger like "rubyrep".
>
> is there an easy way to do this? thanks!
Why not adjust the underlying sequences to have different start values
and to advance by 2?
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca