mysql replication problems
dear everybody, I have tree linux 7.3 machines on which MySQL-3.23.51-1.i386.rpm, MySQL-client-3.23.51-1.i386.rpm and MySQL-shared-3.23.51-1.i386.rpm is installed. the intrusion detection system snort loggs to these machines. Every machine is set up the same way and contains the same table. The data of these three tables is always different. this works well, but now I want to have a place/machine where I can read the data of these three tables. Maybe I can set up a master to which all the other databases can log their data? Or perhaps I can configure every machine as master and as slave at the same time and thus every machine contains the whole data of these three machines. I am a newbie in mysql and don't know how to do it. I read the following link : http://www.mysql.com/doc/en/Replication.html but I don't know if mysql meets my requirements. Anyway I tried to configure two of my databases like the example configuration. I had no problem with the master. then I tried to set up the slave and couldn't find the my.cnf, the mysqld and the mysqld.log files. I set up the two machines the same way!! Perhaps I used the wrong softare, but why exit the files on the other machine? thanks for your help martina podesser FLEXTRONICS World Trade Center A-1300 Vienna Austria [EMAIL PROTECTED] www.flextronics.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 replication problems
Both my slave server say they are replicating correctly in the mysqld.log but they arn't. Any change made to the master is not reflected to the slaves. I have tried reseting the master and slaves but didn't change anything. Also tried redumping the databases to the slaves but that didn't effect anything. Anyone have any ideas? Justin Best NOC - Infostations - 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: [Repost: Mysql Replication Problems]
Hi, On 13 Feb 2002, at 12:44, Henning Sprang wrote: Was something wrong with this post or is it really such a weird problem that there is neither a solution nor anything i could do to solve it, nor anything i could do to find out more about it? Well. Replication is somewhat weird. ;-) Slave: error running query 'drop table tropon_base.TB_Tage,tropon_001.TB_Tage' 020209 3:49:32 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. ERROR: 1051 Unknown table 'TB_Tage,TB_Tage' Sounds, as if you were doing some cross database updates / inserts. This might lead to problems if you only replicate some of the databases on the master. So, if there is a Database A, B, C, D on master each with tables A1,A2,A3 or B1,B2,B3 and so on, and you only replicate A and B and you do: use A; insert into C.C1 (a,b,c) VALUES (1,2,3); you'll get this error. You might avoid it with replicate-wild-ignore-table=C.* More details in: http://www.mysql.com/documentation/mysql/bychapter/manual_My SQL_Database_Administration.html#Replication_Options But note that: use C; insert into A.A1 (a,b,c) VALUES (1,2,3); would not be replicated to the slave, if you choosed to replicate only A and B. Even though it affects A. (Strange, but that's the way live goes). At least with MySQL 3.23.36 So best is to avoid cross-databases actions except for SELECT with replication enabled. Bye Tobias --- Tobias Eggendorfer E-Mail: [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
[Repost: Mysql Replication Problems]
Hy, Was something wrong with this post or is it really such a weird problem that there is neither a solution nor anything i could do to solve it, nor anything i could do to find out more about it? that was the message: I get some Errors when doing Replication on MySQL 3.23.47. And can't get it going on(I did not upgrade because in Changelog there is no replication or binlog related Bugfix mentioned between .47 and .48 and i only upgraded to .47 some days before) the Messages in error-log are: 020208 17:43:20 mysqld started /usr/local/mysql/3.23.47/libexec/mysqld: ready for connections 020208 17:43:22 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020209 3:49:32 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'no error' (0) 020209 3:49:32 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_001.TB_Tage' 020209 3:49:32 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'localhost-bin.001' position 330834 020209 3:49:32 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 After restarting _wthout_ fixing an error because not knowing what the error is and just looking if it maybe works I get a somehow different message, even if i think it's the same problem: 020211 14:49:06 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'localhost-bin.001' at position 330834 ERROR: 1051 Unknown table 'TB_Tage,TB_Tage' 020211 14:49:06 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'Unknown table 'TB_Tage,TB_Tage'' (1051) 020211 14:49:06 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_001.TB_Tage' 020211 14:49:06 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'localhost-bin.001' position 330834 020211 14:49:06 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 Those problematic tables are temporary heap Tables, but in replication docs I read that those work fine since some Versions. I'd greatly appreciate some Ideas, TIA, Henning - 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 Replication Problems
Hy All, I get some Errors when doing Replication on MySQL 3.23.47. (I did not upgrade because in Changelog there is no Replication-Related Bugfix mentioned) the Messages in error-log are: 020208 17:43:20 mysqld started /usr/local/mysql/3.23.47/libexec/mysqld: ready for connections 020208 17:43:22 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020209 3:49:32 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'no error' (0) 020209 3:49:32 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_001.TB_Tage' 020209 3:49:32 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'localhost-bin.001' position 330834 020209 3:49:32 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 After restarting _wthout_ fixing an error because not knowing what the error is and just looking if it maybe works I get a somehow different message, even if i think it's the same problem: 020211 14:49:06 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'localhost-bin.001' at position 330834 ERROR: 1051 Unknown table 'TB_Tage,TB_Tage' 020211 14:49:06 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'Unknown table 'TB_Tage,TB_Tage'' (1051) 020211 14:49:06 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_001.TB_Tage' 020211 14:49:06 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'localhost-bin.001' position 330834 020211 14:49:06 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 Those tables are temporary heap Tables, but in replication docs I read that those work fine since some Versions. I'd greatly appreciate some Ideas, TIA, Henning - 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