List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:August 3 2011 10:38am
Subject:Re: does mysql support master to master replication
View as plain text  
> Any mysql instance can replicate from any other as long as binary logging
> is enabled on the designated master.
> Two instances can replicate from one another yes, but precautions must be
> taken especially in the case of active-active configuration.

Works perfectly indeed, to name the precautions to take:

1, Set proper server_id's

2. When using auto-incrementing fields, set the auto_increment_offset & 
auto_increment_increment.

3. If you write on 2 servers simultaneously, UNIQUE indexes can break 
replication. If your application requires both enforcing them AND writing to 
both servers, look at clustering instead.
-- 
Rik Wasmus
Thread
does mysql support master to master replicationAngela liu3 Aug
  • Re: does mysql support master to master replicationFeng He3 Aug
  • Re: does mysql support master to master replicationJon Siebert3 Aug
  • Re: does mysql support master to master replicationJon Siebert3 Aug
    • Re: does mysql support master to master replicationClaudio Nanni3 Aug
      • Re: does mysql support master to master replicationRik Wasmus3 Aug