Backup and restore for Amazon Aurora DSQL
Amazon Aurora DSQL helps you meet your regulatory compliance and business continuity requirements through integration with AWS Backup, a fully managed data protection service that makes it easy to centralize and automate backups across AWS services, in the cloud, and on premises. The service streamlines backup creation, management, and restoration for both single-Region and multi-Region Aurora DSQL clusters.
Key features include the following:
-
Centralized backup management through the AWS Management Console, SDK, or AWS CLI
-
Full cluster backups
-
Automated backup schedules and retention policies
-
Cross-Region and cross-account capabilities
-
WORM (write-once, read-many) configuration for all the backups you store
For more information on the features of AWS Backup Vault Lock and an extensive list of available AWS Backup features for Aurora DSQL, see Vault lock benefits and AWS Backup feature availability in the AWS Backup Developer Guide.
Getting started with AWS Backup
AWS Backup creates complete copies of your Aurora DSQL clusters. You can get started using AWS Backup for Aurora DSQL by following the steps in Getting started with AWS Backup:
-
Create on-demand backups for immediate protection.
-
Establish backup plans for automated, scheduled backups.
-
Configure retention periods and cross-Region copying.
-
Set up monitoring and notifications for backup activities.
Restoring your backups
When you restore Aurora DSQL clusters, AWS Backup always creates new clusters to preserve your
source data. To restore an Aurora DSQL single-Region cluster, use the https://console.aws.amazon.com/backup
Restoring an Aurora DSQL multi-Region cluster is only supported through the AWS CLI. To
restore an Aurora DSQL multi-Region cluster, you need to use both the AWS Backup and the Aurora DSQL CLI
To restore an Aurora DSQL multi-Region cluster.
-
Select the recovery point of your multi-Region cluster.
-
Copy the recovery point to another AWS Region that supports multi-Region clusters.
Note
Regions that don't support multi-Region clusters will result in a failed restore operation.
-
Start a restore job for each cluster using the AWS Backup CLI.
-
Use the Configuring multi-Region clusters documentation to peer the newly created Aurora DSQL clusters.
For detailed instructions on these steps, see Amazon Aurora DSQL restore documentation.
To restore to a multi-Region Aurora DSQL cluster, you can use a backup taken in a single AWS Region. However, before you initiate the restore process, you must first copy the backup to another AWS Region that supports multi-Region clusters. This step ensures that the restore operation can successfully complete. We recommend creating backup copies in key AWS Regions such as US East (N. Virginia), US East (Ohio), or US West (Oregon) to enable robust disaster recovery options and meet compliance requirements.
Monitoring and compliance
AWS Backup provides comprehensive visibility into backup and restore operations with the following resources.
-
A centralized dashboard for tracking backup and restore jobs
-
Integration with CloudWatch and CloudTrail.
-
AWS Backup Audit Manager for compliance reporting and auditing.
See Logging Aurora DSQL operations using AWS CloudTrail to learn more about logging records of actions taken by a user, role, or an AWS service while using Aurora DSQL.
Additional resources
To learn more about AWS Backup features and and using it in tandem with Aurora DSQL, see the following resources:
By using AWS Backup for Aurora DSQL, you implement a robust, compliant, and automated backup strategy that protects your critical database resources while minimizing administrative overhead. Whether you manage a single cluster or a complex multi-Region deployment, AWS Backup provides the tools you need to ensure your data remains secure and recoverable.
