AWS Relational Database - How to Create RDS Instance

 What is Relational Database Service (RDS)

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. 

It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. 

It frees you to focus on your applications so you can give them the fast performance, high availability, security, and compatibility they need.

Here is the full Hands-on video on this topic👇👇

Steps to create an RDS instance

Following are the steps to create an RDS Instance: 

1. Sign into AWS Management Console.  
2. Open the RDS console.  
3. In the upper-right corner, choose the region where you wish to create your instance.  
4. In the navigation pane, click on ‘Databases’.  
5. Click on ‘Create database’.  
6. Make sure ‘Standard create’ is chosen, then click on MySQL (or the database in which you wish to create an RDS database instance).  

7. In the ‘Templates’ tab, click on the ‘Dev/Test’ option.  
8. In the ‘Setting’ tab, set the following values:

• DB instance identifier
• Master username
• Auto Generate a password
• Master password
• Confirm password

9. In the ‘DB instance size’ option, give a value for the following variables:

• DB instance performance types
• DB instance class

10. In the ‘Storage’ and ‘Availability & durability’ section, leave the default values as is.
11. In the ‘Connectivity’ section, click on the ‘Additional connectivity configuration’ and set the below values in it:

• Virtual Private Cloud (VPC)
• Subnet group
• Publicly accessible- No
• VPC security groups
• Availability zone- No preference
• Database port- 3306

   The same is displayed in the below screenshot:

12. Click on the ‘Additional configuration tab, and provide a name for the ‘Initial database name’ variable. The default settings for other options need to be kept the same.
13. Now click on ‘Create database’.
14. It takes a few minutes for the instance to get created. It can be seen in the ‘Databases’ list as ‘Creating’.
15. Once it is created, it shows as ‘Available’.
16. The ‘Endpoint’ and ‘Port’ of the database instance can be viewed in the ‘Connectivity & security’ section.

Note: Make sure that your database instance is secure, by verifying that sources outside of the VPC can’t connect to the RDS database instance.

What is AWS RDS (Relational Database Services)

What is AWS?

Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully-featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies—are using AWS to lower costs, become more agile, and innovate faster.

What is Amazon RDS?

Amazon Relational Database Service (RDS) is a managed SQL database service provided by Amazon Web Services (AWS). Amazon RDS supports an array of database engines to store and organize data. It also helps with relational database management tasks, such as data migration, backup, recovery, and patching.

Here is a fully dedicated video on AWS RDS (Relational Database Services)

Amazon RDS facilitates the deployment and maintenance of relational databases in the cloud. A cloud administrator uses Amazon RDS to set up, operate, manage and scale a relational instance of a cloud database. Amazon RDS is not itself a database; it is a service used to manage relational databases.

What are the benefits of AWS RDS?

The main benefit of Amazon RDS is that it helps organizations deal with the complexity of managing large relational databases. Other benefits include the following:

• Ease of use. Admins don't need to learn specific database management tools. They also can manage multiple database instances using the management console. RDS is compatible with database engines that users may already be familiar with, such as MySQL and Oracle And it automates manual backup and recovery processes.
• Cost-effectiveness. According to AWS, customers only pay for what they use. Also, the time spent maintaining instances is reduced, because maintenance tasks, such as backups and patching, are automated.
• The use of read replicas routes read-heavy traffic away from the main database instance, reducing the workload on that one instance.
• RDS splits up compute and storage so admins can scale them independently.

 What is AWS S3 Intelligent-Tiering

S3 Intelligent-Tiering is an Amazon S3 storage class that analyzes an AWS user's stored data and automatically moves it between storage tiers based on usage frequency. It is designed to optimize storage costs for data with irregular or unknown access patterns.

Here is a full Demonstration video on AWS S3 Intelligent-Tiering👇

S3 Intelligent-Tiering features

A user can access S3 Intelligent-Tiering through the AWS Management Console, command-line interface, or S3 API. He or she can select this storage class when data is uploaded to S3, or move existing data into this class from another class. Lifecycle rules can also be established to transition data to another storage class, such as Amazon S3 Glacier, after a designated period.
The service monitors and predicts user behavior to determine the tier in which it will store data. Those predictions are the output of machine learning algorithms AWS built to analyze data traffic patterns across the trillions of objects stored in S3.
S3 Intelligent-Tiering is one of several S3 storage options designed around accessibility demands. S3 Intelligent-Tiering is not recommended for a user who knows data access patterns well.

AWS Container Services

What is AWS?

AWS (Amazon Web Services) is a comprehensive, evolving cloud computing platform provided by Amazon that includes a mixture of infrastructure as a service, platform as a service, and packaged software as a service offering. AWS services can offer an organization tools such as compute power, database storage, and content delivery services.

Amazon Elastic Container Service (ECS)

ECS is a highly scalable, high-performance container orchestration service that supports Docker containers and allows you to easily run and scale containerized applications on AWS. Amazon ECS eliminates the need for you to install and operate your own container orchestration software, manage and scale a cluster of virtual machines, or schedule containers on those virtual machines.

Here is a fully dedicated video on AWS Interview Question and Answers

Amazon Elastic Kubernetes Service

EKS makes it easy to deploy, manage, and scale containerized applications using Kubernetes on AWS.
Amazon EKS runs the Kubernetes management infrastructure for you across multiple AWS availability zones to eliminate a single point of failure. Amazon EKS is certified Kubernetes conformant so you can use existing tooling and plugins from partners and the Kubernetes community. Applications running on any standard Kubernetes environment are fully compatible and can be easily migrated to Amazon EKS.

Amazon Elastic Container Registry

Amazon Elastic Container Registry (ECR) is a fully-managed Docker container registry that makes it easy for developers to store, manage, and deploy Docker container images. Amazon ECR is integrated with Amazon Elastic Container Service (Amazon ECS), simplifying your development to production workflow. Amazon ECR eliminates the need to operate your own container repositories or worry about scaling the underlying infrastructure. Amazon ECR hosts your images in a highly available and scalable architecture, allowing you to reliably deploy containers for your applications. Integration with AWS Identity and Access Management (IAM) provides resource-level control of each repository. With Amazon ECR, there are no upfront fees or commitments. You pay only for the amount of data you store in your repositories and data transferred to the Internet.