Re: MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.

2002-09-10 Thread Paul DuBois
At 12:09 +0400 9/10/02, Artem V. Ryabov wrote: >Hello Victoria, > > As far as I see bug of muliple log files still not fixed regardless > of last change in 4.0.4: > 'FLUSH LOGS removed numerical extension for all future update logs.' This bugfix affects the update log, not the binary update

MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.

2002-09-10 Thread Artem V. Ryabov
Hello Victoria, As far as I see bug of muliple log files still not fixed regardless of last change in 4.0.4: 'FLUSH LOGS removed numerical extension for all future update logs.' -- Best regards, Artem mailto:[EMAIL PROTECTED] sql query

Re: Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-09-02 Thread Victoria Reznichenko
Artem, Monday, September 02, 2002, 12:44:30 PM, you wrote: AVR> Thursday, August 15, 2002, you wrote: AVR>>> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR>>> this servers create endless loop, with creating new binary log file AVR>>> on each iteration. (about 30 ne

Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-09-02 Thread Artem V. Ryabov
Hello Victoria, Thursday, August 15, 2002, you wrote: AVR>> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR>> this servers create endless loop, with creating new binary log file AVR>> on each iteration. (about 30 new files every second in my case) > Thanks for bug r

Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-08-15 Thread Victoria Reznichenko
Artem, Thursday, August 15, 2002, 12:06:07 PM, you wrote: AVR> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR> this servers create endless loop, with creating new binary log file AVR> on each iteration. (about 30 new files every second in my case) Thanks for bug r

MySQL 4.0.2, 4.0.3 replication circle broken.

2002-08-15 Thread Artem V. Ryabov
Hello mysql, In case of repliacation circle (A->B->A) query 'flush log' on any of this servers create endless loop, with creating new binary log file on each iteration. (about 30 new files every second in my case) -- Best regards, Artem mailto:[EMAIL PROTECTED]

Re: MySQL 4.0.2 replication circle broken?

2002-08-14 Thread Artem V. Ryabov
Hello all, I was check up 4.0.3 (from the Development Source Tree), bug still exist. >>Description: aor> I use replication circle (A->B, B->A) with 3.23.51 - all ok. aor> But I got problem, when upgrade both my servers to 4.0.2. aor> Mysqld create

MySQL 4.0.2 replication circle broken?

2002-08-12 Thread artem
>Description: I use replication circle (A->B, B->A) with 3.23.51 - all ok. But I got problem, when upgrade both my servers to 4.0.2. Mysqld create 30 new bin-log files every second at both servers: --- [www2:/opt/mysql-dev/var]:13

RE: Re: Replication Circle

2002-08-04 Thread Oren Zeev-Ben-Mordehai
Hello, I also plan to use two servers such that each is a master for the other. A -> B B -> A Unless you tell me otherwise, the log-server-updates option will not be used. Seems to work in a small test I've conducted. In fact this setup will be used for reasons of high availability. (rather t

Re: Replication Circle

2002-07-31 Thread DL Neil
Bhavin, > Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B Can't help you with the replication question - but here is a replication answer - have everyone in your installation repeat after me: "the DBA is your master"! (and say it again...and again...) =dn List fodder

Re: Replication Circle

2002-07-31 Thread Jeremy Zawodny
On Tue, Jul 30, 2002 at 10:35:06PM -0700, Bhavin Vyas wrote: > Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B > is the slave. However, I also want to make DB-B the master and DB-A it's > slave so that if I have to fail over to DB-B then DB-A is automatically > followin

Re: Replication Circle

2002-07-31 Thread Roger Baklund
* Bhavin Vyas > Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B > is the slave. However, I also want to make DB-B the master and DB-A it's > slave so that if I have to fail over to DB-B then DB-A is automatically > following the changes. It doesn't seem probable that thi

Re: Replication Circle

2002-07-31 Thread Gerald R. Jensen
No can do. Replication is one-way. You can, however, have multiple Slaves. - Original Message - From: "Bhavin Vyas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 12:35 AM Subject: Replication Circle Hello, Is there a way to have DB-A

Replication Circle

2002-07-30 Thread Bhavin Vyas
Hello, Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B is the slave. However, I also want to make DB-B the master and DB-A it's slave so that if I have to fail over to DB-B then DB-A is automatically following the changes. It doesn't seem probable that this is possible,