AWS RDS - Relational Database Service

Giriş

MySql, PostgreSQL gibi ilişkisel veri tabanı sağlar. Açıklaması şöyle

Amazon RDS is a web service that makes it easier to set up, operate, and scale a relational database in the cloud.

Açıklaması şöyle

Amazon RDS is one of the most basic AWS database services, used mainly for offloading your database management operations to a platform. Therefore, it is used for small or medium enterprises where the data volume is limited, and the functionalities required for company operations are not too complex.

Amazon RDS supports database engines such as MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server. It comes with workflows to secure your RDS instance using SSH and offers a straightforward cloud console for connecting.
Benefits

1. Amazon RDS is the most inexpensive service, thanks to its ease of usage and lack of complexity.
2. It is highly scalable and allows you to scale up to 32 vCPUs and 244 Gb of RAM.
3. This service is also easy to use and pretty fast.

Desteklenen ilişkisel veri tabanları şöyle

1. Aurora

2. Postgres SQL

3. MySQL Server

4. SQL Server

5. Oracle

6. Maria DB

RDS Özellikleri

Bunlar şöyle

- Multiple Availability Zones

- Optional Read Replicas
- Automatic Instance Backups

Replication - Postgres

Açıklaması şöyle

With RDS you can choose up to two replicas located in separate availability zones, providing one primary instance (writer) and the other two stand-by (reader) instances.

The communication between the primary and the stand-by instances is done synchronously to guarantee that no data is lost.

You have a specific reader endpoint that can help with the read latency, while directing the writes to the primary. If the primary is no longer fit to receive writes, a failover will take place and one of the stand-by instances will be promoted as the new primary within 35–60 seconds. During this time attempts to write are expected to fail.

By choosing this approach,you can achieve the redundancy needed, with expected uptimes of 99.95%.

Scaling RDS

Bunlar şöyle

- Scale Manually 

- Scale Automatically

Performance Insights

AWS RDS tarafından sağlanır, en fazla performans kullanan 10 tane SQL cümlesini gösterir.

Örnek - PostgreSQL

IP adresi "Publicly accessible" true olmalı. Inbound rule çalışmıyor. Silip tekrar yaratmak gerekebilir. Bir video burada

Örnek - MySQL

Şeklen şöyle. IP adresi "Publicly accessible" true olmalı.