Hi Gordan, I think you can found the answer from doc : https://kb.askmonty.org/en/multi-source-replication/
like this: set @@default_master_connection=''; show status like 'Slave_running'; set @@default_master_connection='other_connection'; show status like 'Slave_running'; but some parameters only can write in my.cnf and can't be changed in running, we have not implement them temporarily. Thanks, Lixun On Fri, Nov 30, 2012 at 7:46 PM, Gordan Bobic <[email protected]> wrote: > Hi Monty, > > > "Lixun" == Lixun Peng<[email protected]> writes: >>>>>>> >>>>>> >> Lixun> Hi Gordan, >> Lixun> I'm not changed the replicate-[do|ignore]-[table|**database] >> functionality >> Lixun> code, so I think it should work for all slave threads, but it >> can't specify >> Lixun> each master to use specific filter. >> >> Yes, the replication filters are global for now. >> >> It would probably be 2-3 days of work to make these per master. >> >> The main questions is only how to define this in the config file. >> We could probably use the same thing we use for key buffers: >> >> master_name.replicate-do-db=..**. >> >> Do you want some information of how to develop this or do you think >> you can find someone to sponsor this? >> > > Thanks for the info. At the moment, I'm interested in some pointers on how > to develop this at the moment. > > On a related note, is there anything like the sql_slave_skip_counter > variable implemented on a per-master basis? Or is this something else that > would need separating out? I know I could just change the relevant master > info file (carefully) with the new log position, but that's somewhat > inconvenient and requires restarting the server. > > Gordan > -- 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
