Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Backup & restore DynamoDb tables

My aim is to back up and restore a dynamodb table to/from S3. I'm aware about the Import/Export using data pipelines and DynamoDb streams. My concern using Data Pipeline is that when the backup process is complete, I cannot be sure as to what 'point-in-time' the backup was performed. For e.g. if the backup process started at 11am and ended at 1130am, the items in my backup could be for anything that happened in the dynamodb table from 11am to 1130am.

How can I use DynamoDb streams to compliment the data pipeline ?

How can I restore the dynamodb table to a particular 'point-in-time' ?

like image 940
Mustafa Avatar asked Sep 19 '15 22:09

Mustafa


People also ask

What do mean by backup?

/ˈbæk.ʌp/ B2 [ C or U ] (someone or something that provides) support or help, or something that you have arranged in case your main plans, equipment, etc. go wrong: We're going to need some professional backup for this project.

Is it backup or back up?

Back-up is an alternative spelling of backup. Both spellings are used as either a noun or an adjective. The verb back up is always spelled as two words and never with a hyphen.

Is backup one word?

Backup – One word as a noun and adjective but two words as a verb. For example, “She will serve as a backup to the secretary.” “I hope we have a backup plan.” “I have to back up because a fallen tree across the road is blocking my way forward.”

What are the 3 types of backups?

Backup applications have long offered several types of backup operations. The most common backup types are a full backup, incremental backup and differential backup.


1 Answers

AWS have just announced they will now offer a native DynamoDB backup and restore function.

As of today, in most regions, you can create on-demand backups of DynamoDB tables. You can do this via the AWS console - click on a table and you will see a new Backup tab, or via an API call. Once you have created and named a backup you can restore to that point with a single click via the same console tab. You can also restore into new tables. All table artifacts (data, indexes etc) are backed up.

AWS promise no impact on your table performance and availability during backups.

At the moment its just 'on-demand' backups, meaning you have to create restore points manually. In early 2018 they will roll out "Point In Time Restore Points", meaning you simply enable backups and you can then restore to any point you require in the last 35 days.

like image 112
F_SO_K Avatar answered Sep 28 '22 14:09

F_SO_K