Hi,
I need a litte bit help with Baculas catalog database locking
mechanisms. Is there anything I can do, to avoid locking the whole
catalog db during pruning or restore (tree build)?
We run a full backup every week. The runtime is about 5 days (1,5 for
spooling and and 3-4 for writing the data to 7-9 220GB SDLT tapes). If
I try to restore some files from tape and let Bacula build the
filetree, the running backup job holds for about a day and I must
change tapes on saturday. We have two operating Tandberg drives, one
for the week-filling backup and one for tape labeling, formating,
restore and so on.
Is this the normal behaviour or must I have misconfigured something?
Hopefully there is someone hwo can point me to some helpfull links. I
can't find anything usefull through Google or directly in the manual.
Thanks in advance,
Christian
#
# Default Bacula Storage Daemon Configuration file
#
# For Bacula release 1.36.2 (28 February 2005) -- debian 3.1
#
# You may need to change the name of your tape drive
# on the "Archive Device" directive in the Device
# resource. If you change the Name and/or the
# "Media Type" in the Device resource, please ensure
# that dird.conf has corresponding changes.
#
Storage {
Name = bacula-sd
SDPort = 9103
SDAddress = 192.168.57.2
WorkingDirectory = "/var/lib/bacula"
Pid Directory = "/var/run/bacula"
Maximum Concurrent Jobs = 20
}
# List Directors who are permitted to contact Storage daemon
Director {
Name = bacula-dir
Password = "*****"
}
# Devices supported by this Storage daemon
# To connect, the Director's bacula-dir.conf must have the
# same Name and MediaType.
Device {
Name = SDLT-220-Drive0
MediaType = SDLT-220
ArchiveDevice = /dev/st0
AutomaticMount = yes
AlwaysOpen = no
RemovableMedia = yes
RandomAccess = no
MaximumNetworkBufferSize = 131072
VolumePollInterval = 60
# SpoolDirectory = /backup/bacula-spool
MaximumJobSpoolSize = 640g
}
Device {
Name = SDLT-220-Drive1
MediaType = SDLT-220
ArchiveDevice = /dev/st1
AutomaticMount = yes;
AlwaysOpen = no;
RemovableMedia = yes;
RandomAccess = no;
MaximumNetworkBufferSize = 131072
VolumePollInterval = 60
# SpoolDirectory = /backup/bacula-spool
MaximumJobSpoolSize = 40g
}
# Send all messages to the Director,
# mount messages also are sent to the email address
Messages {
Name = Standard
director = bacula-dir = all
}
#
# Default Bacula Director Configuration file
#
# The only thing that MUST be changed is to add one or more
# file or directory names in the Include directive of the
# FileSet resource.
#
# For Bacula release 1.36.2 (28 February 2005) -- debian 3.1
#
# You might also want to change the default email address
# from root to your address. See the "mail" and "operator"
# directives in the Messages resource.
#
###################################################################################################
# Job Job Job Job Job Job Job Job Job Job Job Job Job Job Job Job Job Job Job
Job Job Job Job Job #
###################################################################################################
# Backupjob Weekly
Job {
Name = "WeeklyBackup"
JobDefs = "UO-DefaultJob"
Schedule = "UO-Weekly-Cycle"
FileSet = "SundayExports"
Pool = "UO-Weekly"
Priority = 10
Write Bootstrap = "/var/lib/bacula/WeeklyBackup.bsr"
}
# Backupjob Monthly
Job {
Name = "MonthlyBackup"
JobDefs = "UO-DefaultJob"
Schedule = "UO-Monthly-Cycle"
FileSet = "SundayExports"
Pool = "UO-Monthly"
Priority = 10
Write Bootstrap = "/var/lib/bacula/MonthlyBackup.bsr"
}
## Backup the catalog database (after the nightly save)
# Weekly
Job {
Name = "BackupCatalog-Weekly"
JobDefs = "UO-DefaultJob"
Level = "Full"
Client = "localhost"
FileSet = "Catalog"
Pool = "UO-Weekly"
Schedule = "Catalog-Weekly-Cycle"
RunBeforeJob = "/etc/bacula/scripts/db-backup-create.sh"
RunAfterJob = "/etc/bacula/scripts/db-backup-remove.sh"
Write Bootstrap = "/var/lib/bacula/BackupCatalog.bsr"
Priority = 11 # run after main backup
}
# Monthly
Job {
Name = "BackupCatalog-Monthly"
JobDefs = "UO-DefaultJob"
Level = "Full"
Client = "localhost"
FileSet = "Catalog"
Pool = "UO-Monthly"
Schedule = "Catalog-Monthly-Cycle"
RunBeforeJob = "/etc/bacula/scripts/db-backup-create.sh"
RunAfterJob = "/etc/bacula/scripts/db-backup-remove.sh"
Write Bootstrap = "/var/lib/bacula/BackupCatalog.bsr"
Priority = 11 # run after main backup
}
# Standard Restore template, to be changed by Console program
Job {
Name = "RestoreFiles"
Type = "Restore"
Client = "backup-cache-fd"
FileSet = "SundayExports"
Storage = "SDLT-220-Drive1"
Pool = "Default"
Messages = "Standard"
Where = "/tmp"
}
# Defaults for UO-Backup jobs.
JobDefs {
Name = "UO-DefaultJob"
Type = Backup
Level = Full
Client = backup-cache-fd
FileSet = SundayExports
Storage = SDLT-220-Drive0
Messages = Standard
Pool = Default
Spool Data = yes
Spool Attributes = yes
Maximum Concurrent Jobs = 10
Priority = 10
}
###################################################################################################
# FileSet FileSet FileSet FileSet FileSet FileSet FileSet FileSet FileSet
FileSet FileSet FileSet #
###################################################################################################
# Sonntäglich exportierte Daten
FileSet {
Name = "SundayExports"
Include {
Options {
Hardlinks = no
Signature = "MD5"
}
File ="/raid/backup.universum.de/exports"
}
}
# Sonntäglich exportierte Daten
FileSet {
Name = "SundayExports_2007-11-04"
Include {
Options {
Hardlinks = no
Signature = "MD5"
}
File ="/raid/backup.universum.de/exports_2007-11-04"
}
}
# This is the backup of the catalog
FileSet {
Name = "Catalog"
Include {
Options {
Signature = "MD5"
}
File = "/backup/bacula-db-backup/bacula.sql"
}
}
######################################################################################################
# Schedule Schedule Schedule Schedule Schedule Schedule Schedule Schedule
Schedule Schedule Schedule #
######################################################################################################
# Weekly Backup
Schedule {
Name = "UO-Weekly-Cycle"
Run = Level=Full Pool=UO-Weekly 2nd-5th mon at 03:00
}
# Monthly Backup
Schedule {
Name = "UO-Monthly-Cycle"
Run = Level=Full Pool=UO-Monthly 1st mon at 03:00
}
# Weekly Catalog
Schedule {
Name = "Catalog-Weekly-Cycle"
Run = Level=Full Pool=UO-Weekly 2nd-5th mon at 03:30
}
# Monthly Catalog
Schedule {
Name = "Catalog-Monthly-Cycle"
Run = Level=Full Pool=UO-Monthly 1st mon at 03:30
}
#####################################################################################################
# Client Client Client Client Client Client Client Client Client Client Client
Client Client Client #
#####################################################################################################
# Backup Cache
Client {
Name = backup-cache-fd
Address = 192.168.57.1
FDPort = 9102
Catalog = MyCatalog
Password = "*****"
File Retention = 12 months
Job Retention = 12 months
AutoPrune = yes
}
# Localhost
Client {
Name = localhost
Address = 127.0.0.1
FDPort = 9102
Catalog = MyCatalog
Password = "*****"
File Retention = 12 months
Job Retention = 12 months
AutoPrune = yes
}
#######################################################################################################
# Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool Pool
Pool Pool Pool Pool Pool #
#######################################################################################################
# Default pool definition
Pool {
Name = Default
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes # Prune expired volumes
Volume Retention = 365 days # one year
}
# UO-Weekly
Pool {
Name = UO-Weekly
PoolType = Backup
Recycle = yes
AutoPrune = yes
VolumeRetention = 4 weeks
LabelFormat = "weekly-"
}
# UO-Monthly Webserver
Pool {
Name = UO-Monthly
PoolType = Backup
Recycle = yes
AutoPrune = yes
VolumeRetention = 12 months
LabelFormat = "monthly-"
}
###################################################################################################
# Storage Storage Storage Storage Storage Storage Storage Storage Storage
Storage Storage Storage #
###################################################################################################
# Definition of SDLT-220 tape storage device
Storage {
Name = SDLT-220-Drive0
Address = 192.168.57.2
SDPort = 9103
Password = "*****"
Device = SDLT-220-Drive0
Media Type = SDLT-220
}
Storage {
Name = SDLT-220-Drive1
Address = 192.168.57.2
SDPort = 9103
Password = "*****"
Device = SDLT-220-Drive1
Media Type = SDLT-220
}
###################################################################################################
# Console Console Console Console Console Console Console Console Console
Console Console Console #
###################################################################################################
# Restricted console used by tray-monitor to get the status of the director
Console {
Name = bacula-mon
Password = "*****"
CommandACL = status, .status
}
######################################################################################################
# Messages Messages Messages Messages Messages Messages Messages Messages
Messages Messages Messages #
######################################################################################################
#Messages {
# Name = Standard
# mailcommand = "/usr/lib/bacula/bsmtp -h mail.universum.de -f \"\(Bacula\)
%r\" -s \"Bacula: %t %e of %c %l\" %r"
# operatorcommand = "/usr/lib/bacula/bsmtp -h mail.universum.de -f
\"\(Bacula\) %r\" -s \"Bacula: Intervention needed for %j\" %r"
# mail = [EMAIL PROTECTED] = all, !skipped
# operator = [EMAIL PROTECTED] = mount
# console = all, !skipped, !saved
# append = "/var/lib/bacula/log" = all, !skipped
#}
Messages {
Name = Standard
mailcommand = "/usr/lib/bacula/bsmtp -h mail.universum.de -f \"\(Bacula\)
%r\" -s \"Bacula: %t %e of %c %l\" %r"
operatorcommand = "/usr/lib/bacula/bsmtp -h mail.universum.de -f \"\(Bacula\)
%r\" -s \"Bacula: Intervention needed for %j\" %r"
mail = [EMAIL PROTECTED] = all, !skipped, !restored
operator = [EMAIL PROTECTED] = mount
console = all, !skipped, !saved, !restored
append = "/var/lib/bacula/log" = all, !skipped
}
Messages {
Name = Daemon
mailcommand = "/usr/lib/bacula/bsmtp -h mail.universum.de -f \"\(Bacula\)
%r\" -s \"Bacula daemon message\" %r"
mail = [EMAIL PROTECTED] = all, !skipped
console = all, !skipped, !saved
append = "/var/lib/bacula/log" = all, !skipped
}
###################################################################################################
# Catalog Catalog Catalog Catalog Catalog Catalog Catalog Catalog Catalog
Catalog Catalog Catalog #
###################################################################################################
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = bacula; DB Address = localhost; user = bacula; password = "*****"
}
######################################################################################################
# Director Director Director Director Director Director Director Director
Director Director Director #
######################################################################################################
Director {
Name = bacula-dir
DirPort = 9101
DirAddress = 192.168.57.2
QueryFile = "/etc/bacula/scripts/query.sql"
WorkingDirectory = "/var/lib/bacula"
PidDirectory = "/var/run/bacula"
Maximum Concurrent Jobs = 3
Password = "*****"
Messages = Daemon
}
-------------------------------------------------------------------------
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
