sascha mantscheff wrote: > Ihre Nachricht vom Friday 18 January 2002 12:14: > >>sascha mantscheff wrote: >> >>>I'm not using replication, but for a test if it really works I would do >>>some data manipulations on the master and afterwards a complete mysqldump >>>of master and replica and diff the result. >>> >>ok, this is an new and interesting idea, has anyone an idea how long it >>can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? >> >>henning >> > > does it matter?
shure it does. first to say, it wasn't meant as a critical question, but as an informal question. it matters in the way that it is impractical if machines of this size just crash when trying such a diff (i accidentally opened such a file in vim, that was no fun!) or when the diff takes a week or so. > try it on some smaller tables first, then on the big ones, > then on the whole bunch. it will take much less time then to fix any problems > afterwards, in case that replication doesn't work as expected. hmm, maybe, but maybe not, if diffs of this size would take a week i could only test it once and would then rely on the mysql error mechanism. if i'd insist in doing consistency checks on a regular basis i would maybe better try the "old way" of backup and zipping the datafiles once in a while... henning --------------------------------------------------------------------- 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
