AWS -RDS -Amazon Relational Database Service

AWS Databases

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Overview of Amazon RDS

- When you buy a server, you get CPU, memory, storage, and IOPS, all bundled together. With Amazon RDS, these are split apart so that you can scale them independently. If you need more CPU, less IOPS, or more storage, you can easily allocate them.
- Amazon RDS manages backups, software patching, automatic failure detection, and recovery.
- To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges.
- Automated backups performed when you need them, or manually create your own backup snapshot. You can use these backups to restore a database. The Amazon RDS restore process works reliably and efficiently.
- You can get high availability with a primary instance and asynchronous secondary instance that you can fail over to when problems occur. You can also use MySQL, MariaDB, or PostgreSQL Read Replicas to increase read scaling.
- Security in your database package RDS databases by using AWS Identity and Access Management (IAM)

Amazon Web Services provides a number of database services.

AWS Databases by Applications

Regions and Availability Zones

Amazon cloud computing resources are housed in highly available data center facilities in different areas of the world (for example, North America, Europe, or Asia). Each data center location is called a region.

Each region contains multiple distinct locations called Availability Zones, or AZs. Each Availability Zone is engineered to be isolated from failures in other Availability Zones, and to provide inexpensive, low-latency network connectivity to other Availability Zones in the same region.

Amazon RDS Interfaces

There are several ways that you can interact with Amazon RDS.

AWS Management Console-->https://console.aws.amazon.com/rds/.

Command Line Interface-->https://docs.aws.amazon.com/cli/latest/reference/rds/index.html

Programming with Amazon RDS-->For more information, see Amazon RDS Application Programming Interface (API).https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/ProgrammingGuide.html

Amazon RDS Storage Types

Amazon RDS provides three storage types:

General Purpose SSD (also known as gp2),

Provisioned IOPS SSD (also known as io1)

Magnetic.

General Purpose SSD – General Purpose SSD , also called gp2, volumes offer cost-effective storage that is ideal for a broad range of workloads. These volumes deliver single-digit millisecond latencies and the ability to burst to 3,000 IOPS for extended periods of time. Baseline performance for these volumes is determined by the volume's size.

Provisioned IOPS – Provisioned IOPS storage is designed to meet the needs of I/O-intensive workloads, particularly database workloads, that require low I/O latency and consistent I/O throughput

Magnetic – Amazon RDS also supports magnetic storage for backward compatibility. We recommend that you use General Purpose SSD or Provisioned IOPS for any new storage needs.

Disk space

• Free Storage Space – How much disk space is not currently being used by the DB instance, in

megabytes.

Input/output operations

• Read IOPS, Write IOPS – The average number of disk read or write operations per second.

• Read Latency, Write Latency – The average time for a read or write operation in milliseconds.

• Read Throughput, Write Throughput – The average number of megabytes read from or written to disk

per second.

• Queue Depth – The number of I/O operations that are waiting to be written to or read from disk.

Network traffic

• Network Receive Throughput, Network Transmit Throughput – The rate of network traffic to and from

the DB instance in megabytes per second.