AWS Database services (Intro and how to create a DB Instance)

Quick introduction to AWS Database services

AWS gives option for the following Database services:

Relational Database service:
MySQL, Aurora DB, PostGreSQL, Maria DB, Oracle and Microsoft SQL Server

DynamoDB
Fast, Fully Managed, NOSQL Database Service.
Link to documentation

Elasti-cache
In memory data store and cache service.
Link to documentation

Neptune
High performance graph database engine optimized for storing billions of relationships and querying the graph.
Link to documentation


How to create a DB instance and connect to it?

1. Login to AWS Console and services > RDS
2. Create a database. (I chose MySQL Free Trial)
3. Put in an instance name and username/password.
4. Once the database is created and available, one can connect to it using AWS Workbench. Link to documentation
5. Connecting to MYSQL DB Instance documentation

How to add buckets in S3

How to add buckets in S3?

1. Login to AWS Console and go to Services > S3
2. Put a name for the bucket. Click Next.
3. Click Next
4. If you need access via URL enable public access. Else click Next to keep it as a VPC (Virtual Private Cloud)
5. Click "Create Bucket"
6. View Bucket on console page
7. You can also delete your bucket by clicking delete (last screenshot)

AWS Storage Services

AWS Storage services is broken down into:

Simple Storage Service (S3) is designed to store and access any type of data over the internet.

Amazon Glacier  is the cheapest service and is used for long term data archiving.

Elastic Block Storage (EBS) is a highly available (low latency) block storage.

Elastic File Storage (EFS) is a network attached file system.

Storage Gateway enables hybrid storage between On Premise and AWS Cloud. It caches the most frequently used data in On Premise and less frequently used data in AWS Cloud.

Snowball is a hardware device used to migrate data. e.g Copy data from On Premise to Cloud.

Quick Introduction to AWS

What is AWS?

AWS is a global cloud platform. A hosting provider for one to run their applications on the cloud.

What do they do?

They provide

• Infrastructure as a service (IAAS). No need to manage backup or power supply to the units.
• Platform as a service (PAAS). e.g get Java as a service and one doesn’t need to manage the binaries.
• Software as a service (SAAS). e.g send emails.
• Cloud storage platform

Advantages?

• Stable services.
• Services are billed per hour and for storage per GB.
• Easy to sign in and start scaling.

List of services provided

EC2 (Elastic Compute cloud) 

• Bare servers. Run your software on those machines. 
• Steps:
• Choose an AMI (Amazon Machine Image) : OS, Software Info, Access Permissions.
• Can create customized AMIs or choose from a predefined one (AMI marketplace).
• Choose Instance type (HW) [Compute optimized, Memory optimized, GPU optimized, storage optimized or general purpose]
• Configure the instance [# of instances, IP, bootstrap scripts etc]
• Add Storage
• Configure security groups (configure access to your instance)
• Launch
• Select a public/private key (needed for access and security)

VPC (Virtual private cloud)

• Create networks in your cloud and run your servers on those networks

S3 (Simple Storage Service)

• File storage and sharing service

RDS (Relational Database Service)

• Run and manage databases (SQL, MySQL, Oracle etc) on the cloud.

Route 53

• Global DNS Service. Its a managed DNS service where one can point their DNS to Amazon and they take care of it. 

ELB (Elastic Load Balancer)

• Load balance incoming traffic to multiple machines.

Autoscaling 

• Add/Remove capacity on the fly.
• This should ideally be combined with ELB.