iCompaas Support

AWS Service:

Amazon Relational Database Service (RDS) makes it easier to set up, operate, and scale a relational database in the AWS Cloud. RDS provides few database products like MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server. RDS manages backups, software patching, automatic failure detection, and recovery. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Description of the finding:

Using an older version of instance classes may lead to slow performance or may incur costs and many things that are fixed in new versions.

Amazon RDS supports three types of instance classes: Standard, Memory Optimized, and Burstable Performance.

• Standard classes (includes m classes)

• Memory-optimized classes (includes r and x classes)

• Burstable classes (includes t classes)

Recommendation:

Consider upgrading instance class from db.r4 to db.r5

If your current DB Instance class is db.r4 which is a bit older, you can upgrade it to db.r5 which offers improved networking and Amazon Elastic Block Store (Amazon EBS) performance and they are powered by the AWS Nitro System, a combination of dedicated hardware and lightweight hypervisor.

Note: We recommend that you test any changes on a test instance before modifying a production instance so that you fully understand the impact of each change. Testing is especially important when upgrading database versions.

*Resource information Listed below*

Affected Service Dependencies: 

ElastiCache/DynamoDB/S3

Implementation Plan:

Pre Requisites:

1. Approval Required from the client for the downtime of the instance

2. Make sure all the configurations are noted: Engine version, AWS KMS key, Instance class 

3. Perform Snapshot of the Database as a backup

Current Status: (Check which Instance type is using currently)

1. Sign in to AWS console

2. Navigate to Amazon RDS service https://console.aws.amazon.com/rds/

3. Click on the Databases in the left navigation pane

4. Select the Database that you want to examine

5. You can find the current instance class by clicking on the database
   

• If you want to upgrade the instance class to db.r5 follow the implementation steps

Implementation steps:

1. Sign in to AWS console

2. Navigate to Amazon RDS service https://console.aws.amazon.com/rds/

3. Click on the Databases in the left navigation pane

4. Select the database that you want to upgrade

5. Click on the modify option on the top
   

6. Go to DB instance class section and Click on the down arrow to get options available
   
7. Choose db.r5 instance class type from the range of options
   
8. click on continue at the bottom
9. Review the changes you made and schedule the modification from the options available
   
10. once done with the review and scheduling click on Modify DB instance to apply changes or if you notice any mistake click on Back to go to the previous window
    

Status after Implementation:

After going through the implementation steps, perform the steps mentioned in the current status section to make sure that the changes have been applied successfully.

• Make sure the DB instance class that you changed(db.r5) is shown in the class section.

Back Out Plan: (If you want to rollback to the previous type)

If you want to roll back to the previous DB instance class at any moment, just follow the steps that you followed in the Implementation steps section, and then in the step where we want to choose DB instance class, select db.r4 for the rollback.

Perform snapshot that can be used for restoration in case of any disaster

1. Sign in to AWS console

2. Navigate to Amazon RDS service https://console.aws.amazon.com/rds/

3. Click on the Databases in the left navigation pane

4. Select the Database that you want to create snapshot

5. Click on the Actions on top and select Take snapshot
   

6. Give the snapshot name and click on Take snapshot

7. To restore from Snapshot 

   • Navigate to snapshots on the left navigation pane
     

   • Select the snapshot you want to restore and click on Actions on top
     

   • You will be asked with a few details that are required to restore the snapshot

   • Fill in all the details required and click on the Restore DB instance at the bottom

Note: Keep the Snapshot for 5 business days before discarding it.

Reference: 

Managing an Amazon RDS DB instance - Amazon Relational Database Service 

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html#USER_ModifyInstance.Settings

Total Cost Savings(Yearly)

• https://aws.amazon.com/ec2/instance-types/t2/

• https://aws.amazon.com/ec2/instance-types/t3/

Pricing examples

Product Details - t2.*

t2 instances are a low-cost, general-purpose instance type that provides a baseline level of CPU performance with the ability to burst above the baseline when needed. With On-Demand Instance prices starting at $0.0058 per hour

*Prices shown are for Linux/Unix in US East (Northern Virginia) AWS Region. Prices for 1-year and 3-year reserved instances are for "Partial Upfront" payment options or "No upfront" for instances without the Partial Upfront option. For full pricing details, see the Amazon EC2 pricing page.

Product Details - t3a.* instances

The t3a.* instances feature AMD EPYC, 7000 series processors, with an all-core turbo clock speed of 2.5 GHz. The AMD-based instances provide additional options for customers that do not fully utilize the compute resources and can benefit from a cost savings of 10%.