Amazon Web Service (AWS) Veri Tabanları

Giriş

Veri tabanları şöyle

1. Relational Database Service (RDS)

    Postgres, MySQL, etc. with Full SQL Support

2. RedShift

    Data warehouse with Full SQL Support

3. ElastiCache

4. DynamoDB

    NoSQL database : DynamoDB yazısına taşıdım

5. Aurora

    Serverless databases with Full SQL Support

6. Database migration service (DMS)

7. Elastic Map Reduce (EMR)

8. Keyspaces

    Managed Cassandra (key value) with Some - CQL

9. Neptune

    Graph database with Some - openCypher

10. Timestream

    Time series database with Partial SQL support

11. Quantum Ledger

    Cryptographically verified transactions with Some - PartiSQL

12. Athena

    Ad-hoc queries on S3 with Some - CTAS

13. Babelfish

    MSFT SQL Server on Aurora with Full SQL support

Bir tablo şöyle

AWS Relational Database Service (RDS)

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

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ı. 

Aurora Nedir - AWS'e Mahsus İlişkisel Veri Tabanı

AWS Aurora yazısına taşıdım

Redshift Nedir

AWS Redshift yazısına taşıdım

Elastic Map Reduce (EMR)

Açıklaması şöyle

AWS excels at managing large amounts of data transformations at scale and with parallel processing.

Amazon EMR, Amazon Batch, and AWS Lambda are all suitable for this, each with its own purpose.

- Amazon EMR can be used if you want to dedicate a cluster to large data transformations.

- Amazon Batch can be used for large batch processes to scale up and down automatically.

- AWS Lambda can be used to execute custom data transformation in parallel at unmatched speed.