On Thu, 23 Apr 2009 13:10:27 +0200, Simon Ekstrand wrote:
> 2009/4/23 Ulrich Leodolter <ulrich.leodolter AT obvsg DOT at>:
>> Hi,
>>
>> On Thu, 2009-04-23 at 09:54 +0200, Simon Ekstrand wrote:
>>> Hi,
>>>
>>> I thought I'd just put in a note that we have just done a successful
>>> upgrade to bacula 3.0 for a bacula system running 7 storage daemons
>>> with a total of ~70 TB data (all disk based, no tapes). Everything is
>>> running smoothly so far.
>>> The catalog in use is a mysql db totaling approximatly 110 GB. We did
>>
>> Our catalog is about 18G, nice to hear that it works > 100GB. Are u
>> running catalog backups? how long runs mysqldump bacula? Would be nice
>> if you can share your hardware config (machines, cpu, mem, disk)
>
> The catalog server currently runs dual quad core 3ghz intel xeons, 8gb
> ram, 15krmp sas disks etc.
> We don't currently do any mysqldumps of the catalog db due to the
> horrible amounts of time required for a mysqldump of a db of this size.
> As a half-measure we instead do replication of the db to a second server
> so that we have a copy of the data in case of a hardware crash.
>
i think the only way to do a backup of large mysql databases without a
real downtime and acceptable restore times is to do "FLUSH TABLES WITH
READ LOCK" and make a lvm snapshot and backup the "snapshotted" mysql
data dir.
i've done a once restore of a 2 GB mysqldump database (monitoring data) .
it took about 1 hour (ok it wasn't a high perfomance machine).
- Thomas
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
