Announcement

Announcement Module
Collapse
No announcement yet.

Best Setup for Slave of Master-Master Replication?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Best Setup for Slave of Master-Master Replication?

    I have in production a 2 master (master-master) replication, and a slave of the master. Currently, the slave is master of one server, so it looks like this:

    Master1<----->Master2
    |
    |
    |
    Slave1

    What happens, is if I have to switch to master2 for writes, the slave never receives the updates, so it essentially is "out of sync". What is the best way to overcome this problem?

    Thanks,
    Michael

  • #2
    You probably forgot to set "log-slave-updates" on Master1, see http://dev.mysql.com/doc/refman/5.0/en/replication-options.h tml

    Hope this helps,
    Martin

    Comment


    • #3
      Why, I think you're right! I'll make sure, and let you know.

      Thanks bunches,
      Michael

      Comment

      Working...
      X