Bacula-users

Re: [Bacula-users] Which tapes to put into the tape library?

2010-01-21 12:48:07
Subject: Re: [Bacula-users] Which tapes to put into the tape library?
From: Chris Hoogendyk <hoogendyk AT bio.umass DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Thu, 21 Jan 2010 12:30:45 -0500

John Jorgensen wrote:
>>>>>> "dan" == Dan Langille <dan AT langille DOT org> writes:
>>>>>>             
>
>     dan> I have about 100 tapes.  My tape library holds only 10 tapes.
>     dan> How do you decide which tapes to load into the library?  What 
> strategy do
>     dan> you use?
>
> I have a variant of your query that orders the volumes by the
> date when they should be eligible for reuse.  (Our mechanism for
> keeping the first backups of each month for a year is to adjust
> their volretention above the default, so the volretention is not
> uniform.)
>
>  SELECT VolumeName AS Volume, 
>         CASE WHEN InChanger != 0
>           THEN text(Slot) 
>           ELSE ''
>         END AS SLOT, 
>         LabelDate, FirstWritten, LastWritten, 
>         CASE LastWritten IS NULL 
>           WHEN TRUE THEN now()
>           ELSE LastWritten + CAST(CAST(Media.VolRetention AS text) AS 
> interval) 
>         END AS Eligible,
>       Media.VolRetention/3600/24 AS Ret,
>         VolJobs AS Jobs, VolBlocks, 
>       VolBytes/1024/1024/1024 AS GB,
>         VolStatus AS STATUS, Media.Recycle
>  FROM Media LEFT JOIN Pool USING (PoolId)
>  WHERE Pool.name = 'Generic Full ML6000 Pool'
>  ORDER BY Eligible,volumename
>
> So when it's time to rotate tapes out of the library, I run the
> query and load the volumes at the top of the list back into the
> library (I also store the tapes on the shelf in more or less the
> same order, so there is a unautomated fallback mechanism :-).

Your fallback is my routine.

I typically use `mtx -f /path/to/device status` to see which barcodes 
are currently in the library. That tells me where the transition point 
is in the tape sequence. I have a steel storage box that holds all the 
rest of my tapes in barcode order. They are labeled in the same sequence 
as the barcodes.

I change out anywhere from 4 to 7 tapes a week (5 is the magic number, 
but my changer opens 2 slots at once, and I keep slot 16 for the 
cleaning tape). If I'm going on vacation I change out a couple weeks 
worth. I like to keep at least the last week in the library just so that 
recoveries are easy if someone comes asking for something.

I've been doing this for a few years. I set up a wiki page a couple of 
years ago in case one of the other sysadmins had to fill in sometime. 
(Ignore the fact that this says Amanda, it doesn't matter, it's still 
just tape rotation) -- 
https://bcrc.bio.umass.edu/phpwiki/index.php/AmandaBackupServer#wtc

Backups just keep cycling through the slots on the Library. As long as I 
have the tapes in sequence, and the oldest use dates coming up next, 
everything just keeps working.

Of course, if you have multiple pools, the game changes. I do have some 
tapes that have much longer retention times (archive, no-reuse, or 
whatever). I just pull them out of the sequence and store them in a 
separate steel box.


-- 
---------------

Chris Hoogendyk

-
   O__  ---- Systems Administrator
  c/ /'_ --- Biology & Geology Departments
 (*) \(*) -- 140 Morrill Science Center
~~~~~~~~~~ - University of Massachusetts, Amherst 

<hoogendyk AT bio.umass DOT edu>

--------------- 

Erdös 4



------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users