Subject | Re: [Firebird-Architect] One way to scale Firebird put it on memory virtual disk or ramfs |
---|---|
Author | Roman Simakov |
Post date | 2013-01-22T13:04:18Z |
In any case you have no ACID properties for not read-only databases right?
2013/1/22 Sergey Mereutsa <serj@...>:
2013/1/22 Sergey Mereutsa <serj@...>:
> Hi!
>
> Moreover, you can add shadow to this database and you will gain speed on read, but will have the same speed as HDD on write.
>
> Other way to keep data from in-memory database - backup it periodically :)
>
> Tuesday, January 22, 2013, 1:11:05 PM, you wrote:
>
> m> On linux i can mount a partition in memory (Install ubuntu/debian)
>
> m> sudo mkdir /mnt/ram
> m> sudo mount -t ramfs -o size=200G ramfs /mnt/ram
> m> mount to show you the partitions mounted
>
> m> and then move your database into the ram partition
>
> m> http://aws.typepad.com/aws/2013/01/ec2-for-in-memory-computing-the-high-memory-cluster-eight-extra-large.html
>
> m> That large instance could help you with the Firebird cache
> m> settings also the extra SSD could do wonders
>
> m> Inspired by the stack overflow big fat server architecture
>
> m> http://highscalability.com/blog/2009/8/5/stack-overflow-architecture.html
>
>
>
> m> ------------------------------------
>
> m> Yahoo! Groups Links
>
>
>
>
>
> --
> Best regards,
> Sergey mailto:serj@...
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>