On Tue, Feb 9, 2010 at 11:11 AM, Alper Oguz <alper2@stripped> wrote:
> Mats Kindahl wrote On 08-02-2010 22:28:
>>
>> You seem to be mixing up auto-increment-increment and
>> auto-increment-offset.
>
> Yes, I've fixed like this:
>
> server1:
> auto-increment-increment = 10
> auto-increment-offset = 1
>
> server2:
> auto-increment-increment = 10
> auto-increment-offset = 2
>
> thank you very much
>
Why such big jumps?
Whats wrong with:
server1:
auto-increment-increment = 2
auto-increment-offset = 1
server2:
auto-increment-increment = 2
auto-increment-offset = 2
This way you have server1 generating 1,3,5,7... and server2 auto
increment the values: 2,4,6,8...
If you will have 3 servers your setting could be
server1:
auto-increment-increment = 3
auto-increment-offset = 1
server2:
auto-increment-increment = 3
auto-increment-offset = 2
server2:
auto-increment-increment = 3
auto-increment-offset = 3
HTH.
>
> --
> Alper Oguz
> alper2@stripped
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=1
>
>
--
Cheers,
Maxim Veksler
"Free as in Freedom" - Do u GNU ?
