Subject | FB database in RAM |
---|---|
Author | Kjell Rilbe |
Post date | 2011-08-03T12:25:49Z |
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]
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]