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@bobich.net> 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@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


_______________________________________________
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



--
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