All geek questions in one place

Can DynamoDB or SimpleDB replace my MongoDB firewall?

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

  • 15k records and I add 200 records per hour
  • 15 columns, each of which is indexed using (secureIndex)
  • Half of the columns are integers, the rest are text fields (which basically have no more than 10 unique values)
  • I run about 10 KB of reading per hour, and they are working very quickly with MongoDB right now. This is an online dating site. Thus, the average Mongo query searches for a range of 2 columns (for example, age and height), and the search “IN” contains about 4 columns (for example, ethnicity A, B or C ... religion is A, B, ro C)
  • I use the limit and skip very often (for example, I get the first 40 entries, the next 40 entries, etc.).
  • I use perl to read / write
+4
source share
2 answers

I assume that you are asking if you want to port directly to an AWS-based solution? Both DynamoDB and SimpleDB are k / v repositories, and therefore there will be no drop-in for document repositories such as MongoDB.

With the exception of the limit / skip one (which requires a more compatible with k / v approach), all your functional requirements can be easily met by one of the two solutions you mentioned (although, in my opinion, DynamoDB is the best option) but this will not be the main problem . The main problem is to move from the document repository, especially with advanced query capabilities, to the k / v repository. You will need to rework your schema, rethink your indices, work within the limits of the k / v store, take advantage of the k / v store, etc.

Honestly, if your current solution works, and if MongoDB feels like a good functional fit, I would certainly not migrate unless you have very strong non-technical reasons for this (for example, your boss wants you;))

What would you say is the reason you are considering this step, or are you just studying whether this is possible in the first place?

+10
source

If you plan to have your full AWS application, you can also consider using Amazon RDS (managed by MySQL). This is not clear from your description if you really need a MongoDB document model, so given only query capabilities, RDS may come close to what you need.

Migrating with SimpleDB or DynamoDB will likely require a rethinking of some functions based on aggregation requests. As for the choice between SimpleDB and DynamoDB, there are many important differences, but I would say that the most interesting from your point of view are:

+4
source

Source: https://habr.com/ru/post/1397342/

More articles:


All Articles