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