Thanks Lixun. How is the replicate-[do|ignore]-[table|database] functionality handled with multiple masters where I only want specific tables from specific masters so that the feeds don't clobber each other? These don't appear to be settable in the CHANGE MASTER statement, and I cannot find any documentation on how to set them unambiguously in the config file. Any hints? Gordan On 11/29/2012 03:54 PM, Lixun Peng wrote:
Hi Gordan,
I have tried to replicate from mysql5.5 to MariaDB 10.0 by multi-source replication feature, I have not found any problems, it runs well.
Thanks, Lixun
Sent from my iPhone
On 2012-11-29, at 下午11:38, Gordan Bobic<gordan@bobich.net> wrote:
On 11/29/2012 02:53 PM, Sergei Golubchik wrote:
Hi, Gordan!
On Nov 29, Gordan Bobic wrote:
Hi,
I have a need for replicating data from multiple masters (independent data going to different tables). ... So what I was hoping to do is write something based on the existing MySQL code since at least that should "just work". The problem is - I am completely unfamiliar with MySQL internals, and I haven't found any function level API documentation. So, would anyone here be kind enough to point me at the specific bits of code in MySQL that handle: ... Any pointers would be greatly appreciated. If somebody here is already undertaking a similar effort, I would rather like to lend a hand.
You might want to look at https://kb.askmonty.org/en/multi-source-replication/
That looks _exactly_ like what I was looking for. I'll take the 10.0 Alpha for a spin and try it out.
Many thanks. :)
BTW, should I expect any particular issues when replicating from MySQL 5.5 Cluster to MariaDB 10?
Gordan
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp