Adrian Reyer:
> Make sure you have cache ram on your raid controller and a battery
> backup unit installed. MySQL and Postgres like to write in sync. With
> BBU+cache the write is completed as soon as the controller has the data,
> no need to wait for disks. I doubt RAID0 would gain you much if any.
Using a SSD for the database storage should speed up the setup
considerably. In my experience, they feel a bit like a in-memory database
;-).
RAID0 for the spinning disks won't give much of a win, because database
stuff is normally more bound to seek performance, than to io bandwidth, and
only the latter will improve in that setup.
regards,
Dietz
--
To be a bug is a dumb thing, a silly and a bump thing,
but to be a bug is something, and You're not a thing at all.
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|