Backing up and restoring an Aurora DB cluster
Last updated
Was this helpful?
Last updated
Was this helpful?
Note For Amazon Aurora DB clusters, the default backup retention period is one day regardless of how the DB cluster is created. You can't disable automated backups on Aurora. The backup retention period for Aurora is managed by the DB cluster.
Note
You can also use AWS Backup to manage backups of Amazon Aurora DB clusters. Backups managed by AWS Backup are considered manual DB cluster snapshots, but don't count toward the DB cluster snapshot quota for Aurora. Backups that were created with AWS Backup have names ending in awsbackup:AWS-Backup-job-number
. For information about AWS Backup, see the .
Note When you create a DB cluster using the AWS Management Console, you can't specify a backup window. However, you can specify a backup window when you create a DB cluster using the AWS CLI or RDS API.
Note
Your DB cluster must be in the available
state to take a DB cluster snapshot.
Note Sharing a manual DB cluster snapshot, whether encrypted or unencrypted, enables authorized AWS accounts to directly restore a DB cluster from the snapshot instead of taking a copy of it and restoring from that. For more information, see .
Important
If you use the console to restore a DB cluster, then Amazon RDS automatically creates the primary instance (writer) for your DB cluster. If you use the AWS CLI to restore a DB cluster, you must explicitly create the primary instance for your DB cluster. The primary instance is the first instance that is created in a DB cluster. Call the AWS CLI command to create the primary instance for your DB cluster. Include the name of the DB cluster as the --db-cluster-identifier
option value.
Important
If you use the console to restore a DB cluster, then Amazon RDS automatically creates the primary instance (writer) for your DB cluster. If you use the RDS API to restore a DB cluster, you must explicitly create the primary instance for your DB cluster. The primary instance is the first instance that is created in a DB cluster. Call the RDS API operation to create the primary instance for your DB cluster. Include the name of the DB cluster as the DBClusterIdentifier
parameter value.
Note Amazon bills you based upon the amount of Amazon Aurora backup and snapshot data you keep and the period of time that you keep it. For information about the storage associated with Aurora backups and snapshots, see . For pricing information about Aurora storage, see .
Note For Amazon Aurora DB cluster snapshots, you can't encrypt an unencrypted DB cluster snapshot when you copy the snapshot.
Note To share an automated DB cluster snapshot, create a manual DB cluster snapshot by copying the automated snapshot, and then share that copy. This process also applies to AWS Backup–generated resources.
Note The S3 bucket must be in the same AWS Region as the DB cluster.
Note Exporting DB cluster data can take a while depending on your database type and size. The export task first clones and scales the entire database before extracting the data to Amazon S3. The task's progress during this phase displays as Starting. When the task switches to exporting data to S3, progress displays as In progress. The time it takes for the export to complete depends on the data stored in the database. For example, tables with well-distributed numeric primary key or index columns export the fastest. Tables that don't contain a column suitable for partitioning and tables with only one index on a string-based column take longer because the export uses a slower single-threaded process.
Note The S3 bucket to export to must be in the same AWS Region as the snapshot.
Note Exporting RDS snapshots can take a while depending on your database type and size. The export task first restores and scales the entire database before extracting the data to Amazon S3. The task's progress during this phase displays as Starting. When the task switches to exporting data to S3, progress displays as In progress. The time it takes for the export to complete depends on the data stored in the database. For example, tables with well-distributed numeric primary key or index columns export the fastest. Tables that don't contain a column suitable for partitioning and tables with only one index on a string-based column take longer. This longer export time occurs because the export uses a slower single-threaded process.
Note While the primary DB instance is being created, it appears as a reader instance, but after creation it's a writer instance.
Important If you plan to use the AWS Management Console to export your DB cluster, you can choose to create the IAM policy and the role automatically when you export the DB cluster. For instructions, see .
Note Canceling an export task doesn't remove any data that was exported to Amazon S3. For information about how to delete the data using the console, see To delete the data using the CLI, use the command.
Important If you plan to use the AWS Management Console to export your snapshot, you can choose to create the IAM policy and the role automatically when you export the snapshot. For instructions, see .
Note Canceling a snapshot export task doesn't remove any data that was exported to Amazon S3. For information about how to delete the data using the console, see To delete the data using the CLI, use the command.
Note Information in this topic applies to Amazon Aurora. For information on restoring an Amazon RDS DB instance, see . For more information about backing up and restoring an Aurora DB cluster, see . For Aurora MySQL, you can restore a provisioned DB cluster to an Aurora Serverless DB cluster. For more information, see .
Important
If you use the console to restore a DB cluster to a specified time, then Amazon RDS automatically creates the primary instance (writer) for your DB cluster. If you use the AWS CLI to restore a DB cluster to a specified time, you must explicitly create the primary instance for your DB cluster. The primary instance is the first instance that is created in a DB cluster.
To create the primary instance for your DB cluster, call the AWS CLI command. Include the name of the DB cluster as the --db-cluster-identifier
option value.
Important
If you use the console to restore a DB cluster to a specified time, then Amazon RDS automatically creates the primary instance (writer) for your DB cluster. If you use the RDS API to restore a DB cluster to a specified time, make sure to explicitly create the primary instance for your DB cluster. The primary instance is the first instance that is created in a DB cluster.
To create the primary instance for your DB cluster, call the RDS API operation . Include the name of the DB cluster as the DBClusterIdentifier
parameter value.
Note To delete backups managed by AWS Backup, use the AWS Backup console. For information about AWS Backup, see the .