Dear all, Hope this question did not disturb you.
I have one linux box with mysql install and working fine. Thank you MySQL. Due to the information stored into database are really crittical data, I decide to make another copy of the whole data into another linux box with the same version of mysql. All replication on small table working fine. No problem. It just take a second. But, when I did run a replication for a big table (400.000 records), it tooks about 8 minutes (not seconds). During 8 minutes to finish the job for the replication of that big table, another equipment (terminal) sending an information into database (for the big table) to do an update and or add another records. When the above 8 minutes done, the number of records between the first linux box will bigger than the seconds linux box. The balance are the number of records added during the above 8 minutes. 'lock database with read lock' command already done before the above replication started and followed by 'unlock all' when finished. Question, how to sync an unsync table or the whole database again ? Thank you Paul --------------------------------------------------------------------- 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
