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.

AWS Interview Questions and Answers Based upon AWS EC2 Instance

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.

What is AWS EC2?

Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides secure, resizable compute capacity in the cloud. It is designed to make web-scale cloud computing easier for developers. Amazon EC2’s simple web service interface allows you to obtain and configure capacity with minimal friction. It provides you with complete control of your computing resources and lets you run on Amazon’s proven computing environment.

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

What are the features of AWS EC2 Instances?

• Amazon EC2 provides the ability to place instances in multiple locations. Amazon EC2 locations are composed of Regions and Availability Zones. Availability Zones are distinct locations that are engineered to be insulated from failures in other Availability Zones and provide inexpensive, low latency network connectivity to other Availability Zones in the same region. By launching instances in separate Availability Zones, you can protect your applications from the failure of a single location
• You only pay for what you use. It takes the cost of unused minutes and seconds in an hour off of the bill, so you can focus on improving your applications instead of maximizing usage to the hour.
• Different Amazon EC2 workloads can have vastly different storage requirements. Beyond the built-in instance storage, we also offer Amazon Elastic Block Store (Amazon EBS) and Amazon Elastic File System (Amazon EFS) to suit other cloud storage workload requirements. Amazon EBS provides persistent, highly available, consistent, low-latency block storage volumes for use with Amazon EC2 instances, while Amazon EFS provides simple, scalable, persistent, fully managed cloud file storage for shared access.
• Enhanced Networking enables you to get significantly higher packet per second (PPS) performance, lower network jitter, and lower latencies. This feature uses a network virtualization stack that provides higher I/O performance and lowers CPU utilization compared to traditional implementations.
• 
  

For more, you can refer to the given link below👇

Part-1 : https://www.youtube.com/watch?v=Zl2AkMGAnYc

Part-2 : https://www.youtube.com/watch?v=dO8sw2DWdMQ

Why do you need to be AWS Certified?

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.

HERE IS A FULLY DEDICATED VIDEO BASED ON "Why do you need to be AWS Certified"👇👇

Why AWS?

• On the Go Pricing
• The Free Tier
• Performance
• Deployment Speed
• Security
• Flexibility

Benefits of Getting an AWS Certification

Amazon Web Services (AWS) is the market leader among cloud service providers now. Why? It provides cost-effective services to organizations. The services of AWS are scalable and ideal for different business sizes.

Most important of all, AWS follows formidable security measures for safeguarding, monitoring, and maintenance of its data centers. As a result, AWS is staying at the top of the list of cloud service providers. So, the first reason to go for AWS certifications is the status of AWS. If you want to invest time and effort in learning about cloud technologies, then it’s better to choose the leader. 

Road Map of AWS Certification

Aws news date

Amazon RDS for MySQL and MariaDB Now Support R5 Instance Types

Posted On: Feb 21, 2019

You can now launch R5 instance types when using Amazon Relational Database Service (RDS) for MySQL and Amazon RDS for MariaDB. Amazon EC2 R5 instances are the next generation of Amazon EC2 memory optimized instances. R5 instances are based on the Amazon EC2 Nitro System, a combination of dedicated hardware and lightweight hypervisor which delivers practically all of the compute and memory resources of the host hardware to your database instance.

With a 1:8 vCPU to memory ratio, R5 instances are well suited for running memory intensive database workloads including transaction processing, data warehousing, and analytics. R5 instances introduce a new larger instance size, r5.24xlarge, which provides 96 vCPUs and 768GiB of memory per instance. Depending on your workload, you may be able to achieve up to a 39% performance boost with R5 instances compared to R4 instances.

You can scale up to the new instance types by modifying your existing DB instance in the AWS RDS Management Console. Refer to the Amazon RDS User Guide for more details.

Review the Amazon RDS pricing page for pricing and regional availability.

https://aws.amazon.com/about-aws/whats-new/2019/02/amazon-rds-for-mysql-and-mariadb-now-support-r5-instance-types/