On 5/31/2012 9:19 PM, Randy Katz wrote:
> Hi,
>
> Has anyone tried to use an SSD drive to house the MySQL database for 
> Bacula and understand the
> performance differences, if any? I am wondering if it will provide a 
> significant speed boost to running it
> on disk or not. Any clues might be very helpful, thanks.

Increased speed of what, exactly?

I moved a bacula db from a RAID1 array of two WD RE-4 drives to an old 
80 GB Intel X25-M, which is not one of the fastest compared to more 
recent SSDs. However it has random read and write performance that far 
exceeds hard drives. Whether or not it constitutes a significant speed 
boost for Bacula depends on whether or not MySQL was the bottleneck to 
begin with. In my case, catalog backup with mysqldump was significantly 
faster, file selection during a restore was more than twice as fast, 
pruning/purging volumes was much faster. However, there was only a 
modest improvement in backup job times. I turned off attribute spooling 
and it didn't much affect backup times. I have thought about moving the 
data spooling to SSD, but I suspect it would make little improvement.

In my case, I believe the clients themselves are the bottleneck. In 
fact, believe it or not, I wish there were a way to throttle backup 
speeds for particular clients. I have people that drop their network 
connection on Macbook Pros because they get hot and noisy (from the 
increased fan speed) when a backup is in progress, yet they take it home 
with them at night. It's getting hard to get a backup of those machines.



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users