Bacula-users

Re: [Bacula-users] Tuning for large (millions of files) backups?

2010-10-12 12:02:19
Subject: Re: [Bacula-users] Tuning for large (millions of files) backups?
From: Alan Brown <ajb2 AT mssl.ucl.ac DOT uk>
To: Bruno Friedmann <bruno AT ioda-net DOT ch>
Date: Tue, 12 Oct 2010 16:58:10 +0100
Bruno Friedmann wrote:

> Rude answer :
> 
> If you really want to use Mysql drop the myisam to innodb.
> But you don't want to use mysql for that job, just use Postgresql fine tuned 
> with batch insert enabled.

Seconded - having been through this issue.

You are going to hit a big pain point with myisam with that many files 
anyway (it breaks around 4 billion entries without tuning), but even 
inno will grow large/slow and need a lot of my.cnf tuning

Go straight to Postgres - you'll need it eventually anyway, then read up 
on tuning it. For large databases it runs faster and uses less memory.






------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
Spend less time writing and  rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users