AWS Database Blog

Category: Amazon RDS

Building an AWS CloudFormation custom resource to manage Amazon RDS point-in-time recovery

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 business logic and application features, leaving the heavy lifting to AWS. […]

Securing data in Amazon RDS using AWS KMS encryption

This post has been reviewed and/or updated on June 2022. Data privacy is essential for organizations in all industries. Encryption services provide one standard method of protecting data from unauthorized access. However, encryption changes data in a way that makes it unreadable without the correct decryption key. Amazon Relational Database Service (Amazon RDS) can encrypt […]

Best storage practices for running production workloads on hosted databases with Amazon RDS or Amazon EC2

October 2023: This post was reviewed and updated for accuracy. AWS offers multiple options to host your databases serving OLTP workloads – host your own managed database on Amazon EC2 instances or use Amazon RDS managed by AWS. RDS manages high availability, automated backups, database upgrades, OS patches, security, and read replica. RDS also offers […]

Deliver Amazon RDS Performance Insights counter metrics to a third-party Application Performance Monitoring service provider using Amazon CloudWatch Metrics Stream

This blog post was last reviewed or updated May, 2023. The updated version shown below is based on working backwards from a customer need to use RDS Performance Insights metrics in their APM tool for database observability. Amazon RDS Performance Insights is a feature that monitors Amazon Relational Database Service (Amazon RDS) database instances so […]

Select the right encryption options for Amazon RDS and Amazon Aurora database engines

Customers are increasingly choosing to encrypt their AWS Cloud databases and data stores by default. This trend is only gaining speed with the evolving meaning of sensitive data (personally identifiable information [PII], etc.) within various regulatory frameworks. Customers also ask AWS for guidance on how to best adopt the latest database encryption options, while maintaining […]

Right-size Amazon RDS instances at scale based on Oracle performance metrics

Enterprise customers who are currently running on-premises, mission-critical applications on commercial databases are looking for cost-efficient, managed database service offerings. Amazon Relational Database Service (Amazon RDS) is one of the target platforms for the relational database workload migration. RDS provides resizable capacity and manages time-consuming and undifferentiated heavy lifting administration tasks. For large-scale database migrations, […]

Migrating mission-critical SaaS production workloads to Aurora MySQL from RDS Classic

Sumo Logic started around the same time as the AWS stack was starting to mature. The company initially chose infrastructure that was tried and tested, but also cutting-edge at the time, namely Amazon RDS for MySQL instances. However, over time, that choice started to cost us a significant number of developer hours. Developers spent time […]

Leveraging SQLAgentOperatorRole in RDS SQL Server

This blog post was reviewed and updated May 2022, to improve readability by adding more step-by-step guidance. SQL Server is a relational database management system developed by Microsoft. Amazon RDS for SQL Server makes it easier to setup, operate, and scale SQL Server deployments in the Cloud. One of the RDS SQL Server components is […]