What is Amazon Aurora and How it's Work?

What is Amazon Aurora?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.

Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 128TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).

Here is a full tutorial video (Overview + Demo) based on AWS Aurora👇👇

Features of Amazon Aurora

• Scalability
• High throughput
• Instance monitoring and repair
• Encryption
• Easy to use
• Cost-effective
• Migration support
• Fully Managed

Amazon Aurora DB Cluster

Amazon Aurora DB cluster is a virtual database storage volume that spans multiple availability zones. Each Amazon Aurora Database Cluster is made up of two or more DB instances and a cluster volume that primarily manages the data for those DB instances. The following are the two types of DB instances that make up an Amazon Aurora Cluster: 

• Primary DB instance: This type of DB instance supports read and write operations and performs all data modifications to the cluster volume. Each Aurora DB cluster has one primary DB instance. 
• Aurora Replica: Unlike the primary DB instance, Aurora Replica only supports read operations. It is connected to the same storage volume as the primary DB instance. By locating Aurora Replicas in separate availability zones, high availability can be maintained.

Amazon Aurora Pricing

Amazon Aurora is paying as you go. It is comprised of 3 parts:

1. Hosting. You can choose from 3 different types of hosting depending on your needs
2. Storage and Operations. Storage is billed per gigabyte per month, and I/O is billed per million-request
3. Data transferred

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