Hi, I'm new to the list (& mysql) and not sure if there is an archive I can search so apologies if this has been mentioned earlier. I was hoping someone might be able to shed some light on a problem I am having:
I'm supporting a mysql 3.23.49 database with one master db (type=BerkleyDB) and two slave databases (both type=MyISAM). If I check the Show master status/show slave status outputs it shows that the databases are all current and pointing to the same file pointer and using the same binary log. Then, if I do a count(*) from TABLENAME_T; on each to check they all are identical as well as current, the two slaves have just over 2000 records less than the master ie masterdb = 27262 records slave01 = 25181records slave02 = 25181 records ie a difference of 2081records this seems to be happening every couple of days and I have to do a mysqldump on the master and restore to the slaves - then the number of records is the same again (& the file pointers are still in sync) until a couple of days later when they go out of sync. I don't see any messages referring to failed transactions in the logs so as far as the error logs are concerned it all looks ok (though I could have basic logging switched on, looking into setting the logging higher now). I've tested the validity of the data for recent updates - if I send a manual update to the master it goes to the slaves and is displayed in the output correctly around the time as it is on the master. I've asked some of the techs who have a similar setup in another department (which has been working for over a year) and theirs always have the same number of records as well as having the file pointers/binary logs in sync. they are using berkley and myisam type tables also. does anyone know what could be causing the number of records to differ? pls let me know if u need more info. any help greatly appreciated! thanks in advance Kath --------------------------------------------------------------------- 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
