Mysql – Galera Cluster not syncing from a standalone Mysql Server

galeramigrationMySQL

I had setup a 3 node Galera cluster in production network. And I am replicating the data from a Standalone MySQL Server to one of the galera node(node1) through master slave replication.

I can replicate data within the cluster. But the problem is the data replicated from the Standalone server to the node1 is not replicating across the node2 and node3. I can see the exact async replica of MySQL standalone server in node1.

Thanks in advance.

 -----(Master)        -----
 MySQL --- >          Node1(Slave)
 -----                -----
                   /         \
                  |           |
                -----        -----
                Node2        Node3
                -----        -----

Best Answer

The question comment guess by jerichorivera was absolutely right:

log-slaves-updates on node1 enabled?

..but you seem to have misunderstood.

log_bin=/var/log/mysql/mysql-bin

(or whatever file basename) to enable writing the binary logs a slave can read from. However, this alone lets the node write empty binary logs (a size of a few hundred bytes) if it is slave on its own. To act as intermediate master, also set

log_slave_updates

in the my.cnf.

Related Question