Re: Another replication question

2010-12-29 Thread Sharl.Jimh.Tsin
really really a little noisy. 这下犯众怒了吧,招人烦了~ 囧 Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/29 杨涛涛 : > Ok, I'll not post any more!  Just reading! > > > David Yeung, In China, Beijing. > My First Blog:http://yueliangdao0608.cublog.cn > My Second Blog:http://yu

Re: Another replication question

2010-12-28 Thread 杨涛涛
Ok, I'll not post any more! Just reading! David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 在 2010年12月23日 下午8:14,Johan De Meersman 写道: > Glad to hear I'm not the only one annoy

Re: Another replication question

2010-12-23 Thread Johan De Meersman
Glad to hear I'm not the only one annoyed :-) I've plonked him in the meantime. 2010/12/23 Jorg W Young > > This guy has been saying nothing meaningful on this list, but > advertise his blog everywhere. > Just be shame. He should be kicked out from the list. > > Jorg. > > 2010/12/23 杨涛涛 : > > Th

Re: Another replication question

2010-12-23 Thread Jorg W Young
This guy has been saying nothing meaningful on this list, but advertise his blog everywhere. Just be shame. He should be kicked out from the list. Jorg. 2010/12/23 杨涛涛 : > This way is very well, but it has to do lots of human work. > David Yeung, In China, Beijing. > My First Blog:http://yuelian

Re: Another replication question

2010-12-22 Thread 杨涛涛
This way is very well, but it has to do lots of human work. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/11/24 Rolando Edwards > MySQL, by design, cannot do that. > >

RE: Another replication question

2010-11-24 Thread Gavin Towey
inal Message- From: Rolando Edwards [mailto:redwa...@logicworks.net] Sent: Wednesday, November 24, 2010 6:53 AM To: Machiel Richards; mysql mailing list Subject: RE: Another replication question MySQL, by design, cannot do that. A DB Server can be Master to Multiple Slaves Think of the CHANGE

RE: Another replication question

2010-11-24 Thread Rolando Edwards
MySQL, by design, cannot do that. A DB Server can be Master to Multiple Slaves Think of the CHANGE MASTER TO command. Its internal design cannot accommodate reading from more than one set of relay logs. You could attempt something convoluted, like 1) STOP SLAVE; 2) CHANGE MASTER TO 3) START SLA

Re: Another replication question

2010-11-24 Thread Johan De Meersman
On Wed, Nov 24, 2010 at 2:50 PM, John Daisley wrote: > Are you sure mmm couldn't handle this? > That, I don't know, but MySQL's internal replication mechanisms definitely don't support multimaster slaves. If mmm does it, it'll likely be akin to the offline log shipping I proposed earlier. > May

Re: Another replication question

2010-11-24 Thread John Daisley
Johan, Are you sure mmm couldn't handle this? Machiel, Maybe you could `simulate` the whole thing using some federated tables on one of the slave instances? Then although you are replicating to 3 instances you could access all the data from a single instance? Regards John On 24 November 2010

Re: Another replication question

2010-11-24 Thread Johan De Meersman
You can't, plain and simple - a slave may only have a single master. You could script binlog shipping, I suppose, if you're so inclined, and apply them on the slave. No guarantees about it working as expected, though. On Wed, Nov 24, 2010 at 1:20 PM, Machiel Richards wrote: > Hi All > >I am

Re: another replication question..

2003-06-05 Thread Martin Waite
Hi Ross, On Wed, 2003-06-04 at 16:44, Ross Simpson wrote: > I have another question that doesn't seem to be addressed in the mysql > manual. > > Does any sort of locking occur while a slave is updating it's local > databases? Can I still read any/all tables while this process is > occurring? >