Dan Langille wrote: > On 13 Sep 2007 at 19:23, Jordi Espasa Clofent wrote: > > >> Hi all, >> >> We (a little webhosting company) are planning to use Bacula in >> production as a backup solution. But, first of all we need to resolve >> one important and essencial question: >> >> ¿Is Bacula a reliable method to backup an _active_ databases (normally >> it will be a MySQL servers)? >> >> For example, if I have a box with a MySQL server _active_ just in the >> moment that Bacula does their backup job... ¿the resultant copy will be >> consistent as a copy you can get with the using of specialized tools as >> mysqldump? >> > > Recommended solution: always use mysqldump.
Regardless of what software you choose for network backup, you can always use ZRM for MySQL -- <http://www.zmanda.com/backup-mysql.html>. It does backups using /*mysqldump*/, LVM snapshots, /*mysqlhotcopy*/ or MySQL replication. It does not replace network backup. It is complementary. It handles backup and recovery of MySQL, and co-exists with your network backup software. --------------- Chris Hoogendyk - O__ ---- Systems Administrator c/ /'_ --- Biology & Geology Departments (*) \(*) -- 140 Morrill Science Center ~~~~~~~~~~ - University of Massachusetts, Amherst <[EMAIL PROTECTED]> --------------- Erdös 4 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
