Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

Should I back up all DynamoDB tables across all Regions

12 June,2024 by Rambler

Question: I have a  AWS DynamoDB Global table spread across 2 regions . The usage is the application writes to Region 1 and replicates to the Region2. Should I back up all DynamoDB tables across all Regions ?

 

Answer: When you create a DynamoDB global table, it consists of multiple replica tables (one per Region) that DynamoDB treats as a single unit. But  the replicas created in the alternative Regions can also be backed up and restored individually. 

There are different ways of backing up DynamoDB - on-demand backups to both Service Native & AWS Backup , PointInTimeRecovery (PITR) but DynamoDB does not provide SLA for data durability - therefore backups are critical

With all these choices , there are number of  approaches and it will depend on the level of recoverability required and the purpose of the backup

Generally - For backing up DynamoDB global tables, a backup of DynamoDB tables in one Region should suffice and backing up all the replica tables in all Regions shouldn't be required. If the primary objective is to be able to recover user-error or corrupted  data, then PITR in one Region should be OK. Similarly, when preserving a snapshot for historic purposes such as regulatory requirements then backing up in one Region should suffice. The backed up data can be replicated to multiple Regions via the Backup Vaults replication mechanism in AWS Backup 

Ultimately - the answer depends on the data durability requirements ,purpose of the backup , compliance requirements and other specific RPO & RTO consideration 

 


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Should I back up all DynamoDB tables across all Regions


dba-ninja.com