Re: Replication problem (alter table fails)
Looks like we've mixed up two threads into one ;-) As I understood from various forums and maillists, versions 4.x are still in development state. The newest production version is 3.23.55, am I right? Do you recommend this version for testing? Regards, Kirill Egor Egorov wrote: On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- Kirill Peskov UNIX Application Engineer WEB-EU TREND MICRO Deutschland GmbH Lise-Meitner-Strasse 4 Unterschleissheim D-85716 Germany Tel: +49(0)89 37479-850 Fax: +49(0)89 20 37479-700 Mobile: +49(0)172 265-1635 E-Mail: [EMAIL PROTECTED] WWW: www.trendmicro.de http://www.trendmicro.de The information contained in this electronic mail message and any attachments hereto is privileged and confidential information intended only for the use of the individual or entity named above or their designee. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error please immediately notify us by return message or by telephone and delete the original message from your mail system. Thank you. - 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 problem (alter table fails)
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote: Looks like we've mixed up two threads into one ;-) As I understood from various forums and maillists, versions 4.x are still in development state. Yup, 4.0.X is gamma. The newest production version is 3.23.55, am I right? Do you recommend this version for testing? Yes, test it on 3.23.55 and tell me about results. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
Replication problem (alter table fails)
Dear gurus, Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Best Regards, Kirill - 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 problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: Replication problem (alter table fails)
Egor, I am sorry, my bad. I misrepresented the versions of mysql I am using. Must have been a typo. Here is what I am using. Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. Could you continue to help me with this ? Thanks, floyd -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: re: Replication problem (alter table fails) On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 - 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 problem (alter table fails)
On Tuesday 25 February 2003 16:36, Floyd Wellershaus wrote: Egor, I am sorry, my bad. I misrepresented the versions of mysql I am using. Must have been a typo. Here is what I am using. Master: Sparc Solaris 7 MySQL 4.0.9-gamma-log Slave: RedHat Linux 7.2 MySQL 4.0.8-gamma-log. Could you continue to help me with this ? I tested on 4.0.10 .. What replication options do you have in my.cnf? Do you use any replicate-* options? Could you provide a test case? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: re: Replication problem (alter table fails) On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote: Coud you, please, give an advice to solve following problem: I've got two Mysql Servers: * Master: Sparc Solaris 8, MySQL 3.23.32 * Slave: RedHat Linux 7.2, MySQL 3.23.32 Replication of data runs fine, all insert into and delete from made on master successfully change the slave database. Creation and dropping of the whole tables also work fine. But if I add or delete certain column in any table on master DB (e.g. run ALTER TABLE commands), slave ignores is and later on stops replication because it cannot replicate the data appeared or changed on the master afterwards (because these fields not exist on the slave). Is there any way to tell either Master or Slave to replicate ALTER TABLE queries as well? Since 3.23.32 there were a lot of bug fixed related to the replication. Please, upgrade servers and test it again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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