On Fri, Nov 02, 2001 at 03:07:42PM +0600, Ershad Shafi Chowdhury wrote: > > Hi! Has anyone experienced a replication server to miss updates? Our > master is running Mysql 3.23.33 on RH 6.1 Kernel 2.2.12-20 and the > slave is running 3.23.24 on Solaris 2.5.1 Normally Inserts and > updates occur on the master and SELECT queries occur on the slave. > > Recently the mirroring stopped (HDD became full), so as always, I > shutdown the slave, ran myisamchk on the slave's DB, then restarted > the slave. Replication resumed as normal, but later when I checked, > I found several inserts onthe master missing from the slave.
When the disk filled up, you may have lost data. Have you tried re-syncing the master and slave? After doing that, you shouldn't see any "missed rows" on the slave. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 60 days, processed 1,316,178,505 queries (253/sec. avg) --------------------------------------------------------------------- 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
