> 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 &
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.