3 ms·

One way to scale Firebird Database is to put it on memory virtual disk or ramfs On linux i can mount a partition in memory (Install ubuntu/debian) sudo mkdir

by mariuz 14y ago

One way to scale Firebird Database is to put it on memory virtual disk or ramfs On linux i can mount a partition in memory (Install ubuntu/debian) sudo mkdir /mnt/ram sudo mount -t ramfs -o size=200G ramfs /mnt/ram mount to show you the partitions mounted and then move your database into the ram partition cp -rp /var/lib/firebird/2.5/data /mnt/ram That large instance could help you with the Firebird cache settings also the extra SSD could do wonders Inspired by the stack overflow big fat server architecture http://highscalability.com/blog/2009/8/5/stack-overflow-architecture.html http://highscalability.com/blog/2009/8/5/stack-overflow-arch...

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 ago
  Yes 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

by mariuz 14y ago

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 ago
Yes 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