I am working on an application which will run on an EC2 webserver. The app will use two databases, one small which manages the site/app and holds all such related data, the second will be a large database dedicated to the storage and retrieval of float values.
Even after reading through some of the AWS docs, I am still confused as to the best approach. Should this database be stored on an attached EBS volume or use SimpleDB, RDS or S3?
How would one store a database in S3? I have read that SimpleDB is a great solution for simple databases (which this database will be (no relationships, each table has only a id and value column)), however SimpleDB is not a great solution for large databases. Apparently storing metadata in SimpleDB then the main data in S3 is an approach, but I don't really understand how that works in the context of a database.
RDS sounds overkill as my database does not have relationships etc, whilst EBS can only be attached to one instance, isn't scalable (I don't think), and I think costly for large amount of data when compared to S3.
I would like a little explanation to fill the obvious gaps in my knowledge, but the main goal is to find the best solution for my needs, with my needs primarily being cheap storage and quick data retrieval.
Based on your requirements, AWS DynamoDB suits best for your scenarios.