Bacula-users

Re: [Bacula-users] Best way to backup simultaneously

2009-03-19 18:47:26
Subject: Re: [Bacula-users] Best way to backup simultaneously
From: Kevin Keane <subscription AT kkeane DOT com>
Date: Thu, 19 Mar 2009 15:41:10 -0700
If you are using a single tape drive, you will have an issue.

One thing you could theoretically do is configure the storage daemon, 
storage resource, job, and pool all for multiple concurrent jobs. The 
bacula manual explains how to do that. But I'm not sure if that really 
gives you the results you would want, and it can potentially be a problem.

A couple other thoughts:

- I actually shut down the monitoring system during backup runs for 
exactly that type of reason. I know and expect that some services will 
be slower than normal, no need to be alerted about it. I am using 
Nagios, and simply configured a script to create a scheduled downtime 
when the nightly backup starts. I don't know if that is acceptable for 
your situation, of course.

- You could use spooling for the transaction logs, since you say that 
you have local file storage available. That way, the client would see 
the backup completed quickly, and bacula would later write the actual 
files to tape at its convenience.

- Maybe I'm showing my ignorance on databases here, but does it even 
make sense to flush transaction logs to tape while the database itself 
is being backed up? Maybe you can suspend flushing the logs during the 
backup? My admittedly very rusty SQL Server skills seem to recall that 
the transaction log will be cleaned up during the database backup. Not 
sure if that still applies, or if it translates to other databases.

Jason Dixon wrote:
> Rather than continue to beat my head against the wall, let me describe
> what I need Bacula to perform and hopefully someone smarter than me can
> suggest the best setup.
>
> We have 3 types of jobs in this particular facility:
>
> 1) OS backups that run nightly
> 2) Database backup that runs nightly
> 3) Database transaction logs that are initiated by the client, typically
> every 10 minutes.  These are very important and need to be flushed to
> tape in an expedient manner.
>
> We have a single drive Sony SDX-700C robot.  We also have local file
> storage available.  The most important consideration is that #3 gets
> completed quickly each time it runs, or it risks backing up the next run
> and causing our monitoring system to page.  :-P
>
> The problem I typically run into is that because the client initiates
> the #3 jobs, they are forced to wait each night as #1 jobs finish.  Even
> with a higher priority, since they are not scheduled jobs.  I even went
> so far as to create a FileStorage device for #1 jobs.  But this made no
> difference in my tests.
>
> My last resort is to start up another storage daemon for the #1 jobs, but
> I'd like to ask you all first to see if there's a better way, or maybe
> I've just missed something simple.
>
> Thanks,
>
>   


-- 
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or 
proprietary information. Please be advised that the unauthorized use or 
disclosure of the information is strictly prohibited. The information herein is 
intended only for use by the intended recipient(s) named above. If you have 
received this transmission in error, please notify the sender immediately and 
permanently delete the e-mail and any copies, printouts or attachments thereof.


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users