Mastering the Cloud: Module 8-DataBases

Challenges of Relational Databases

1. Server maintenance and energy footprint.

2. Software installation and patches

3. database backups and high availability

4. Limits on Scalability

5. Data Security and OS installation along with patches

-> AWS provides Amazon RDS to address this issue of unmanaged relational databases i.e. it is a service that sets up, operates, and Scale relational databases without any ongoing administration.

-> So Amazon RDS resolves all the challenges mentioned above due to unmanaged services whereas the customer has to manage their application optimization.

Amazon RDS

1. DB Instance class
-> It covers the operations and management of CPU, memory, and network performance

2. DB Instance storage,
-> It deals with magnetic, general purpose, and provisioned IOPS

-> To generate a database instance, we need to specify the database engine to run and we have ‘six’ database engines;

1. MYSQL

2. Amazon Aurora

3. Microsoft SQL Server

4. Postgre SQL

5. MariaDB

6. Oracle

-> One of the powerful features of Amazon RDS is its ability to configure the database instance for high availability with a multi-availability zone deployment.

-> There is also a possibility to configure & implement RDS through a VPC.

-> Through multi-availability zone deployment, Amazon RDS automatically, generates a standby copy of the database instance in another available availability zone within the Same VPC-

-> It offers asynchronous replication and off-load read Queries and also we use Amazon RDS when the application requires complex transactions.

Relational(MYSQL) v/s Non-Relational Databases(NOSQL)

1. Data storage: Rows & columns — — key-value, document graph type

2. schemas: Fixed — — Dynamic

3. Querying: Uses SQL — — Focuses on a collection of documents

4. Scalability: Vertical — — Horizontal

Amazon DynamoDB

-> It is a NOSQL fast and flexible database service and is a database service for any Scale with virtually unlimited Storage also it is a Serverless Service-

-> Items can have differing attributes.

-> Low-latency Queries and auto Scaling to max number.

-> Scalable read/write throughput and Data in this are stored in solid state drives (SSD).

Amazon Redshift

-> It is a fast, fully managed data warehouse to analyze our data using SQL Queries. It automates infrastructure provisioning

-> It supports auto Scaling and a pay-as-you-go option.

Use cases:

1. Enterprise data warehouse (EDW)

2. Big data

3. Software as a Service

-> Amazon Redshift is best suited for analyzing the data using SQL and Business intelligence (BI) tools.

Amazon Aurora

-> It is a relational database Service that is built for the cloud.

-> Enterprise-class relational database and also compatible with MYSQL and postgress

-> Automate, time-consuming tasks Such as provisioning, patching, backup, recovery, failure detection, and repairs.

1. Managed Service

2. pay-as-you-go

3. Fast and available (High processing power up to 5X Faster)and it is simple and compatible.

4. Aws Database migration service is available and supported.

-> When compared to other database service options, amazon Aurora is the optimal one, because it can grow in storage size on its own.

-> Creating Read replicas, is a feature of RDS that allows for data redundancy across regions and also allows for offloading reads of D.B. (It improves database Scalability).

-> Hosting a database on an EC2 instance makes it a self-managed database.

-> Aws snowball, is used to transfer petabytes of data from on-premise locations to the Aws cloud.

-> Amazon RDS offers:

1. Automated patches and backups

2. you can resize the capacity accordingly.

— — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — — —

Congratulations! You’ve mastered the art of selecting and managing cloud-based databases on AWS. This knowledge empowers you to choose the most suitable database solution for your applications and leverage the scalability and flexibility of the cloud.

Leave a comment below with any questions or cloud computing concepts you’d like to explore further!

In the next module, Module 9: Cloud Architecture, we’ll dive deeper into designing robust and scalable cloud architectures. Get ready to explore best practices and design principles for building efficient and reliable cloud solutions on AWS!

Episode 7: https://medium.com/@harshithavineni81/mastering-the-cloud-module-7-storage-1141ff97043b

Episode 9: https://medium.com/@harshithavineni81/mastering-the-cloud-module-9-cloud-architecture-d6ba585cc0f4