Bacula-users

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 10:01:52
Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience
From: Koldo Santisteban <ksantisteban AT gmail DOT com>
To: John Drescher <drescherjm AT gmail DOT com>
Date: Tue, 13 Apr 2010 15:59:25 +0200
thanks for your answer.
 The first stage was with mysql 5.0.77, and works with bacula 3.0.3 without problems. I have used the same database and server with bacula 5.0.1. The bacula server + DB is a 3,5 Gb Ram with a Xeon processor.
I have tested my environment installing postgree on the same server and with a empty db. I create full bacula server backup and then try to restore.
I have detected that the restore process works fine usgin bweb and bacula 5.0.1, what is the difference between bat and bweb?

On Tue, Apr 13, 2010 at 3:10 PM, John Drescher <drescherjm AT gmail DOT com> wrote:
> I am working with bacula 5.0.1. On first stage i setup the server with
> bacula 5.0.1 and Mysql, but, when i need to restore i have found that "the
> bulid tree process" take 10-12 hours (or more). I have read all about this
> issues and i can see that no exists any "magic" solution. In order to solve
> it, i have migrate from mysql to postgre, but i can see the same symtopms.
> Perhaps it works better, but, in my opnion, this is not serios on a
> production environment.
> If it´s possible, i will appreciate it people share their experience with
> bacula last version and this kind of issues. A couple of month ago i
> finished to deploy bacula on my environment, but now, i am considering to go
> back all.
> Please any comment regarding this case is welcome.
> Regards

You need to tune your database. Is it on a fast raid 5, 10, or 6? How
many files are in your dataset? Do you have 8GB of ram on your
database server or more? How big is your postgres database?

I have between 8 and 10 million files in my 30GB postgres database for
bacula and restore times are nothing like this. My database server is
5 years old. Although it is on a different machine than the director.

John

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>