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<[email protected]> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~maria-developers >> More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
