mongodb - AWS (or other cloud solution) for migrating large data? -


i have organized, non-relational data in both file system , sql database. there application queries both sources.

what cloud solutions storing data, equates 1tb? i'd able migrate data cloud solution , alter application query data in cloud.

so far, i've looked @ aws options: simpledb, dynamodb, , mongodb on ec2 intance ebs increased storage.

i've looked azure's table storage.

simpledb has 10gb limit. dynamodb on ssd , might overkill needs. did miss something? mongodb on aws or azure table storage suitable options?

i think solution depends heavily on data access patterns.

i've used azure table storage , it's great many things. i've used dynamodb , it's quite few things. both table stores, both have restrictions around read indexes, querying, , transactions. that's show stopper. both require retooling data , dependent applications.

for file storage:

  1. (cheapest, slowest) migrate files blob store (azure blob storage or aws s3) , leave them there. use s3 drive file access. slow, cheap.
  2. (performant) use ec2 instance ebs drives , store files there. access data on local file system. durable , performant.

for relational data, leave relational , store in cloud relational database server. (rds+mysql, rds+sql server, sql azure, etc).

there's no need change applications, , data patterns, moving cloud.


Comments

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

keyboard - Smiles and long press feature in Android -

node.js - Bad Request - node js ajax post -