Re: Replication Error on Slave
All, Thanks for your replies and as per the advise I switched to row-based replication but replication ended with below error. *Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default database: 'b. Query: 'drop table sdefrent'* above error is due to non existence of database and table. However bit confused on the error I got, if its row based replication why its taking as statement. Please help me here. Thank you -Naga On Thu, Jan 27, 2011 at 3:23 PM, Johan De Meersman vegiv...@tuxera.bewrote: On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S nagaraj@gmail.comwrote: **On Slave Server I replicate database *A alone* and my replication not working due to data fetching happen on B database. Well, yes. Statement-based replication does what it says on the box: it executes the exact same statement on the slave. If database B is not there, then insert into A select from B will not work. You may switch to row-based replication (which of course has it's own caveats, see the online manuals); or you can simply choose to also replicate database B. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Replication Error on Slave
**On master server I have two databases *A and B*. App team use database B temporarily for there application to compute calculation and insert the values on A database. For certain statements you could start with SET SQL_BIN_LOG=0 so it doesn't log that statement, and it won't be replicated. -Kristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Replication Error on Slave
I have setup mysql replication with below scenario **On master server I have two databases *A and B*. App team use database B temporarily for there application to compute calculation and insert the values on A database. **On Slave Server I replicate database *A alone* and my replication not working due to data fetching happen on B database. Kindly help me out to resolve this issue. -Naga
Re: Replication Error on Slave
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S nagaraj@gmail.com wrote: **On Slave Server I replicate database *A alone* and my replication not working due to data fetching happen on B database. Well, yes. Statement-based replication does what it says on the box: it executes the exact same statement on the slave. If database B is not there, then insert into A select from B will not work. You may switch to row-based replication (which of course has it's own caveats, see the online manuals); or you can simply choose to also replicate database B. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
replication Error updateing slave list in mysql 4.0.10
I am having problems setting up replication between two 4.0.10 servers. What I did so far: - generate a dump of the current state of the server using 'mysqldump' (its a mix of mostly innodb tables and some MyISAM tables) - dropped all databases from the slave - imported the dump into the slave using mysql dump - updated the slave parameters using 'CHANGE MASTER' As I start the slave, it immediatly stops and I am getting the following in the slave error log: 030213 4:36:30 Slave I/O thread: connected to master 'repl@master:3399', replication started in log 'slave-bin.005' at position 86967189 030213 4:36:30 Error updating slave list: Query error 030213 4:36:30 Slave I/O thread exiting, read up to log 'slave-bin.005', position 86967189 not that the master is running on port 3399 (ssh tunnel). I can connect to the master as 'repl' from the slave. looking at the source shows this error in conjunction with 'show slave hosts'. This command returns an empty result on master and host. Not sure what it is supposed to return. I did try a 4.0.5 master first with the same result. Now I upgraded the master to 4.0.10 (slave ran 4.0.10 all along). -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - 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 Error updateing slave list in mysql 4.0.10
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote: I am having problems setting up replication between two 4.0.10 servers. What I did so far: - generate a dump of the current state of the server using 'mysqldump' (its a mix of mostly innodb tables and some MyISAM tables) - dropped all databases from the slave - imported the dump into the slave using mysql dump - updated the slave parameters using 'CHANGE MASTER' As I start the slave, it immediatly stops and I am getting the following in the slave error log: 030213 4:36:30 Slave I/O thread: connected to master 'repl@master:3399', replication started in log 'slave-bin.005' at position 86967189 030213 4:36:30 Error updating slave list: Query error 030213 4:36:30 Slave I/O thread exiting, read up to log 'slave-bin.005', position 86967189 not that the master is running on port 3399 (ssh tunnel). I can connect to the master as 'repl' from the slave. looking at the source shows this error in conjunction with 'show slave hosts'. This command returns an empty result on master and host. Not sure what it is supposed to return. I did try a 4.0.5 master first with the same result. Now I upgraded the master to 4.0.10 (slave ran 4.0.10 all along). Check the user 'repl' has REPLICATION SLAVE privilege. -- 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 Error updateing slave list in mysql 4.0.10
Check the user 'repl' has REPLICATION SLAVE privilege. Ah. that fixed it. Actually, the real reason was that I had not yet updated the mysql tables and the new privileges did not take effect as a result. mysql_fix_privilege_tables , followed by the 'GRANT' command and 'flush privileges' fixed it. Thanks! -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - 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
