I have a database which I want to replicate to an InnoDB Cluster, and then failover the server to the InnoDB cluster.
I was wondering if there are any issues replicating to an InnoDB cluster.
The reason why I ask is I setup a MySQL to replicate to an InnoDB Cluster of 2 nodes (just for testing). I create a database and table on the Master, it replicates to cluster node1, and the same database and table appear on cluster node2. When I insert data on the Master, it goes to node1, but doesn't go to node2. When I insert data into node1, it goes into node2.
It sort of makes me think the data is getting committed on node1, but not propagating to node2 when its done through replication.
Would any problem cause this? Or is this a bug? I am using Ubuntu 12.4 and the latest Percona download for it.
> I have a database which I want to replicate to an InnoDB Cluster, and > then
> failover the server to the InnoDB cluster.
> I was wondering if there are any issues replicating to an InnoDB > cluster.
> The reason why I ask is I setup a MySQL to replicate to an InnoDB > Cluster
> of 2 nodes (just for testing).
> I create a database and table on the Master, it replicates to cluster
> node1, and the same database and table appear on cluster node2.
> When I insert data on the Master, it goes to node1, but doesn't go to
> node2.
> When I insert data into node1, it goes into node2.
> It sort of makes me think the data is getting committed on node1, but > not
> propagating to node2 when its done through replication.
> Would any problem cause this? Or is this a bug?
> I am using Ubuntu 12.4 and the latest Percona download for it.
> Thanks!
> Mark
Hi,
Check that you have set log_slave_updates.
Regards,
Alex
-- Alexey Yurchenko,
Codership Oy, www.codership.com Skype: alexey.yurchenko, Phone: +358-400-516-011
Thanks!
I thought it was something simple.
I didn't think the cluster replication was connect to log_slave_updates,
but I am sure I will find the notes somewhere that you have to do that.
Works good.