3 ms·
Well, two things with that. Three really. First, does AWS allow ramdisks? It's been a few years since I tried to mount a ram disk on Xen, but it was not possib
by jacques_chester 14y ago
Well, two things with that. Three really.
First, does AWS allow ramdisks? It's been a few years since I tried to mount a ram disk on Xen, but it was not possible at the time.
Second, most databases are smart enough to shuffle stuff into RAM for you, starting with indexes and commonly-accessed tables.
Third, the "D" in ACID stands for "Durable". If you want an in-memory store, use an in-memory store. RDBMSes do sorta kinda rely on the assumption that stuff written to disk is actually written to a disk.
- mariuz 14y agoYes it AWS allows ramdisks , here is the output from a machine root@ip-amazon-ip:/home/ubuntu# mkdir /mnt/ram mount -t ramfs -o size=2G ramfs /mnt/ram mount ramfs on /mnt/ram type ramfs (rw,size=2G) There are the cache and memory settings Fore Firebird but is better to put the main full database on the fastest storage and that is RAM for the moment In Firebird we have a nifty feature called Shadow that creates a life snapshots of the active database (Think of it as Replication in real time) so you can activate it and keep a safe database on the SSD/HDD http://ibexpert.net/ibe/index.php?n=Doc.DatabaseShadow http://ibexpert.net/ibe/index.php?n=Doc.DatabaseShadow