replication error
Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other..whenever the master has an update then the change in the binlog pos happens fine and the slave also picks up from the master. and the log positions are in sync..but the data never gets copied to the slave.. in short the log positions are always in sync with each other but the data is never replicated to the server. has anybody com across this wierd error..? any help would be greatly appreciated regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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 error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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 error
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the master and applied the dump on the slave.and all works fine when i do a show slave status and a show master status. both show me the same same log file position and logfile name.and when any insert happens in the master then the log file postions change on both slave and master.but the count on the slave never increases. i'm not able to find the newly inserted data on the slave even thought the logfile position is in sync with the master.. has anyone faced this problem?? or have I overlooked the obvious.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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 error
Placed At : Hi.. I have come across a wierd error in my replication setup..I run mysql 3.23.49 on two servers .one is the master and the other the slave..I have jus one DB with jus a single table in it. I 'm getting the follwoing error on my slave error 'unexpected success or fatal error' on query '' and replication stops.. I do a set SQL_SLAVE_SKIP_COUNTER=1; and then a slave start.then replication starts and immediately after reading a few positions replication stops with the same error..I hope somebody can thro some light on this.. regards kannan ** Quality Policy To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions. ** - 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