AWS Products/Solutions – Admins Capsule

Regions Supporting various AWS Services.


Amazon RDS

  • You can think of a RDS DB Instance as a database environment in the cloud with the compute and storage resources you specify.
  • You can create and delete DB Instances, define/refine infrastructure attributes of your DB Instance(s), and control access and security via the AWS Management Console, Amazon RDS APIs, and Command Line Tools.
  • Multiple MySQL databases or SQL Server databases (up to 30) or Oracle database schemas can be created on a given DB Instance.
  • For optional Multi-AZ deployments (currently supported for MySQL and Oracle database engines), Amazon RDS also manages synchronous data replication across Availability Zones and automatic failover.
  • Amazon RDS FAQs
  • By default, customers are allowed to have up to a total of 20 Amazon RDS DB instances.
  • RDS cannot remove storage once it has been allocated. The only way to reduce the amount of storage allocated to a DB Instance is to dump the data out of the DB Instance, create a new DB Instance with less storage space, and load the data into the new DB Instance.
  • Unlike Multi-AZ deployments, Read Replicas use MySQL’s built-in replication and are subject to its strengths and limitations.This means recent database updates made to a standard (non Multi-AZ) source DB Instance may not be present on associated Read Replicas in the event of an unplanned outage on the source DB Instance. As such, Read Replicas do not offer the same data durability benefits as Multi-AZ deployments. While Read Replicas can provide some read availability benefits, they and are not designed to improve write availability. Read Replicas are currently supported for Amazon RDS for MySQL. They can also be used for serving read traffic when the primary database is unavailable.
  • The read replica mechanism uses MySQL’s native, asynchronous replication. This means replicas might be lagging behind the master as they try to catch up with writes. The interesting thing about this is that multi-AZ RDS instances apparently use another, proprietary type of synchronous replication.
  • A Read Replica will stay active and continue accepting read traffic even after its corresponding source DB Instance has been deleted. If you desire to delete the Read Replica in addition to the source DB Instance, you must explicitly delete the Read Replica using the DeleteDBInstance API or AWS Management Console.
  • By default and at no additional charge, Amazon RDS enables automated backups of your DB Instance with a 1 day retention period.
  • During the backup window, storage I/O may be suspended while your data is being backed up. This I/O suspension typically lasts a few minutes at most. This I/O suspension is avoided with Multi-AZ DB deployments, since the backup is taken from the standby.
  • Amazon RDS DB snapshots and automated backups are stored in S3.
  • If you desire to turn off automated backups altogether, you can do so by setting the retention period to 0 (not recommended).
  • When you delete a DB Instance, you have the ability to specify whether a final DB Snapshot is created upon deletion, which enables a DB Snapshot restore of the deleted database instance at a later date. All previously created DB Snapshots of your DB Instance will be retained and billed at $0.15 per GB-month, unless you choose to delete them.
  • Amazon RDS does not currently provide access to the binary logs for your Database Instance.
  • You are not charged for the data transfer incurred in replicating data between your source DB Instance and Read Replica. Billing for a Read Replica begins as soon as the Read Replica has been successfully created (i.e. when status is listed as “active”). The Read Replica will continue being billed at standard Amazon RDS DB Instance hour rates until you issue a command to delete it.
  • Amazon RDS primarily has 3 engines – Mysql Database Engine, Oracle Database Engine, Microsoft SQL Server Database Engine.
  • Setup RDS CLI.
  • RDS Terminology and Concepts.
  • How to Connect to RDS – MySQL.
  • RDS CLI – References.
  • Creating and Modifying  DB Instance.
  • Backing UP and Restoring DB Instances.
  • Viewing RDS Instance events.
  • working with  DB Parameter Groups, security groups, option groups & viewing DB instance metrics.
  • RDS Security Best Practices !!!
  • Tech Tips – Scaling Databases with Amazon RDS
  • Tech Tips – On Demand Test Databases
  • Tech Tips IV: Best Practices to Avoid an Inoperable RDS MySQL DB Instance
  • Tech Tips V: Defining CloudWatch alarms for Amazon RDS metrics
  • The default storage engine with RDS is InnoDB, but you are free to choose another, like the popular MyISAM. It is important to realize that read replicas on nontransactional storage engines (like MyISAM) require you to freeze your databases, as the consistency cannot be guaranteed when snapshotting. But if you use InnoDB, you are safe, and the only thing you have to do is fire up a new read replica.
  • RDS storage is independent of RDS instance classes. Every class can have from 5 GB to 1 TB of storage associated. Scaling up the storage is easy, and you can do it using the Console. It does require a reboot. On the other hand, scaling down the storage is impossible.
  • Reserved DB Instances page.
  • On-Demand DB Instances.
  • 10 things you should know about RDS.

