Periodic Backup and Recovery of ISD DB

To do periodic backup configuration in AWS

1. Create RDS in the AWS cloud with DB.

2. During database creation the backup retention period should be configured. Select the days from the dropdown as shown below. The days can be between 7 to 35.

3. The created DB is displayed as shown.

4. It contains the End point to connect to ISD.

5. External isd db can be configured in the services like:

   • oes-autopilot

   • oes-platform

   • oes-sapor

   • oes-datascience

   • oes-visibility

   • oes-audit

6. External DB configuration during installation with helm chart

  db:
  enabled: true
  url: jdbc:postgresql://database-1.cluster-cyjw4hmntwfy.us-east-1.rds.amazonaws.com:5432
  username: postgres
  password: encrypted:dbpassword:dbpassword

Enabling automated backups to existing DB

1. Sign into the AWS Management Console and open the Amazon RDS console.

2. In the Navigation pane, choose Databases, and then the DB instance or Multi-AZ DB cluster that you want to modify.

3. Choose Modify.

4. For Backup retention period, choose a positive nonzero value, for example 3 days.

5. Choose Continue > Apply immediately.

6. Choose Modify DB instance or Modify cluster to save your changes and enable automated backups.

Export backups to S3 bucket for longer period backup

1. Sign into the AWS Management Console and open the Amazon RDS console.

2. In the Navigation pane, choose Snapshots.

3. From the tabs, choose the type of snapshot that you want to export.

4. In the list of snapshots, select the snapshot that you want to export.

5. For Actions, choose Export to Amazon S3.

6. For Export identifier, enter a name to identify the export task. This value is also used for the name of the file created in the S3 bucket.

7. Choose the data to be exported:

8. Choose All to export all data in the snapshot.

9. Choose the bucket to export to.

10. For IAM role, either choose a role that grants you write access to your chosen S3 bucket, or create a new role.

11. For AWS KMS key, enter the ARN for the key to use for encrypting the exported data.

12. Choose Export to Amazon S3.

Restore backup configuration in AWS

Restore a DB instance from a DB snapshot

1. Sign in to the AWS Management Console and open the Amazon RDS console

2. In the Navigation pane, choose Snapshots.

3. Choose the DB snapshot that you want to restore from.

4. For Actions, choose Restore snapshot.

5. On the Restore snapshot page, for DB instance identifier, enter the name for your restored DB instance.

6. Specify other settings, such as allocated storage size. For information about each setting, see Settings for DB instances.

7. Choose Restore DB instance.

8. Once you click on the restore snapshot it will redirect to create a DB instance with snapshot.

9. After DB instance is created, get the configuration details and add to the ISD service.

10. External isd db can be configured in the services like

    • oes-autopilot

    • oes-platform

    • oes-sapor

    • oes-datascience

    • oes-visibility

    • oes-audit

11. External DB configuration during installation with helm chart

db:
enabled: true
url: jdbc:postgresql://database-1.cluster-cyjw4hmntwfy.us-east-1.rds.amazonaws.com:5432
username: postgres
password: encrypted:dbpassword:dbpassword

12. Once it is configured LOGIN to ISD and test the data.