Subject RE: [firebird-support] BEST DRIVE (SAS OR SSD?) - Email found in subject
Author Leyne, Sean
Stephane,

> What is the best Hard Drive for firebird...
> SAS? RAID 0 or RAID 10? SSD ?
>
> i know about raid 0, but as we do backup everynight we accept the risk
> ...

DO NOT USE RAID 0!!!

Use an SSD* for the database file, use a separate/single HDD for boot/OS and database backups storage.

Schedule backups to run multiple times a day.


Sean

*do not use desktop SSDs, use Intel X25-E (it is the best) or Intel X25-M (it is the best desktop SSD). The SSD will provide read performance that is as good (if not better) as RAID 0 without any of the risks of RAID 0.