maria-developers team mailing list archive

[Lixun Peng <penglixun@xxxxxxxxx>]

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 <gordan@xxxxxxxxxx> 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<gordan@xxxxxxxxxx>  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@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~maria-developers
> >> More help   : https://help.launchpad.net/ListHelp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> 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