MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.
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 log. It has no effect on replication. -- Best regards, Artem mailto:[EMAIL PROTECTED] sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.2, 4.0.3 replication circle broken.
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! I tested it yesterday and also have got thousands of log files :( 4.0.3 Already out, but bug is still exists. Does anybody something to fix this bus? -- Best regards, Artem mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: MySQL 4.0.2, 4.0.3 replication circle broken.
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 every second in my case) Thanks for bug report! I tested it yesterday and also have got thousands of log files :( AVR 4.0.3 Already out, but bug is still exists. AVR Does anybody something to fix this bus? Hi! No, this bug is not fixed yet. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2, 4.0.3 replication circle broken.
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] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.2, 4.0.3 replication circle broken.
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 report! I tested it yesterday and also have got thousands of log files :( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.2 replication circle broken?
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 second at both servers: aor --- aor [www2:/opt/mysql-dev/var]:1303# ls -1 www2-bin.* | wc -l aor2268 aor [www2:/opt/mysql-dev/var]:1306# l www2-bin.00* aor -rw-rw1 mysqlmysql 137 Aug 12 16:31 www2-bin.001 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.002 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.003 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.004 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.005 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.006 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.007 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.008 aor -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.009 aor [www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001 aor # at 4 aor #020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0. aor 2-alpha-log created 020812 16:29:30 aor # at 79 aor #020812 16:31:13 server id 2 log_pos 79Rotate to www2-bin.002 pos: 4 aor # at 118 aor #020812 16:31:13 server id 1 log_pos 118 Stop aor [www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002 aor # at 4 aor #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4 aor # at 43 aor #020812 16:31:13 server id 1 log_pos 43Stop aor [www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003 aor # at 4 aor #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4 aor # at 43 aor #020812 16:31:13 server id 1 log_pos 43Stop aor [www2:/opt/mysql-dev/var]:1308# aor -- aor and so on. aor Will be fixed this error in 4.0.3? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Artem Ryabov Organization: MySQL support: none Synopsis: too many bin-log files Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.2-alpha (Source distribution) Environment: aor System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown aor Architecture: i686 aor Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc aor GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs aor gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) aor Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' aor LIBC: aor lrwxrwxrwx1 root root 11 Nov 25 2000 /lib/libc.so.6 - libc-2.2.so aor -rwxr-xr-x1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so aor -rw-r--r--1 root root 24498288 Jan 11 2001 /usr/lib/libc.a aor -rw-r--r--1 root root 178 Jan 11 2001 /usr/lib/libc.so aor configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared --prefix=/opt/mysql-dev --with-charset=cp1251 -- Best regards, Artemmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2 replication circle broken?
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-bin.* | wc -l 2268 [www2:/opt/mysql-dev/var]:1306# l www2-bin.00* -rw-rw1 mysqlmysql 137 Aug 12 16:31 www2-bin.001 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.002 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.003 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.004 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.005 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.006 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.007 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.008 -rw-rw1 mysqlmysql 62 Aug 12 16:31 www2-bin.009 [www2:/opt/mysql-dev/var]:1304# ../bin/mysqlbinlog www2-bin.001 # at 4 #020812 16:29:30 server id 1 log_pos 4 Start: binlog v 3, server v 4.0. 2-alpha-log created 020812 16:29:30 # at 79 #020812 16:31:13 server id 2 log_pos 79Rotate to www2-bin.002 pos: 4 # at 118 #020812 16:31:13 server id 1 log_pos 118 Stop [www2:/opt/mysql-dev/var]:1305# ../bin/mysqlbinlog www2-bin.002 # at 4 #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.003 pos: 4 # at 43 #020812 16:31:13 server id 1 log_pos 43Stop [www2:/opt/mysql-dev/var]:1307# ../bin/mysqlbinlog www2-bin.003 # at 4 #020812 16:31:13 server id 2 log_pos 4 Rotate to www2-bin.004 pos: 4 # at 43 #020812 16:31:13 server id 1 log_pos 43Stop [www2:/opt/mysql-dev/var]:1308# -- and so on. Will be fixed this error in 4.0.3? How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Artem Ryabov Organization: MySQL support: none Synopsis: too many bin-log files Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.2-alpha (Source distribution) Environment: System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Nov 25 2000 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5155229 Jan 11 2001 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 11 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 11 2001 /usr/lib/libc.so configure command: ./configure --with-mysqld-ldflags=-all-static --disable-shared --prefix=/opt/mysql-dev --with-charset=cp1251 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Replication Circle
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 than performance). Whenever at least one of the servers is up it should be used (and the other is not used even if it is also up). Can you think of some pitfalls I need to watch out from? Regards, Oren. Oren Zeev-Ben-Mordehai Infrastructure Engineer PhoneDo Networks office: +972-9-951-7771 ext. 204 fax:+972-9-951-7772 email: [EMAIL PROTECTED] sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Circle
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-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, but I wanted to know if there was a way to do this, that I don't know of. Thanks, Bhavin. sql, mysql, query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Circle
* 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 is possible, but I wanted to know if there was a way to do this, that I don't know of. Yes, this is possible, but it may be difficult, depending on your application. URL: http://www.mysql.com/doc/R/e/Replication_Features.html Starting in Version 3.23.26, it is safe to connect servers in a circular master-slave relationship with log-slave-updates enabled. Note, however, that many queries will not work right in this kind of setup unless your client code is written to take care of the potential problems that can happen from updates that occur in different sequence on different servers. See also the replication FAQ: URL: http://www.mysql.com/doc/R/e/Replication_FAQ.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Circle
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 the changes. It doesn't seem probable that this is possible, but I wanted to know if there was a way to do this, that I don't know of. Yes, you can do it. But beware of auto-increment fields as discussed in the manual. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 62 days, processed 1,313,338,207 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Circle
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: sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Circle
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, but I wanted to know if there was a way to do this, that I don't know of. Thanks, Bhavin. sql, mysql, query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php