Re: Replications oddity.

2010-01-15 Thread Brent Clark
On 15/01/2010 11:54, Krishna Chandra Prajapati wrote: Hi Brent, I believe you missed log_slave_updates component on 2 and 1. You have to enable binary logs + log_slave_updates on 2 and 1. http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates Th

Re: Replications oddity.

2010-01-15 Thread Krishna Chandra Prajapati
Hi Brent, I believe you missed log_slave_updates component on 2 and 1. You have to enable binary logs + log_slave_updates on 2 and 1. http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates Thanks, Krishna On Fri, Jan 15, 2010 at 3:07 PM, Brent Clar

RE: Replications...

2002-09-09 Thread Jeremy Tinley
>> This handles part of the problem but a true load balanced master >> solution is needed. There's no real advantage in spending 5, 10 or >> $20,000 on a failover master if you can't load balance and the spare >> will just sit idle. > Sure there is. If your master blows up, you have a spare wait

Re: Replications...

2002-09-09 Thread Jeremy Zawodny
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote: > This handles part of the problem but a true load balanced master > solution is needed. There's no real advantage in spending 5, 10 or > $20,000 on a failover master if you can't load balance and the spare > will just sit idle. Sure

RE: Replications...

2002-09-09 Thread Jeremy Tinley
upon distance behind the master. After a slave falls "so far" behind, it's removed until it catches back up. More thoughts are always welcome. -J -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 07, 2002 10:51 PM To: Sam Przysw

Re: Replications...

2002-09-08 Thread Sam Przyswa
Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > >> >http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm >> > >> >Just make B a slave of A, C a slave of B, and A a slave of C. >> >> This is a good approach. > >Except that it's fragile. One machine can go down and "break the

Re: Replications...

2002-09-08 Thread Jeremy Zawodny
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote: > Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > > > >> Does multi-master mean master to master, imagine you have 3 MySQL > >> servers, A, B, C, with a load balancer in front end, if we make an > >> update on A, is it possible to replicate/

Re: Replications...

2002-09-08 Thread Sam Przyswa
Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > >On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote: >> Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: >> > >> >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: >> >> Hi, >> >> >> >> Does the next MySQL 4.x version will support cross r

Re: Replications...

2002-09-07 Thread Jeremy Zawodny
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote: > Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: > > > >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: > >> Hi, > >> > >> Does the next MySQL 4.x version will support cross replications > >> between several master servers in

Re: Replications...

2002-09-07 Thread Sam Przyswa
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: > >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: >> Hi, >> >> Does the next MySQL 4.x version will support cross replications >> between several master servers in cluster ? > >Multi-master replication works as well in 4.x as it does in 3.

Re: Replications...

2002-09-07 Thread Jeremy Zawodny
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote: > Hi, > > Does the next MySQL 4.x version will support cross replications > between several master servers in cluster ? Multi-master replication works as well in 4.x as it does in 3.23.xx. Jeremy -- Jeremy D. Zawodny | Perl, Web