List:Replication« Previous MessageNext Message »
From:Maxim Veksler Date:February 9 2010 10:23am
Subject:Re: Send binlogs immediately?
View as plain text  
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 ?
Thread
Send binlogs immediately?Alper Oguz29 Jan
  • Re: Send binlogs immediately?Shawn Green29 Jan
    • Re: Send binlogs immediately?Alper Oguz8 Feb
      • Re: Send binlogs immediately?Mats Kindahl8 Feb
        • Re: Send binlogs immediately?Alper Oguz9 Feb
          • Re: Send binlogs immediately?Maxim Veksler9 Feb
  • Re: Send binlogs immediately?Tyler Poland29 Jan
    • Re: Send binlogs immediately?Rick James29 Jan