This course explores how to configure operational parameters for AWS Databases. We will cover some effective strategies for tuning your RDS databases to receive the most benefit for your workloads and we'll also dive into what parameter groups are, how parameter groups work, and some edge cases to watch out for.
If you have any feedback relating to this course, please contact us at support@cloudacademy.com.
Learning Objectives
- Create your own parameter groups and apply them to an RDS database
- Understand how parameter groups affect RDS instances and in what situations they are beneficial
Intended Audience
This lecture should be attended by those who are looking to further their database knowledge into the intermediate stages, or by those looking to understand the mechanisms behind tuning RDS databases.
Prerequisites
This lecture will talk about some of the more advanced ideas around Amazon RDS and databases in general, so it is highly recommended that you have a moderate to strong background in Amazon RDS and Relational databases.
The Amazon Relational database service (RDS) provides a robust, managed platform that allows you to spend your time avoiding the undifferentiated heavy lifting of creating your own databases. These out of the box databases provided by the service do give you incredible power, freedom, and flexibility to develop and build the way you want to. However, there are many times when you might need more than the standard out of the box deployments that come native with the service.
There are situations where your data set or the actions you perform on it, are putting a unique strain on your database, and you might suffer from adverse performance. You might notice undue slowdowns or the database chugging when you try to access certain elements.
Well, that is because behind the scenes there are over 400 unique parameters that RDS uses to function. These parameters control all kinds of configuration about the database that could be affecting your performance. So for this lecture, I wanted to take a moment to discuss parameter groups and how you can use them to get every little bit of extra tuning and power out of your database instances.
William Meadows is a passionately curious human currently living in the Bay Area in California. His career has included working with lasers, teaching teenagers how to code, and creating classes about cloud technology that are taught all over the world. His dedication to completing goals and helping others is what brings meaning to his life. In his free time, he enjoys reading Reddit, playing video games, and writing books.