Re: help with replication
thanks On Wed, Aug 18, 2010 at 10:42 PM, a.sm...@ukgrid.net wrote: Quoting Norman Khine nor...@khine.net: What is shown from show master status and show slave status after you have made a change on the master DB? this is the output: http://pastie.org/1100610 it does not seem to have any changes and show slave status is just empty. have i missed to add something to the master's /etc/mysql/my.cnf options? So you can see the binlog position on the master has not changed, hence you wont get any changes replicated to the slave. The show slave status has to be run on the slave not the master. Anyway, I believe your problem is your binlog-do-db section on the master, and also the ignore sections, I think these need to be broken into seperate lines, with only one value per line. ie: binlog-do-db = upgrade binlog-do-db = tracker this was the issue You´ll need to completely resetup the syncronsiation after this, as you currently have out of sync DBs and no data stored in your binlogs... -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ % .join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ,adym,*)uzq^zqf ] ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help with replication
Quoting Norman Khine nor...@khine.net: hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. What is shown from show master status and show slave status after you have made a change on the master DB? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help with replication
hi On Wed, Aug 18, 2010 at 8:00 PM, a.sm...@ukgrid.net wrote: Quoting Norman Khine nor...@khine.net: hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. What is shown from show master status and show slave status after you have made a change on the master DB? this is the output: http://pastie.org/1100610 it does not seem to have any changes and show slave status is just empty. have i missed to add something to the master's /etc/mysql/my.cnf options? -- ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ % .join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ,adym,*)uzq^zqf ] ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: help with replication
Quoting Norman Khine nor...@khine.net: What is shown from show master status and show slave status after you have made a change on the master DB? this is the output: http://pastie.org/1100610 it does not seem to have any changes and show slave status is just empty. have i missed to add something to the master's /etc/mysql/my.cnf options? So you can see the binlog position on the master has not changed, hence you wont get any changes replicated to the slave. The show slave status has to be run on the slave not the master. Anyway, I believe your problem is your binlog-do-db section on the master, and also the ignore sections, I think these need to be broken into seperate lines, with only one value per line. ie: binlog-do-db = upgrade binlog-do-db = tracker You´ll need to completely resetup the syncronsiation after this, as you currently have out of sync DBs and no data stored in your binlogs... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: RE: help starting replication
On Friday 21 February 2003 19:38, you wrote: You asked: Does replication user have REPLICATION SLAVE privilege? Yes it does. Connect to the master as replication user and see if SHOW SLAVE HOSTS gives any error messages. -- 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: help starting replication
On Friday 21 February 2003 17:53, fwellers at vcampus dot com wrote: I am trying to start replication from a 4.0.9 solaris master to a 4.0.8 linux slave. I am already sucessfully replicating this master to another sun slave. I followed the same procedures on the linux box but no joy. The error log keeps saying : 030221 10:08:56 mysqld started 030221 10:08:56 InnoDB: Started /usr/mysql/libexec/mysqld: ready for connections 030221 10:08:56 Slave I/O thread: connected to master 'replication@udd:3306', replication started in log 'udd-bin.008' at position 154 030221 10:08:56 Error updating slave list: Query error 030221 10:08:56 Slave I/O thread exiting, read up to log 'udd-bin.008', position 154 Show slave status yields that the Slave_SQL_Running value is 'yes', but the Slave_IO_Running values is 'No'. Does anyone have any ideas to help troubleshoot this ? Does replication user have 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