RDS

A database is a collection of information that is organized so that it can be easily accessed, managed and updated.

There are different kinds of database

1. Relational DB

  • A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

  • Amazon have a service called RDS (relational database service) including 6 different db MySQL, MariaDB, Microsoft SQL, Postgres, oracle, Aurora

2. Non-relational DB

  • A non-relational database is any database that does not follow the relational model provided by traditional relational database management systems.

  • DynamoDB is an example

3. Data warehousing DB

  • A data warehouse exists as a layer on top of another database or databases.

  • RedShift is an example.

Amazon RDS DB Instance

  • A DB instance is an isolated database environment running in the cloud.

  • A DB instance can contain multiple user-created databases.

  • We can have up to 40 Amazon RDS DB instances. Production environment mainly uses multi AZ deployment, it provides enhanced availability and data durability for instance.

  • RDS automatically provision and maintain a synchronous “standby” replica in different AZ.

  • RDS automatically fails over to the up-to-date standby database ensuring that database operations resume quickly without administrator intervention, in the event of planned database maintenance or unplanned service disruption.

Read Replica

  • It makes it easy for scaling it beyond the capacity constraints of a single DB instance for read-heavy database workloads.

  • They can be used for serving read traffic when the primary database is unavailable

DB Snapshot and Automated Backup

RDS provides 2 ways of backing and restoring your instance

  1. Snapshots

  2. Automated Backup

  • Snapshots are user triggered (can be automated via script or application)

  • Automated backup are automatic and give the ability to restore pointin-time.

  • Both are billable in terms of storage.

RDS Instances Type

RDS DB instances come in 2 type

1. Reserved DB instance

2. On-Demand instance

2 instance type are same except billing

  • On-demand is hourly basis.

  • Reserved require low up-front, one-time fee and in turn provides a significant discount on the hourly usage charge for the instance.

RDS vs DB on EC2 (check slide)

PreviousPRACTICALNextPractical

Last updated