Subject Re: RES: [firebird-support] Re: Optimizing Firebird for SSD
Author Vander Clock Stephane
i think that Ram disk with strong power supply can be a good choice.
A soon as power faillure is detected the software stop the firebird and
copy the entire ram disk to the RAID disk before the UPS go down.
All the question is to find the good software and do all the test

in fact it's what you raid controler do internally :) he have a small
baterry
(he can keep the data in memory (generally 256 mb cache) for 72 hours)
and as soon he restart from a power faillure he write the data on the disk !



On 12/21/2011 10:34 AM, karolbieniaszewski wrote:
>
> Do you know what is RAM DISC?
> If not then "google" for it ;-)
>
> I can simple say that RAM DISC is some virtual disc created in RAM MEMORY.
> After creation you use it as normal hard drive (copy database on it
> and use as normal) with all benefits of RAM speed :)
>
> but you must remember that if power failure or some hardware error
> occur and your server stop - all data from RAM will be cleared.
> Because of that you must do backup in some short interval.
>
> e.g. your database is 3GB you can create RAM DISC 4GB and do backup to
> normal HARD DISC or better you can create RAM DISC 8GB and do backup
> to also RAM DISC and when backup process completed simple copy backup
> file to HARD DISC what is tone faster.
>
> RAM is now cheap - but i do not know what is your database size and
> what scenario can be accomplished.
>
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>, "Fabiano"
> <fabianoaspro@...> wrote:
> >
> > How put the entire database on RAM Disk?
> >
> >
>
>


[Non-text portions of this message have been removed]