On 06/04/2012 11:04 AM, Josh Fisher wrote:
>
> 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'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.
(No, I have not considered moving to Postgres. Honestly, Postgres makes
my teeth bleed.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
alaric AT caerllewys DOT net alaric AT metrocast DOT net phil AT
co.ordinate DOT org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
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
|