[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] Bacula copy pools , volumes option


On Wed, Oct 22, 2008 at 07:43:49PM +0300, Pasi Kärkkäinen wrote:
> On Wed, Oct 08, 2008 at 10:08:40PM +0300, Pasi Kärkkäinen wrote:
> > On Wed, Oct 08, 2008 at 07:39:26PM +0300, Pasi Kärkkäinen wrote:
> > > On Wed, Oct 08, 2008 at 06:20:21PM +0200, Kern Sibbald wrote:
> > > > On Wednesday 08 October 2008 18:04:27 Pasi Kärkkäinen wrote:
> > > > > On Wed, Oct 08, 2008 at 03:31:42PM +0200, Kern Sibbald wrote:
> > > > > > On Wednesday 08 October 2008 09:01:41 tomwest@xxxxxxxxx wrote:
> > > > > > > Hello,
> > > > > > >
> > > > > > > I'd like to ask if it is planed to implement copy pools , volumes in
> > > > > > > new version of bacula. It would be great functionality. I would be able
> > > > > > > to make copies of backed-up data from tape to tape into few pools
> > > > > > > without running the same job with different pool setting.
> > > > > > >
> > > > > > > I'm very interested in testing this solution if there is any beta
> > > > > > > version we can test.
> > > > > >
> > > > > > Yes, this functionality exists in the current development version of
> > > > > > Bacula. If you want to know about the new features, please see:
> > > > > >
> > > > > > http://www.bacula.org/manuals/en/concepts/concepts/New_Features.html
> > > > >
> > > > > That reminded me of the selection features related to copying jobs.
> > > > >
> > > > > Is it currently possible to specify 'copy only uncopied jobs' ?
> > > > 
> > > > I believe so, but you will have to try it.  That feature is also documented in 
> > > > the New Features section of the manual, if I am not mistaken.  If not, please 
> > > > search for it in the main "developement" manual.
> > > > 
> > > 
> > > Yep, I was planning to try it now. 
> > > 
> > > I tried searching for it, but couldn't see it.. 
> > > I went through these:
> > > 
> > > http://www.bacula.org/manuals/en/concepts/concepts/New_Features.html
> > > http://www.bacula.org/manuals/en/concepts/concepts/Migration.html
> > > http://www.bacula.org/manuals/en/problems/problems/index.html
> > > 
> > 
> > So if someone has ideas how to implement that 'copy only uncopied jobs'
> > feature, I'm happy to help testing it. 
> > 
> > I guess it could be done at least using Selection Type = SQLQuery.
> > 
> > Which field in the database marks the job has been copied/migrated? 
> > (Haven't looked into it yet).
> > 
> 
> Looking at this now.. 
> 
> Migration (and copying aswell I assume) is done on jobid basis.
> 
> So, I need to write a SQL query that returns the non-copied JobIds
> that I want to copy to another pool. 
> 
> Steps to get there:
> 
> 1. Figure out how to determine which jobids still exist on disk volumes (have not been recycled yet) ?
> 2. From those Jobids, figure out how to determine which jobids are not already copied ?
> 
> So.. if someone has tips for that 1. it would help, I'm not yet very
> familiar with the Bacula database/table contents.
> 
> About question 2:
> http://bacula.org/en/rel-manual/Migration.html says:
> 
> "Migration takes place on a JobId by JobId basis. That is each JobId is
> migrated in its entirety and independently of other JobIds. Once the Job is
> migrated, it will be on the new medium in the new Pool, but for the most
> part, aside from having a new JobId, it will appear with all the same
> characteristics of the original job (start, end time, ...). The column
> RealEndTime in the catalog Job table will contain the time and date that the
> Migration terminated, and by comparing it with the EndTime column you can
> tell whether or not the job was migrated. The original job is purged of its
> File records, and its Type field is changed from "B" to "M" to indicate that
> the job was migrated. "
> 
> Is this also true for copying jobs? Will Type be set to "M" after copying? Or something else? 
> 
> That Type field would be an easy way to check if the Job is already copied.. 
> 

Replying myself.. 

There's "Selection Type = PoolUncopiedJobs" feature in Bacula 2.5
development version. This feature does exactly what I needed.

-- Pasi

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you.  Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.