RDS

Relational Database Service resource replication with Arpio

RDS Resources

Arpio replicates the following Amazon Relational Database Service resource types.

Database Instance

Arpio replicates RDS instances to the recovery environment. Replication happens by taking a snapshot of the database instance in your primary environment and copying the snapshot to the recovery environment.

Arpio supports the following RDS engine types:

  • mariadb (MariaDB)
  • mysql (MySQL)
  • oracle-ee (Oracle Database Enterprise Edition)
  • oracle-se (Oracle Database Standard Edition)
  • oracle-se1 (Oracle Database Standard Edition One)
  • oracle-se2 (Oracle Database Standard Edition Two)
  • postgres (PostgreSQL)
  • sqlserver-ee (Microsoft SQL Server Enterprise Edition)
  • sqlserver-ex (Microsoft SQL Server Express)
  • sqlserver-se (Microsoft SQL Server Standard Edition)
  • sqlserver-web (Microsoft SQL Server Web)

If your RDS infrastructure includes read replicas of your primary database, Arpio does not take snapshots of the replica servers. During recovery, though, Arpio will re-create the full topology including the primary server and all read replicas.

Snapshots of RDS instances are incremental from the prior snapshot. If 10 MB of data has changed on disk since the prior snapshot, only 10 MB of data must be copied to the recovery environment, regardless of how large the instance is.

If you are using RDS encryption at rest, Arpio handles provisioning an appropriate KMS key in the recovery environment, and AWS re-encrypts the snapshot with this key during the copy operation.

The following attributes are translated during replication:

Attribute Translation

Associated Roles

Database Parameter Group

Database Option Group

Monitoring Role

Subnet Group

Security Groups

Translated to corresponding entities that Arpio manages in the recovery environment
Availability Zones Arpio translates to a compatible availability zone in the recovery region, maintaining diversity across availability zones in that region
KMS Key If using encryption at rest, Arpio creates a new KMS key in the recovery environment that is uses to encrypt snapshots and any recovered database

The following resources are automatically selected into recovery points when an RDS Instance is selected:

  • Replicas of this instance that are in the same region
  • The primary database if this instance is a replica of another database in the same region
  • IAM Roles listed as associated roles or monitoring roles
  • Associated RDS Option Groups
  • Associated RDS Parameter Groups
  • Associated RDS Subnet Groups
  • Associated Security Groups
  • Any Secrets Manager secrets following the standard JSON secret structure where the 'host' field references the hostname of this database instance.

Option Group

Arpio replicates RDS Option Groups to the recovery environment.

The following attributes are translated during replication:

Attribute Translation
VPC Translated to corresponding VPC that Arpio manages in the recovery environment

The following resources are automatically selected into recovery points when an RDS Option Group is selected:

  • Security Groups referenced in any options within the Option Group

Parameter Group

Arpio replicates RDS Parameter Groups to the recovery environment.

No fields require translation during replication.

Subnet Group

Arpio replicates RDS Subnet Groups to the recovery environment.

The following attributes are translated during replication:

Attribute Translation
Subnets Translated to corresponding subnets that Arpio manages in the recovery environment
VPC Translated to corresponding VPC that Arpio manages in the recovery environment

The following resources are automatically selected into recovery points when an RDS Subnet Group is selected:

  • The VPC Subnets referenced by the subnet group