DDC Database Backup and Restore

Here is a detailed step-by-step procedure for AWS RDS backup and restore:

Backup Procedure:

• Sign in to the AWS Management Console and navigate to the Amazon RDS service.
• Select the appropriate RDS instance for which you want to create a backup.
• Go to the “Backup & Restore” tab for that RDS instance.
• Click on the “Create snapshot” button to initiate a manual backup. Provide a meaningful name for the snapshot.
• Wait for the snapshot creation process to complete. You can monitor the progress on the “Snapshots” page.
• Once the snapshot is created, it will be available for use as a backup.

Restore Procedure:

• Access the AWS Management Console and go to the Amazon RDS service.
• Select the RDS instance to which you want to restore the backup.
• Navigate to the “Backup & Restore” tab for that RDS instance.
• Click on the “Restore to point in time” button to initiate the restore process.
• Select the backup snapshot from the available list or specify a specific point in time to restore from.
• Configure the necessary parameters for the restored RDS instance, such as DB instance identifier, DB instance size, and security group.
• Review the restore settings and click on the “Restore DB instance” button to start the restoration.
• Monitor the progress of the restore process on the RDS console.
• Once the restore process is completed, the restored RDS instance will be available for use.

Note: It is important to ensure that you have the necessary permissions and access rights to perform these backup and restore operations on the AWS RDS service.

Please note that the above procedure provides a general overview of the backup and restore process for AWS RDS.

Production Plan:

In the production environment, a daily snapshot of the database will be taken, ensuring that data is backed up regularly and securely. The retention period for these snapshots is set to 45 days, allowing for long-term data recovery if needed. It is worth noting that the backup process is automated using the built-in RDS automatic daily backup feature, ensuring consistency and reliability.

Ongoing

Please be informed that the Terraform code responsible for the database restoration is currently under review. Once the code review process is complete and the necessary adjustments are made, we will provide a detailed step-by-step guide outlining the procedure for restoring the database. This ensures that the restoration process aligns with the approved standards and best practices of our infrastructure. We appreciate your patience and understanding during this review process.