On Fri, 2008-01-04 at 17:21 +0000, R.I. Pienaar wrote: > > > - or use zmanda + LVM to back up your data with bacula pulling the > > > backups from your DB servers to your tape > > It seems cool, but reading from the zmanda site it seems that it support > > tape drives. why do I need bacula, too? > > there are 2 products, Amanda - thats like bacula kind of, a general > ebackup solution. Zmanda thats a perl script specifically for backing > up mysql and nothing else, it creates files that you should then move > to your backup storage using either Bacula or anything else like it. > > Zmanda is aware of LVM, hot copies and all sorts of things and usually > just does the right thing, if your OS support snapshots it will use > them etc, well worth investigating and makes a good partner to bacula. OK now I got it. thanks
> > In fact, we have huge tables, so it's better to restore files. We > > dropped the idea of backing up db (full) weekly and replication log > > daily (incremental) because it take a long of time to restore a single > > table. > > will you be happy then to take the DB you are restoring to offline > during the restore? You would need to do that for this kind of > restore. In fact we dropped that idea because of the downtime caused by a single restore > Sounds to me though that LVM with hourly snapshots will be a great win > for you, you make hourly snapshots on each server and when a dev makes > a mistake you put the last hours back. and you can just use the > snapshot made at midnight and ship it off-machine using bacula.\ Yes, I think it's the best way, but I've to convince my group. It's a big implementation work, on 30 systems in production providing services to a lot of customers. Downtimes not admitted :S > Might be a big enough win that reinstalling servers becomes viable. > With that many servers I guess you already have it automated anyway. Automated backup? ehm... I've arrived here 1 month ago, and this is the situation I found: We have 10 MySql cluster chains with 1 master, 1 slave and 1 "report" used only for backups (3 times the same data). A cronjob stop mysql "Report" instance and tar-gzip data in mysql directory, then it copies the result on nfs mounted export on a remote storage. A Full backup for day. Now They are running out of space, so we need to move to a better solution to save space keeping a quick response time to restore request. Using LVM snapshot we could save a lot of space and eliminate the third copy of the data. And reduce backup times, too. Thanks a lot for your answer. Diego ------------------------------------------------------------------------- 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
