← Back to team overview

maria-developers team mailing list archive

Re: API Documentaion for Replication Features


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?


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

Follow ups