Exploring Options on an Existing Your First RDS Database in AWS

This guide provides step-by-step instructions on how to explore different options and functionalities available in an existing RDS database in AWS.

Hafeez Baig
30 steps
4 minutes

Amazon Web Services

Refer to the following guide to learn how to use IAM in the cloud\ <https://scribehow.com/shared/Creating_an_IAM_User_and_User_Group_in_AWS_Management_Console__hWNiiXlcRJKFqYZZEJD-cg> Refer to this guide to learn how to create an RDS Database\ <https://scribehow.com/shared/Creating_Your_First_RDS_Database_in_AWS__npccXKYTRse0Ba8bG3fncg>

Sign in to **AWS Management Console** as an **IAM User** **Pre-requisite** - Ensure you have selected the AWS region closest to your location\ For this guide, we will be using us-east-2 (Ohio) as a preferred choice

Type **RDS** in the search bar and click on **Aurora & RDS** to view the Aurora & RDS Dashboard

**What is Aurora & RDS in AWS?** **Aurora & RDS** are managed database services by AWS that simplify the setup, operation, and scaling of relational databases in the cloud, with **Aurora** providing a high-performance, MySQL- and PostgreSQL-compatible engine for superior speed and reliability.

On the **Aurora & RDS** dashboard, click on the **Databases** from the left bar

**Databases** wizard will open, click on the DB identifier **mysqldatabase**

Scroll the page, click on the **Connectivity & security** tab to view **Connectivity & security** details

Scroll to the **Connected compute resource** section to view its details

**What are connected compute resources?** Connected compute resources are those automatically linked to a database either during database creation or through subsequent setup. Manually added compute resources, such as those connected via VPC security group rules, are not listed.

Scroll to the **Proxies** section to view the **Proxies**

**What are Proxies in Amazon RDS?** In Amazon RDS, proxies are a feature that helps manage database connections, particularly in applications with a large number of connections. RDS Proxy acts as an intermediary between your application and your RDS database instances, handling database connections from the application and pooling those connections to reduce the load on the database instances. It provides benefits such as improved scalability, connection pooling, and automated failover handling, helping to enhance the performance and resilience of applications using RDS databases.

Scroll to the **Security group rules** section to view the assigned Security groups to the Database

**What are Security group rules in Amazon RDS?** Security group rules in Amazon RDS control inbound and outbound network traffic to and from database instances, acting as virtual firewalls to manage access based on IP addresses and ports.

Scroll to the **Replication** section to view the **Replication** details

**What is Replication?** Replication in Amazon RDS involves copying and synchronizing data from one database instance to another for purposes like high availability, scalability, and disaster recovery.

Click on the **Monitoring** tab to view the CloudWatch Monitoring

**What is CloudWatch?** Amazon CloudWatch is an AWS service for monitoring and managing the performance of resources and applications, collecting metrics, setting alarms, and analyzing logs.

Click on the **Logs & events** tab to view the **CloudWatch alarms**

**What are CloudWatch alarms?** CloudWatch alarms notify users when metrics cross predefined thresholds, allowing for proactive monitoring and automated responses to deviations in resource or application performance.

Scroll to the **Recent events** section to view the events for the database

Scroll to the **Logs** section to view the Logs

**What are Logs in Amazon RDS?** Logs in Amazon RDS record events and activities within the database instance, providing insights into performance, security, and troubleshooting.

Click on the **Configuration** tab to view the **Instance** configuration

Click on the **Zero-ETL integrations** tab to view the **Zero-ETL integrations**

**What is Zero-ETL integrations?** Zero-ETL integrations in Amazon RDS allow direct querying and analysis of data from the RDS database without traditional Extract, Transform, Load processes, reducing complexity and data latency.

Click on the **Maintenance & backups** tab to view the **Maintenance** and **Pending maintenance** details

**What is Maintenance and Pending Maintenance?** - Maintenance in Amazon RDS involves routine tasks like software patching, backups, scaling, and health monitoring, as well as scheduled events such as maintenance windows and automated backups. - Pending Maintenance in Amazon RDS refers to scheduled but not yet executed maintenance tasks, such as software updates or security patches, necessary for database health and performance.

Scroll to the **Backup** section to view the **Backup** details

**What is Backup in Amazon RDS?** Backups in Amazon RDS involve copying data for recovery. Automated backups occur daily, retaining data for a defined period, while manual snapshots capture the instance's state at a specific moment, stored until deletion.

Scroll to the **Snapshots** section to configure the Snapshots for the Database

**What are Snapshots in Amazon RDS?** Snapshots in Amazon RDS are point-in-time backups of database instances, allowing users to manually capture and retain the entire state for data recovery purposes indefinitely.

Click on the **Tags** tab to view and Add tags

**What are Tags in Amazon RDS?** Tags in Amazon RDS are labels with key-value pairs that users can attach to resources for organization, management, access control, and cost allocation purposes.

Scroll to the **Recommendations** section to view the **Recommendations**

**What are Recommendationsin Amazon RDS?** Recommendations in Amazon RDS are suggestions provided by AWS to optimize database performance, cost-effectiveness, security, and reliability based on best practices and usage patterns.

To create a **Replica** of the database, on the top right corner click on the **Actions** dropdown button and select the option **Create read replica** to create a replica

To restore to point in time, select the option **Restore to point in time** from the **Actions** dropdown

**What is Restore to point in time?** The "Restore to point in time" option in Amazon RDS allows users to revert a database instance to a specific moment in the past, aiding in data recovery from accidents or corruption.

To Modify a DB instance, on top right corner click on the **Modify** button

**Modify DB instance: mysqldatabase** wizard will open, here select the DB engine version and identifier

Scroll to the **Instance configuration** section for Instance configuration

Scroll to the **Storage** section to select a Storage type for the Database

Scroll to the **Availability & durability** section for the Multi-AZ deployment

Scroll to the **Connectivity** section to configure the **Network type** and **DB subnet group**

Scroll to the **Database authentication** section for **Password authentication options**

Scroll to the **Maintenance** section to enable and disable the **Auto minor version upgrade** then click on the **Continue** button to complete the Modification of the Database

Congratulations on successfully exploring options with your first RDS database and completing the lab! Well done!