> For the complete documentation index, see [llms.txt](https://awsfdn.adot8.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://awsfdn.adot8.com/module-8.md).

# Module 8

## Amazon Relational Database Service

| Unmanaged                                                     | Managed                                                                         |
| ------------------------------------------------------------- | ------------------------------------------------------------------------------- |
| Scaling, fault tolerance, and availability are managed by you | Scaling, fault tolerance, and availability are typically built into the service |
| Create, deploy, use                                           | Deploy and start using                                                          |

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FOirLIeZAJnGkvAopJ71w%2Fimage.png?alt=media&amp;token=9c1ac82a-a83a-4a65-9ab7-d9b50f053ff4" alt=""><figcaption></figcaption></figure>

### Amazon RDS (Managed Service)

**STORES DATA IN TABLES**

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2F39dBxBy4fREKIlWd53aZ%2Fimage.png?alt=media&amp;token=05682d61-3319-483b-8f1f-b3fbac7d3602" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Most of the database will be managed by AWS. We just interact with the application connected
{% endhint %}

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FktEgfcPXFjfmYkgGpv15%2Fimage.png?alt=media&amp;token=711344b1-00bc-4195-ad19-8d424700a38b" alt=""><figcaption></figcaption></figure>

### Topology

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FezOnequRxYxjDVIXOKP9%2Fimage.png?alt=media&amp;token=821139e2-7fee-4e87-a1e6-4fd89e491f80" alt=""><figcaption></figcaption></figure>

### Topology with HA using 2 AZ

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2Fi5C2aX9vX8VOTHddwOOc%2Fimage.png?alt=media&amp;token=e8f0c43d-75b1-4952-87b8-979fec9e2994" alt=""><figcaption></figcaption></figure>

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FZ3KlsdVEjLXKPr9sSuPe%2Fimage.png?alt=media&amp;token=e83e150b-475a-49f7-8cd1-774c931a2c16" alt=""><figcaption></figcaption></figure>

#### Use Cases

* Web and mobile applications
* Ecommerce applications
* Mobile and online games

### Amazon DynamoDB

**STORES DATA IN JSON FORMAT**

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FCr8UqZjIg7Brcgb752j6%2Fimage.png?alt=media&amp;token=d4f0c76a-1351-4507-bbdd-47b9de35d2b6" alt=""><figcaption></figcaption></figure>

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FPpxw7vGntvA2OMLDvtvC%2Fimage.png?alt=media&amp;token=2bd33e17-a628-48fa-bfd3-962d4c792cf0" alt=""><figcaption></figcaption></figure>

The JSON format comprises of Key:Value pairs. You can have multiple keys using Single and Partition keys

You can retrieve data from a DynamoDB table in two different ways:

* The query operation takes advantage of partitioning to effectively locate items by using the primary key.
* &#x20;Via a scan, which enables you to locate items in the table by matching conditions on non-key attributes. The second method gives you the flexibility to locate items by other attributes

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FZfooDZqqGywTssUbvNeM%2Fimage.png?alt=media&amp;token=510bce55-1404-4a3c-8b93-0d58a924a287" alt=""><figcaption></figcaption></figure>

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FFTlOXMtFIP4qDWkqKtY5%2Fimage.png?alt=media&amp;token=2101c0b5-5686-48ef-aadc-2c76d1db8096" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can add different Keys/Properties to the "Table" unlike real SQL DB tables which are fixed with the amount of Keys and Properties
{% endhint %}

### Amazon Redshift

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FZYwu5js2UdxMr7I5p6Nv%2Fimage.png?alt=media&amp;token=fadf8df9-1830-4a5e-b84d-1126b219a350" alt=""><figcaption></figcaption></figure>

### Compatibility

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2Fn9jehQFZ4S0M5SKLuJL0%2Fimage.png?alt=media&amp;token=5b5f5cfd-9022-4bd5-954e-293a6a1df054" alt=""><figcaption></figcaption></figure>

Amazon Redshift supports traditional/standard SQL. It also provides high-performance Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) connectors, which enable you to use the SQL clients and BI tools of your choice

### Amazon Aurora

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FS9asNDsHoLgJ3vhMXVe6%2Fimage.png?alt=media&amp;token=04816a8f-fe58-41c7-9c50-524b82f3b8d5" alt=""><figcaption></figcaption></figure>

Amazon Aurora is a MySQL-and PostgreSQL-compatible relational database that is built for the cloud.It combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases

* Amazon Aurora is designed to be highly available.
* It stores multiple copies of your data across multiple Availability Zones with continuous backups to Amazon S3.&#x20;
* Can use up to 15 read replicas can be used to reduce the possibility of losing your data

<figure><img src="https://739099499-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlOjiOVl4TnmLMyvNNyQJ%2Fuploads%2FnmHQlZTQCTzye02ACV5L%2Fimage.png?alt=media&amp;token=fa794346-09ce-4678-8f23-813f9768d7e9" alt=""><figcaption></figcaption></figure>