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: 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

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 report!

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 new files

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, 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

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 30 new bin-log files every

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]:1303# ls -1 www2

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

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 and DB-B such that DB

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 this

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 following

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:

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,