Can DynamoDB or SimpleDB replace my MongoDB use-case?

Question

I was wondering if DynamoDB or SimpleDB can replace my MongoDB use-case? Here is how I use MongoDB

• 15k entries, and I add 200 entries per hour
• 15 columns each of which is indexed using (ensureIndex)
• Half of the columns are integers, the others are text fields (which basically have no more than 10 unique values)
• I run about 10k DB reads per hour, and they are super fast with MongoDB right now. It's an online dating site. So the average Mongo query is doing a range search on 2 of the columns (e.g. age and height), and "IN" search for about 4 columns (e.g. ethnicity is A, B, or C... religion is A, B, ro C).
• I use limit and skip very frequently (e.g. get me the first 40 entries, the next 40 entries, etc)
• I use perl to read/write

Answer 1

I'm assuming you're asking because you want to migrate directly to an AWS hosted persistence solution? Both DynamoDB and SimpleDB are k/v stores and therefor will not be a "drop-in" replacement for a document store such as MongoDB.

With the exception of the limit/skip one (which require a more k/v compatible approach) all your functional requirements can easily be met by either of the two solutions you mentioned (although DynamoDB in my opinion is the better option) but that's not going to be the main issue. The main issue is going to be to move from a document store, especially one with extensive query capabilities, to a k/v store. You will need to rework your schema, rethink your indexes, work within the constraints of a k/v store, make use of the benefits of a k/v store, etc.

Frankly if your current solution works and if MongoDB feels like a good functional fit I'd certainly not migrate unless you have very strong non-technical reasons to do so (such as, say, your boss wants you to ;) )

What would you say is the reason you're considering this move or are you just exploring whether or not it's possible in the first place?