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.

What is the difference between Amazon RDS Read Replicas vs Multi AZ

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 dedicated video on this topic👇👇

What is Amazon RDS Read Replicas?

The read replica operates as a DB instance that allows only read-only connections. Applications connect to a read replica the same way they do to any DB instance. Amazon RDS replicates all databases in the source DB instance. The Oracle DB engine supports replica databases in mounted mode.

What is Amazon RDS Multi AZ?

RDS Multi-AZ. Amazon RDS Multi-AZ deployments provide enhanced availability for database instances within a single AWS Region. With Multi-AZ, your data is synchronously replicated to a standby instance in a different AZ.

How to Enable AWS Security Hub?

What is a security Hub?

AWS Security Hub provides you with a comprehensive view of your security state in AWS and helps you check your environment against security industry standards and best practices.

Security Hub collects security data from across AWS accounts, services, and supported third-party partner products and helps you analyze your security trends and identify the highest priority security issues.

Here is a Demonstration video on AWS Security Hub👇👇

Benefits of AWS Security Hub

• Reduced effort to collect and prioritize findings
• Automatic security checks against best practices and standards
• Consolidated view of findings across accounts and providers
• Ability to automate remediation of findings

Enable AWS Security Hub

• Once you have logged into your AWS account and enabled AWS Config, we need to enable Security Hub. Navigate to the AWS Security Hub console. Alternatively, you can just search for Security Hub and select the service.
• In the AWS Security Hub service console you can click on the Go to Security Hub orange button to navigate to AWS Security Hub in your account.
• Additional information is provided regarding Security standards and AWS Integrations. You can read more here. Now select Enable Security Hub.
• With AWS Security Hub now enabled in your account, you can explore the security insights AWS Security Hub offers.
• 
  

AWS new service AWS Private 5G

Amazon Web Services (AWS) announced the availability of a private 5G service for enterprises named AWS Private 5G.

Here is a fully dedicated video based on AWS Private 5G service👇👇

ABOUT 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 a Private Network?

A Private Mobile Network features network infrastructure which is used exclusively by devices authorized by the end user organisation. Typically, this is deployed in one or more specific locations which are owned or occupied by the end user organisation to deliver targeted coverage, capacity and other capabilities. Devices which are registered on public mobile networks will not work on the private network except where specifically authorised.

Benefits of Private networks?

• Offering enterprises a greater level of control over deployment, security, equipment and device choices

• Enabling highly targeted indoor/outdoor coverage

• High and reserved capacity

• Providing independence from public network

What are the benefits of AWS Private 5G?

This is a new managed service that helps enterprises set up and scale private 5G mobile networks in their facilities in days instead of months. With just a few clicks in the AWS console, customers specify where they want to build a mobile network and the network capacity needed for their devices. AWS then delivers and maintains the small cell radio units, servers, 5G core, and radio access network (RAN) software, and subscriber identity modules (SIM cards) required to set up a private 5G network and connect devices. AWS Private 5G automates the setup and deployment of the network and scales capacity on-demand to support additional devices and increase network traffic. There are no upfront fees or per-device costs with AWS Private 5G, and customers pay only for the network capacity and throughput they request.

Many enterprise networks are constrained by increasing growth in users, devices, and application demands. Increased video content, new applications that require ultra-low latency connectivity to end-user devices, and thousands of smart IoT devices demand extended coverage, more capacity, better reliability, and robust security and access control. Customers want to build their own private 5G networks to address these limitations, but private mobile network deployments require customers to invest considerable time, money, and effort to design their network for anticipated peak capacity, and procure and integrate software and hardware components from multiple vendors. Even if customers are able to get the network running, current private mobile network pricing models charge for each connected device and make it cost-prohibitive for use cases that involve thousands of connected devices. AWS Private 5G simplifies the procurement and deployment allowing customers to deploy their own 4G/LTE or 5G network within days instead of months, scale up and down the number of connected devices rapidly, and benefit from a familiar on-demand cloud pricing model.

AWS Private 5G is available in preview in the United States. To request access, visit the sign-up page here.

What is ETL and How it works?

What is ETL?

ETL stands for Extraction, Transform, and Load

Here is a fully dedicated video on the ETL Process

👇👇👇👇👇

ETL is a process that extracts the data from different source systems, 

then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. Full form of ETL is Extract, Transform and Load.

Why do you need ETL?

ETL tools break down data silos and make it easy 

for your data scientists to access and analyze data, and turn it into business intelligence. In short, ETL tools are the first essential step in the data warehousing process that eventually lets you make more informed decisions in less time.

How to Create and Restore RDS Snapshot in specific time ?

What is Amazon 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.