AWS Database Blog

How Statsig runs 100x more cost-effectively using Amazon ElastiCache for Redis

This post was written by guest authors, Rodrigo Roim, Marcos Arribas, and Anu Sharma from Statsig. Today, developers use feature gates to control feature roll out to manage the risk of bad deployments, but some remain blind to how customers would respond to a new feature. Statsig is a modern feature management and product experimentation […]

Use Oracle Real Application Testing features with Amazon RDS for Oracle

February 2024: This post was reviewed and updated with the Amazon Elastic File System (EFS) integration in RDS for Oracle. The updates show how to use RDS for Oracle as source for Real Application Testing (RAT). Customers running databases in a self-managed environment face many challenges, such as scalability, performance, maintenance overhead, and reliability. To […]

Use Oracle Real Application Testing features with Amazon EC2

Customers running on an on-premises environment often face the challenges of scalability, performance, cost, and reliability. To increase resiliency, performance, and scalability, AWS has become the new norm to help and offer companies the benefits of the AWS Cloud. In this post, we use Oracle Real Application Testing (Oracle RAT) to help you evaluate differences […]

Architect a Managed Disaster Recovery on Amazon RDS for SQL Server: Part 2

In our last series of posts (Part 1, Part 2, Part 3, and Part 4) , we discussed disaster recovery (DR) terminology and compared the DR solutions available for SQL Server on Amazon Elastic Compute Cloud (Amazon EC2). In this series, we continue to cover the DR solutions available for Amazon Relational Database Service (Amazon RDS) […]

Architect a Managed Disaster Recovery on Amazon RDS for SQL Server: Part 1

The initial challenge that database administrators (DBA) encounter when planning disaster recovery (DR) for SQL Server is choosing from the many options available. The challenge does not stop there as DBAs must implement the selected technology and ensure that best practices are applied. Amazon Relational Database Service (Amazon RDS) is a managed service that makes […]

Deriving real-time insights with Amazon Timestream – now up to three times faster query response times

Amazon Timestream is a serverless time series database that customers across a broad range of industry verticals have adopted to derive real-time insights, monitor critical business applications, and analyze millions of real-time events across websites and applications. By analyzing these diverse workloads, in conjunction with the query access patterns and query concurrency requirements, we made […]

Manage your AWS DMS endpoint credentials with AWS Secrets Manager

When configuring AWS Database Migration Service (AWS DMS) endpoints, you previously had to maintain the source and target credentials in plain text. In December 2020, we announced the integration of AWS DMS and AWS Secrets Manager, which allows you to take advantage of the built-in credential management capability in Secrets Manager to manage, retrieve, and […]

How Coupa migrated from a self-hosted Redis to fully managed Amazon ElastiCache

This is a guest post by Ramesh Sencha, Lead Cloud Engineer at Coupa. Coupa Software (NASDAQ: COUP) is a leader in Business Spend Management (BSM). Coupa enables companies around the world with the visibility and control they need to spend smarter and safer. Coupa offers value to over 2,000 customers across the globe as a […]

Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices

We have seen customers overcoming rapid data growth challenges during 2020–2021.For customers working with PostgreSQL, a common bottleneck has been due to buffer_content locks caused by contention of data in high concurrency or large datasets. If you have experienced data contentions that resulted in buffer_content locks, you may have also faced a business-impacting reduction of […]

Best practices for upgrading Amazon RDS for Oracle DB instances from 12c to 19c

Amazon Relational Database Service (Amazon RDS) for Oracle provides newer versions of databases as they are introduced by Oracle so you can keep your DB instances up to date. These versions can include bug fixes, security enhancements, and other improvements. When Amazon RDS for Oracle supports a new version, you can choose how and when […]