Subject Re: FB database in RAM
Author maik.sommer667

are you sure you can live with data loss in cause of system- powersupply- or emergency-shutdown-errors?
our database is about 42gb. that is the cause why we`re backing up just once a day. it has it`s own raid1-volume, and for performance reasons i am planning to add a raid5 with 4 fast ssd`s.

i think that could be a better option.

greetings from germany

Maik S.

--- In, Kjell Rilbe <kjell.rilbe@...> wrote:
> Hi,
> For performance reasons we're considering a setup where our 50+ Gbyte
> Firebird database would reside on a RAM-disk.
> I'd like to hear if anyone else has had experience with running large FB
> databases in RAM. Any problems? Performance compared to disk based? Any
> gotchas?
> The server has strong UPS at our hosting company, so we will accept
> nightly backups as "good enough". Backup would be done by bringing the
> system offline and copy the fdb file (currently not using nbackup due to
> an unresolved problem that we suspect was caused by nbackup). backup
> will be made both to local disks and to a remote rsync volume.
> The server is a Win 2008 web server, 64 bit.
> The current setup is with two RAID 1 volumes, one with OS, app etc, and
> the other with the database file and nothing else. Write cache enabled
> on the disks and forced writes off in the DB.
> Thanks,
> Kjell
> --
> ------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell.rilbe@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
> [Non-text portions of this message have been removed]