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.
RDS News 2018: Valuable Insights and Safer Data
Data Insights That You Can Really Use
Nine months after Performance Insights was first introduced, AWS have now added two longer view options so you can get really intimate with the trends on your database. Being able to see issues that arise over the now standard 7-day view, users can take more time to analyse and repair any bottlenecks. The addition of Long-Term Retentions means you’re able to review and scrutinize performance data that is saved for up to two years — enabling you to think holistically. Along with these changes, AWS have enabled API and SDK access giving users the ability to do more in-house or speciality work with their own data.
Synchronised AWS Access
It seems that AWS are making more moves to bring together their services seamlessly. Those using RDS for PostgreSQL DB Instances can now use IAM to manage database access. All credentials are managed via IAM which means they’re organized from the same place across all AWS resources and have the usual features for selective access permissions, associating permissions with particular roles and revoking access altogether. It gives users one less administration task to worry about that could wreak havoc on your infrastructure.
Ever had that heart-pounding, lump-in-throat panic that you’ve accidentally deleted your database? AWS have introduced a default setting on all production RDS and Aurora instances so they can’t be deleted by any user. Managed via the Console or CLI, new and existing instances have the option to turn on or off Deletion Protection. When it is switched on and an attempt to delete is made, you will be blocked and won’t be able to make any changes without first changing the settings for that instance. Sweaty palms no more.
Best practice & Good Housekeeping
Some basic but vitally good habits to maintain your AWS RDS in its best shape.
- Keep a close and regular watch on your memory, CPU and storage usage. Whether it’s some idle instances or underutilized instances, your database has the potential to be more work and cost-efficient.
- Upsize as you need and ensure there is always a buffer against your DB instance storage — don’t get caught out by an unforeseen increase!
- Realistically look at your I/O capacity and change storage types to meet the needs of your instances, giving them a real chance to bounce back after failover or database failures.
- Test the failover procedure for your DB, so you can see how long it takes to failover to the new instance making use of AWS various Availability Zones
Cloud Conformity’s Golden Top Tips
- Like most AWS services, RDS is easiest to encrypt if encryption is turned on from day one. However, not all of us are that lucky! Here is a handy guide for encrypting an existing RDS database.
- Like most AWS services it is really quite easy to create a new RDS instance that is publicly facing. Luckily, we have a rule for that and it’s easy to get set up for Real-Time alerts to be sent through to your notification system of choice whether that is Slack, email or SMS.
Cloud Conformity has over 30 rules for RDS and is constantly adding additional rules.
Start your free, two-week trial today and connect your first AWS account in minutes to enjoy the continuous assurance of Cloud Conformity.