Another Database Solution for EC2 - S3DFS and SQLite

An anonymous poster at the (very entertaining) Nanobeepers blog, reports on the use of Amazon EC2, Amazon S3, and the SD3FS file system from OpenFount to host the SQLite database. As he notes:

So, by adding EC2 instances that are all attached to the same S3 bucket, and using round-robin dns to distribute traffic among them, you can theoretically scale a web service infinitely. Just launch a new EC2 instance and add it to the round-robin dns pool and you're done! Even that could be automated to respond dynamically to traffic.

There's some additional information in the discussion thread.

Thanks to Jin for pointing me at the original blog post!

-- Jeff;

Comments

[Nicolas Toper]

"you can theoretically scale a web service infinitely." How do you handle different update/insert? If there are only select why not use a caching solution?