Re: help with replication
thanks On Wed, Aug 18, 2010 at 10:42 PM, wrote: > Quoting Norman Khine : > > >>> >>> 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 : 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: help with replication
hi On Wed, Aug 18, 2010 at 8:00 PM, wrote: > Quoting Norman Khine : > >> 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 : 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
help with replication
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. any help much appreciated. -- ˙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