> >How much time? I ask because it sounds like you are assuming and > >have not actually tried it.
[ I think in general it's not bad to think about things impact before trying :) ] > >My usual stance is: What is more important to you? a fast backup or > >a reliable backup? > > > > > > > you are right, i have not actually tried it with this > database server, > but i have experience with > other projects running on even faster servers. the server i need to > backup now is always under > heavy load and dumping would take a long time. even if it would be > sitting around lazy it would > take time to write several GB (around 6 at the moment) of > data to disk... Could You possible create a solution like one of the following for reducing performance penalty during backup: - run mysqldump with extremely high nice value to a different disk spindle - stop mysql for a few seconds, create a filesystem snapshot, restart it and save the snapshot (this of course depends on the filesystem type You're using and if You want to add an additional script to Your backup procedure. florian ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
