hello,
> > You should investigate: > > > > - using LVM to store your databases on > Are you talking about using LVM snapshot feature? It's a little > difficult because we need to modify filesystem on production servers yeah, that gives you the shortest downtime with the quickest restore option for backups. You snapshot the DB, with innodb you dont even need to lock tables mostly It Just Works. Harder with MyISAM. But if you dont have LVM now yes it will be a pain. > > - using mysqlhotcopy and innodb hot backup to drive the backups and > > then backing that up > this is not bad, I'll keep it in mind. only if you can afford table locks. > > - 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 backup 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. > > You can dump as well and I suggest doing regular dumps but on large > > databases with many indexes restoring can take a long long time (days) > > so not optimal. > 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. 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. Might be a big enough win that reinstalling servers becomes viable. With that many servers I guess you already have it automated anyway. -- R.I.Pienaar ------------------------------------------------------------------------- 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
