Relational Database Service (RDS)

On the RDS console you can perform almost all necessary tasks – no programming required. RDS offers an automatic backup function and point-in-time recovery for the previous 35 days, supports high availability even across different availability zones, and a mirrored standby database can be added to the primary database which can be expanded to up 4 TB during ongoing operation.
 

• Recovery Point Objective: The maximum amount of data that a company can tolerate losing (Recovery Point Objective, RPO) is zero if a deployment has been selected as primary/standby. For single RDS instances, the maximum value of an RPO is set to five minutes, as an automatic incremental backup runs every five minutes. In the case of PostgreSQL, data replication between the primary/standby node is based on WAL logs.
• Primary node failover: RDS has a monitoring process that detects primary node failovers. If the primary node fails, the RDS monitoring process automatically changes the role from standby node to primary node. The failed primary node is recreated and is automatically assigned the role of the standby node. This means that the RPO after a failure is zero, as the Recovery Time Objective (RTO) takes less than 60 seconds for the role change.
• Automatic and manual backups: Automatic database backups run within the specified time window and can be adjusted at any time in the RDS console. Manual backups are possible at any time. After an automated daily full backup of a database is finished, an incremental backup starts automatically in the background and saves the changes of the last incremental backup every five minutes. Backups and incremental backups are saved in OBS and cannot be deleted.
• Recycle Bin functionality: After deleting a database, all automatic backups are automatically deleted, while manual backups remain untouched. At the same time, RDS creates a full backup of the database, which is temporarily stored in the Recycle Bin. The full backup contains all data up to the time of deletion. The period for temporary storage in the Recycle Bin has a default value of 7 days and can be changed at any time. If a new temporary period is selected by the user, this only applies to new RDS instances and all existing instances retain the previously selected temporary period.

It is also possible to upgrade a single-instance database to an active/standby database. RDS is available directly via an Elastic IP if desired. Active Directory in Microsoft SQL Server is currently not supported in all Microsoft SQL versions.

Billing is based on the hourly price of the selected virtual machines (VMs), while additional storage space for backups and images is billed in accordance with the type used for the respective storage variant.