Amazon DynamoDB

  • A fast, highly scalable NoSQL database service
  • A fully managed service that offers extremely fast performance, seamless scalability and reliability, low cost and more.
  • Amazon DynamoDB stores structured data, indexed by primary key, and allows low latency read and write access to items ranging from 1 byte up to 64KB. Amazon S3 stores unstructured blobs and suited for storing large objects up to 5 TB.
  • Video

Amazon SimpleDB

  • A NoSQL database service for smaller datasets.
  • A fully managed service that provides a schemaless database, reliability and more.

Your choice of relational AMIs

  • A relational database you can manage on your own.
  • On Amazon EC2 and EBS that provide scale compute & storage, complete control over instances, and more.

Amazon ElastiCache

  • Amazon ElastiCache is a web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud.
  • Amazon ElasticCache CLI Tool.


Amazon Elastic Cloud Compute (EC2)

  • Amazon Elastic Compute Cloud delivers scalable, pay-as-you-go compute capacity in the cloud.
  • Amazon EC2 Instance Types
  • EBS-Optimized instances are for selected types only such as – Standard Instances(Large,Extra Large), High-Memory Instances(High-Memory Quadruple Extra Large).
  • Amazon EC2 instances are grouped into seven families: Standard, Micro, High-Memory, High-CPU, Cluster Compute, Cluster GPU, and High I/O.
  • Amazon EC2 API (CLI Tools) and how to setup it.
  • Simple CLI Access to Amazon EC2 and S3

Amazon Elastic MapReduce

  • Amazon Elastic MapReduce is a web service that enables businesses, researchers, data analysts, and developers to easily and cost-effectively process vast amounts of data.

Auto Scaling

  • Auto Scaling allows you to automatically scale your Amazon EC2 capacity up or down according to conditions you define.
  • Auto Scaling CLI Tool.


Elastic Load Balancing

  • ELB API Tools.
  • Elastic Load Balancing automatically distributes incoming application traffic across multiple Amazon EC2 instances.


Amazon Elastic Block Store

  • Storage volume from 1GB to 1TB
  • EBS volumes automatically replicated within the same Availability Zone. This prevents data loss due to failure of any single hardware component.
  • These snapshots can be copied across AWS regions, making it easier to leverage multiple AWS regions for geographical expansion, data center migration and disaster recovery.
  • Initial limit – 5,000 volumes/account : 10,000 snapshots/account : 20 TiB in total standard storage volume
  • The block device driver for the instance assigns the actual volume names when mounting the volumes, and these names can be different than the names that Amazon EC2 recommends.
  • After you have mapped a device using one of these device names, it is mapped to either a scsi drive (sd[a-z]) or an xvd drive (xvd[a-p]), depending on the block device driver of your kernel. If the kernel has an xvd driver, the device is mapped to xvd[a-p]. If the kernel doesn’t have an xvd driver, the device is mapped to sd[a-z][1-15].
  •  You are limited to total of 16 EBS volume attachments on a Windows instance.

Amazon S3

  • Buckets are sort of like directories or folders with some restrictions
  • each user can only have 100 buckets at the most,
  • bucket names must be unique amongst all users of S3,
  • buckets can not be nested into a deeper hierarchy and
  • a name of a bucket can only consist of basic alphanumeric characters plus dot (.) and dash (-). No spaces, no accented or UTF-8 letters, etc.
  • s3cmd cli
  • Regions supported by amazon s3

One thought on “AWS Products/Solutions – Admins Capsule

  1. Amazon SimpleDB can be useful for those who need a non-relational database for storage of smaller, non-structural data and Amazon DynamoDB can be useful for those who need a fast, highly scalable non-relational database. Amazon SimpleDB offers simplicity and flexibility whereas Amazon DynamoDB offers good performance and incremental scalability. Amazon SimpleDB is cheaper than Amazon DynamoDB.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s