dynamo连接mysql的数据,如何将数据从Amazon DynamoDB导出到MySQL服务器

I have no experience dealing with nosql databases such as Amazon AWS DynamoDB.

I have some data stored in Amazon AWS DynamoDB.

Is it possible to export data from DynamoDB to MySQL Server ?

If so, how to go about accomplishing that ?

Thanks,

解决方案

I would extract the data in CSV format. This "DynamoDBtoCSV" tool seems promising. Then you can import this CSV file into your MySQL database with LOAD DATA INFILE.

The drawback is that you 1. need to create the receiving structure first and 2. repeat the process for each table. But it shouldn't be too complicated to 1. generate a corresponding CREATE TABLE statement from the first line output by DynamoDBtoCSV, and 2. run the operation in a loop from a batch.

Now I am asking myself if MySQL is your best call as a target database. MySQL is a relational database, while DynamoDB is NoSQL (with variable length aggregates, non-scalar field values, and so on). Flatenning this structure into a relational schema may not be such a good idea.