0

I'm planning the set-up of a secondary datacenter for an existing system that runs in a single facility and uses master-master MySQL replication between two machines. I plan to add two machines to the second facility to make four machines in total. I'd like to be able to treat any machine as a master (only one at a time) to workaround machine failure.

I'm keen to avoid circular replication i.e. A=>B=>C=>D=>A since a single machine outage could affect replication to machines downstream. Ideally the replication would look like:

A <=> B
^     ^
1     2
v     v
C <=> D

MySQL can't natively have more than one replication master. Are there any third-party replication agents that could be used in positions 1 and 2 to relay queries from the binlogs of one machine to another, filtering appropriately by server-id to avoid loops?

1 Answer 1

0

Why don't you check out Tungsten Enterprise. It has robust replication and filtering capabilities.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .