RDS and Selecting the correct Storage.

[Denzil77777]

Good day to you,

When it comes to RDS and Selecting the correct Storage, (a) In relation to knowledge, (b) In relation to AWS industry Standards, and (c) in relation to SAA C03 exam, what are the key points to consider and the best way to remember.

Kind Regards,

Denzil

[Neil-TutorialsDojo]

Hi Denzil,

Good day to you!
To my knowledge, when it comes to selecting the correct storage for Amazon RDS, here are the key points to consider:

a) In relation to knowledge:

• Amazon RDS supports four main storage types: General Purpose SSD (gp3), General Purpose SSD (gp2), Provisioned IOPS SSD (io1), and Magnetic (legacy).
• General Purpose SSD (gp3) is the latest and recommended storage type for most workloads, providing a good balance between cost and performance, with a baseline of 3,000 IOPS and ability to burst up to 4,000 IOPS.
• General Purpose SSD (gp2) is an older generation but still a viable option for general workloads with bursty I/O requirements.
• Provisioned IOPS SSD (io1) is designed for I/O-intensive workloads that require low I/O latency and consistent performance, such as OLTP databases.
• Magnetic storage is a legacy option and should be avoided for most new deployments due to its lower performance and durability compared to SSD storage.

b) In relation to AWS industry standards:

• AWS recommends using General Purpose SSD (gp3) storage for most workloads, as it provides a good balance between cost and performance, with improved IOPS and throughput compared to gp2.
• For workloads with high I/O requirements or low latency needs, such as databases supporting online transaction processing (OLTP), AWS recommends using Provisioned IOPS SSD (io1) storage.
• AWS discourages the use of Magnetic storage for new deployments due to its lower performance and durability compared to SSD storage options.

c) In relation to the AWS Certified Solutions Architect – Associate (SAA-C03) exam:

• Understanding the different storage types available for Amazon RDS and their use cases is important for the exam.
• Candidates should be familiar with the characteristics of General Purpose SSD (gp3), General Purpose SSD (gp2), and Provisioned IOPS SSD (io1) storage, and when to choose one over the other based on workload requirements.
• Candidates should also be aware that Magnetic storage is a legacy option and should generally be avoided for new deployments.

To remember the key points:

• General Purpose SSD (gp3) is the latest and recommended choice for most workloads.
• Provisioned IOPS SSD (io1) is for I/O-intensive workloads with low latency requirements, such as OLTP databases.
• General Purpose SSD (gp2) is an older option but still viable for general workloads with bursty I/O needs.
• Magnetic storage is a legacy option and should be avoided for new deployments.

Pls refer to this AWS Documentation for more accurate information:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

Thank you very much for posting here. I hope this helps!

Regards,
Neil @ Tutorials Dojo

[Denzil77777]

Good day to you, Neil

Thank you so much for your technically explained answer, in relation to what I had posted here. RDS and storage.

Indeed, I have seen many questions in relation to this particular topic. However, I have not seen any of the Questions ans Answers, in relation to AWS latest, SSD (gp3).

Good that you highlighted of the exam, too, in your answer.

Thank you for the link, too.

Kind Regards,

Denzil