Tag: rds

how to reset the AWS RDS instance password

Prabhin Prabharkaran

Hi All, this document shows how to reset the AWS RDS instance password. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security and compatibility they need. Configuration Step 1: log in to the AWS management console. Step 2: Select…

Read More

rds storage autoscaling

Prabhin Prabharkaran

Hi All, this document deals with rds storage autoscaling. Autoscaling helps to scale up and scale down your application or infrastructure based when a resource to its threshold limit. The scalability helps the administrator to relax and work freely without any tension. In other words, we can say that no manual intervention required to scale up and down. Nowadays most of all the cloud service providers provide the scalability feature as a service. If you consider aws provides your auto scaling feature to scale the infrastructure like ec2 instances based…

Read More

RDS instance version in aws

Prabhin Prabharkaran

Hi All, this document deals with how to upgrade RDS instance version in AWS. Here I have MariaDB RDS which is running on version 10.1, now i need to upgrade the same RDS to 10.2. Here are the steps to perform this. Configuration Step 1: Login to AWS console. Step 2: Select your RDS instance from RDS Service in the AWS console. Step 3: select modify option and choose the MariaDB version section. Step 4: From the drop-down select the version to be upgraded and apply the changes. That’s it…

Read More

how to enable slow query in AWS RDS

Prabhin Prabharkaran

Hi All, this document deals with how to enable slow query in AWS RDS Parameter group acts as the container where you can change engine configuration, like enabling slow query, enabling log_slow_rate_limit etc, Not all the configurations are modifiable, you know Amazon RDS is service, where you have only limited access. In other words, you are not a super admin. For that configuration you can see in the column whether the configuration can be changed or not, You see “Yes” or “NO” Here I will show you how to enable…

Read More