Re: [Bacula-users] Check database when bacula-dir start
Perhaps by distributing the load over several director ? Le 9 avril 2012 22:42, John Drescher a écrit : > > Neither of these will effect the problem you are trying to solve. > > John > -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Check database when bacula-dir start
Do you think if I tuning databases with : http://www.newitperson.com/2011/01/reduce-bacula-dbcheck-time/ CREATE INDEX File_JobId_idx ON File(JobId); CREATE INDEX File_PathId_idx ON File(PathId); CREATE INDEX File_FilenameId_idx ON File(FilenameId); CREATE INDEX Path_PathId_idx ON Path(PathId); CREATE INDEX Job_FileSetId_idx ON Job(FileSetId); CREATE INDEX Job_ClientId_idx ON Job(ClientId); CREATE INDEX File_FilenameIdPathId_idx ON File(FilenameId,PathId); Or with : http://www.bacula.org/manuals/en/catalog/catalog/Catalog_Maintenance.html#SECTION00291000 CREATE INDEX file_jobid_idx on file (jobid); CREATE INDEX file_jpf_idx on file (jobid, pathid, filenameid); it will be faster? Le 6 avril 2012 18:10, John Drescher a écrit : > > I have a bacual-dir with ~250 clients. And each client has its own > catalog. > > > > When bacula-dir start, bacula-dir checks each database (~10s per client = > > ~45 minutes !!!) > > Meanwhile, the director is not accessible... > > > > How can I bypass that or reduce that ? > > > > I would try speeding up your database server perhaps by putting the > databases on an SSD or an array of them or at minimum a RAID10 of fast > harddrives. > > John > -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Check database when bacula-dir start
Le 6 avril 2012 18:10, John Drescher a écrit : > > I have a bacual-dir with ~250 clients. And each client has its own > catalog. > > > > When bacula-dir start, bacula-dir checks each database (~10s per client = > > ~45 minutes !!!) > > Meanwhile, the director is not accessible... > > > > How can I bypass that or reduce that ? > > > > I would try speeding up your database server perhaps by putting the > databases on an SSD or an array of them or at minimum a RAID10 of fast > harddrives. > > John > I have installed a Debian server Squeeze with a xen kernel (2.6.32-5-xen-amd64) and on a RAID10 (PERC H700NV with 6*600 SAS 15k). Then, I have installed FreeBSD 9.0 RELEASE servers on 2 VM : - 1 VM for bacula-dir 5.2.6 - 1 VM for PostgreSQL 8.4.11 And installed FreeBSD 9.0 RELEASE server on an independent server (bacula-sd 5.2.6) with zfs partitionning for the storage. Do you think that the configuration may slow ? -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Schedule : First day of month
Hi Nicolas, = 1st | 2nd | 3rd | 4th | 5th | first | second | third | fourth | fifth = sun | mon | tue | wed | thu | fri | sat | sunday | monday | tuesday | wednesday | thursday | friday | saturday "week-keyword" uses with "wday-keyword". Example : "jan *1st mon* at 00:00" -- Julien Le 6 avril 2012 07:43, Nicolas a écrit : > ** > > The syntaxe I used doesn't work : > > "jan 1st at 00:00am" > -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Check database when bacula-dir start
Hi, I have a bacual-dir with ~250 clients. And each client has its own catalog. When bacula-dir start, bacula-dir checks each database (~10s per client = ~45 minutes !!!) Meanwhile, the director is not accessible... How can I bypass that or reduce that ? Thanks in advance, -- Julien -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Deduplication / Base jobs
Hi,
I have read and tried to understand "File Deduplication" :
http://www.bacula.org/en/dev-manual/main/main/File_Deduplication_using_Ba.html
But it is not working :
# - POOL: base -
Pool {
Name= base_backup
Pool Type = Backup
Storage = storage
UseVolumeOnce = yes
Maximum Volume Jobs = 1
Volume Use Duration = 10 hours
Volume Retention= 1 month
Recycle Oldest Volume = yes
Label Format=
"${Job}.${Level:p/4/B/r:l}.${JobId}.${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
}
# - POOL: full -
Pool {
Name= full_backup
Pool Type = Backup
Storage = storage
UseVolumeOnce = yes
Maximum Volume Jobs = 1
Volume Use Duration = 10 hours
Volume Retention= 6 days
Recycle Oldest Volume = yes
Label Format=
"${Job}.${Level:p/4/F/r:l}.${JobId}.${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
}
# - POOL: incr -
Pool {
Name= incr_backup
Pool Type = Backup
Storage = storage
UseVolumeOnce = yes
Maximum Volume Jobs = 1
Volume Use Duration = 10 hours
Volume Retention= 6 days
Recycle Oldest Volume = yes
Label Format=
"${Job}.${Level:p/4/I/r:l}.${JobId}.${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
}
# - JOB: base -
Job {
Name = base_job
Type = Backup
Level= Base
Client = server_one
FileSet = fs_generic
Schedule = 00_base
Pool = base_backup
Max Run Time = 5 hours
Reschedule On Error = yes
Reschedule Interval = 1 hours
# Client Run Before Job= "bash -c '/usr/local/bin/dump_bacula.sh'"
Messages = Standard
}
# - JOB: cycle
Job {
Name = full_job
Type = Backup
Level= Incremental
Client = server_one
Base = full_job, base_job
Accurate = yes
FileSet = fs_generic
Schedule = 00_full_incr
Pool = incr_backup
Full Backup Pool = full_backup
Incremental Backup Pool = incr_backup
Max Run Time = 5 hours
Reschedule On Error = yes
Reschedule Interval = 1 hours
Messages = Standard
}
Schedule {
Name = "00_full_incr"
Run = Level=Fullmon at 23:00
Run = Level=Incremental tue at 14:30
Run = Level=Incremental wed at 14:30
Run = Level=Fullthu at 23:00
Run = Level=Incremental fri at 14:30
Run = Level=Incremental sat at 14:30
Run = Level=Fullsun at 23:00
}
Schedule {
Name = "00_base"
Run = Level=Full1st mon at 23:00
}
FileSet {
Name = "fs_generic"
Include {
Options {
signature= SHA1
basejob = pmugcs1
accurate = mcs
verify = pin1
onefs= no
checkfilechanges = yes
}
File = /etc
File = /root
File = /usr/local
File = /var/backups
File = /var/spool/cron
}
Exclude {
File = .snapshot
File = .journal
File = .fsck
}
}
Base and Full are the same size. I can not find a sample configuration and the
explanatory page is succinct.
Can you help me ?
Thanks in advance.
--
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
