Comments on How to configure MySQL Multi-Master Replication on Oracle Linux

This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. Please note that even though the configuration is made under Oracle Linux, yet the steps and configuration are mainly the same to CentOS and Red Hat Linux.

1 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Joerg Bruehe

Hi!

I'm missing a configuration setting which I consider essential:

"log_slave_updates = 1" should be set on both sides.

If you don't do that, you will run into (at least) two problems:

1) If you ever need the binlogs for anything, especially point-in-time recovery, you must take them from both hosts.

2) If you (later) add a slave to the setup, it will receive only some of the changes.

Regards,

Jörg