Mysql.Standard Slave Replication into Xtradb Cluster causes Node Issues

[pchan]

Hello,

I have 3 node xtradb cluster (node.a , node.b, node.c) – all running the latest 5.6 version.
I also have a standard mysql 5.5 (server.d) which serves as a mysql replication master to node.a(which is a mysql.slave) in the cluster.

When i start standard mysql replication on node.a(mysql.slave) in the cluster , replication starts successfully replicating data from
master server.d but after replication starts i notice that any data that gets written to node.b or node.c does not get written to node.a
but any data that gets written to node.a does get written to both node.b and node.c

I can provide conf files if needed - but wanted to see if anyone has experienced similar issues with mysql.standard
replication into a single node apart of a xtradb cluster?

thanks P.:eek:

[pchan]

This seems like a similar issue below.

---

http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/12402-node-connected-but-not-replicating [COLOR=#252C2F]

[COLOR=#252C2F] So after doing a lot of investigation and finding a very very hidden forum post on a google code page i found that the reason i was having issues was the “replicate-do-db=” variables i had on my slave node that was replicating from a production system.

This was only allowing those particular tables to be replicated by galera (isn’t galera supposed to be independent of MySQL???)

Anyway having here at least means that if someone else runs into the problem they will be able to fix it them self

---

** I am using “replicate-do-table” on PXC node.a slave to Mysql.Standard Master server.d **

[pchan]

Have not tested - yet waiting for a full SST on node.a before test

– but below looks like its pretty much what im experiencing…

[TABLE=“width: 939”]
[TR]
[TD]
[/TD]
[TD=“align: left”]Jay Janssen [/TD]
[TD=“align: right”] [CENTER][/CENTER]
[CENTER][/CENTER]

		10/29/12
		[/TD]
	[/TR]
 [/TABLE]

[CENTER][/CENTER]

I think it’s a mistake for Galera to obey the standard replication filters, it makes architectures that use both Galera and asynchronous replication have inter-dependent configuration, and it makes the cluster fail in non-obvious ways.
For example, I very rarely would want to limit replication filtering within my cluster, but I very well may want to replicate only certain DBs into my cluster on a single async replication stream (i.e., on a single node). However, woe to you if you add any ‘replicate-do’ filters to a configuration on one of your nodes.

If Galera needs replication filters internally (which I’m somewhat dubious of), they should be wsrep_% settings, and be completely independent of async replication.

Discuss. Jay Janssen, Senior MySQL Consultant, Percona Inc.
http://about.me/jay.janssen
Percona Live in London, UK Dec 3-4th: http://www.percona.com/live/london-2012/

[watanesachin]

hi,

can you please provide your conf file