Bacula-users

Re: [Bacula-users] Bacula giving slow speed

2009-01-15 02:50:12
Subject: Re: [Bacula-users] Bacula giving slow speed
From: "Holikar, Sachin (ext)" <sachin.holikar.ext AT siemens DOT com>
To: "Dan Langille" <dan AT langille DOT org>, "Michael Galloway" <mgx AT ornl DOT gov>, "Josh Fisher" <jfisher AT pvct DOT com>, "John Drescher" <drescherjm AT gmail DOT com>
Date: Thu, 15 Jan 2009 08:46:57 +0100
Hi,


Thanks all for your comments. Could not send reply as I was not in
office.
Anyways we have mysql database. 
We have decided to do the backups by increasing the spool area which is
currently set to 7 GB.
I will post the outcomes once we finish the testing.

Thanks once again.




-----Original Message-----
From: Dan Langille [mailto:dan AT langille DOT org] 
Sent: Mittwoch, 14. Januar 2009 21:58
To: Michael Galloway
Cc: John Drescher; Josh Fisher; Bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Bacula giving slow speed


On Jan 14, 2009, at 1:26 PM, Michael Galloway wrote:

> On Wed, Jan 14, 2009 at 10:53:13AM -0500, John Drescher wrote:
>>>> 3. There is no database backup as such. What we do is just take the
>>>> system level full backup.

I usually advise against system level full backups.  I recommend a  
proper
database backup.  For example, in PostgreSQL, this would involve running
pg_dump and creating a text file.  Or perhaps using PITR and backing  
up the
WAL logs.

In all cases, ensure that whatever database backup you are doing can get
you back to a known good position.

>>>> I believe he was suggesting that the Bacula catalog database  
>>>> might be stored
>>> on the same file system that is being backed up. Since Bacula must  
>>> write to
>>> its catalog database frequently during a backup, that would cause  
>>> disk
>>> thrashing and greatly affect performance.
>>>
>>
>> Exactly.
>>
>
> so, would it be considered a 'best practice' to have the catalog  
> database server that is on
> a separate machine that the bacula server?


I don't have mine on a different server, but I may not be backing up  
as much as you have.

I guess it depends.  It also depends on whether or not you run  
concurrent jobs.  And if you
spool attributes, most of the database access occurs after the Volumes  
have been written.

-- 
Dan Langille
http://langille.org/




------------------------------------------------------------------------
------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users