On 6/4/2012 12:06 PM, Phil Stracchino wrote: > On 06/04/2012 11:04 AM, Josh Fisher wrote: >> 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've given some thought to setting up a dedicated MySQL server, and if I > do get around to it I'm definitely planning SSD for it. Storage > throughput makes a huge difference to MySQL performance. I don't know > how much improvement there would be for Bacula, though, as I have doubts > about the performance tradeoffs in Bacula's MySQL code.
It makes a big difference for database-only stuff, like file selection during restore, pruning volumes, etc. I suppose if you have a lot of really fast servers to backup, then database performance would be a big factor for backups as well. My observations are with clients that are mostly too slow for it to matter. But I still wonder if using the SSD for attribute and data spooling might make a bigger impact, particularly if the clients were faster than the Bacula server to begin with. ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
