RDS ¶
Tldr
- Amazon
Relational Database Service
is a service that enables you to run relational databases in the AWS Cloud. - Amazon RDS is a managed service that automates tasks such as hardware provisioning, database setup, patching, and backups.
- With these capabilities, you can spend less time completing administrative tasks and more time using data to innovate your applications.
RDS offerings¶
Amazon RDS is available on 6 database engines, which optimize for memory, performance, or input/output (I/O). Supported database engines include:
- Amazon Aurora
- PostgreSQL
- MySQL
- MariaDB
- Oracle Database
- Microsoft SQL Server
Aurora¶
Amazon Aurora is an enterprise-class relational database. It is compatible with MySQL and PostgreSQL relational databases. It is up to 5 times faster than standard MySQL databases
and up to 3 times faster than standard PostgreSQL databases
.
Amazon Aurora helps to reduce your database costs by reducing unnecessary input/output (I/O) operations, while ensuring that your database resources remain reliable and available.
Consider Amazon Aurora if your workloads require high availability. It replicates 6 copies of your data across 3 Availability Zones and continuously backs up your data to Amazon S3.
Notes¶
- Multi-AZ RDS instances use synchronous replication to push changes.
- You cannot encrypt a running RDS instance; you have to create the instance with encryption enabled.
- Amazon RDS backups can be retained for up to 35 days, and no longer.