Hi Gordan, I'm not changed the replicate-[do|ignore]-[table|database] functionality code, so I think it should work for all slave threads, but it can't specify each master to use specific filter.
On Fri, Nov 30, 2012 at 12:55 AM, Gordan Bobic <[email protected]> wrote: > 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 > -- Senior MySQL Developer @ Taobao.com Mobile Phone: +86 18658156856 (Hangzhou) Gtalk: penglixun(at)gmail.com Twitter: http://www.twitter.com/plinux Blog: http://www.penglixun.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
