AWS Cloud
  • Cloud Computing
  • AWS
  • Amazon IAM
  • Multi-Factor Authentication (MFA)
  • Amazon Elastic Compute Cloud (Amazon EC2)
  • PRACTICAL
  • EBS
  • PRACTICAL
  • Snapshot
  • PRACTICAL
  • AMI
  • PRACTICAL
  • SECURITY GROUPS
    • PRACTICAL
  • Elastic ip
    • PRACTICAL
  • Network interfaces
  • PRACTICAL
  • AWS CLI
  • Practical
  • BOOTSTRAP SCRIPTS
  • Practical
  • LOAD BALANCER
  • practical
  • AUTO SCALING
  • PRACTICAL
  • CloudWatch
  • Practical
  • CREATE A BILLING CYCLE
  • PRACTICAL
  • S3
    • Permision
      • S3 VERSIONING
        • PRACTICAL
      • Lifecycle Management
      • Practical
  • Static website hosting
    • PRACTICAL
  • Logging
  • PRACTICAL
  • Cross-region replication
  • Practical
  • S3 Multipart Upload
  • Storage Management
  • PRACTICAL
  • CDN
  • PRACTICAL
  • EFS
  • PRACTICAL
  • STORAGE GATEWAY
  • SNOWBALL
  • SNS
  • Practical
  • VPC
  • NAT
  • PRACTICAL
  • RDS
  • Practical
  • Amazon Aurora
  • PRACTICAL
  • Redshift
  • Route 53
  • PRACTCAL
  • CloudFormation
  • Practical
  • Lambda
  • Practical
Powered by GitBook
On this page

Was this helpful?

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 6 years ago

Was this helpful?