AWS Database Blog

This post is co-authored with Eric Boyer and Maria Hristova of Firmex. Firmex is a leading Virtual Data Room provider with more than 20,000 new rooms opened every year. In this post, we discuss how and why Firmex migrated 65,000 databases heterogeneously from their on-premises SQL Server to HAQM Aurora PostgreSQL-Compatible Edition.

In this post, we look at two capabilities in HAQM Bedrock Knowledge Bases that make it easier to build RAG workflows with HAQM Aurora Serverless v2 as the vector store. The first capability helps you easily create an Aurora Serverless v2 knowledge base to use with HAQM Bedrock and the second capability enables you to automate deploying your RAG workflow across environments.

In this post, we introduce postgres_get_av_diag(), a new function available in RDS for PostgreSQL to monitor aggressive autovacuum blockers. By using this function, you can identify and address performance and availability risks through actionable insights provided by postgres_get_av_diag().

Valkey is an open-source, distributed, in-memory key-value data store that offers high-performance data retrieval and storage capabilities, making it an ideal choice for scalable, low-latency modern application development. Originating as a fork of Redis OSS following recent licensing changes, Valkey maintains full compatibility with its predecessor while providing high performance alternative for its developers. Valkey […]

HAQM Relational Database Service (HAQM RDS) for MySQL currently supports a variety of Community MySQL major versions including 5.7, 8.0, and 8.4 which present many different features and bug fixes. Upgrading from one major version to another requires careful consideration and planning. For a complete list of compatible major versions, see Supported MySQL major versions […]

In this post, we dive deep into concurrency control, providing valuable insights into crafting efficient transaction patterns and presenting examples that demonstrate effective solutions to common concurrency challenges. We also include a sample code that illustrates how to implement retry patterns for seamlessly managing concurrency control exceptions in HAQM Aurora DSQL (DSQL).

Today, we’re excited to inform you about a new generative AI feature in DMS SC. You can now use advanced language models to streamline and enhance your migration workflow. In this post, we discuss the key capabilities of DMS SC with generative AI and how to enable it to offer you additional recommendations to reduce manual conversion effort and time.

Today, we introduce HAQM Aurora DSQL, the fastest serverless distributed SQL database for always available applications. It offers virtually unlimited scale, highest availability, and zero infrastructure management. It can scale to meet any workload demand without database sharding or instance upgrades. In this post, we discuss the benefits of Aurora DSQL and how to get started.

In this post, we show you how to use CodePipeline to streamline your Aurora database deployments. We dive into a detailed architecture and steps for using CodePipeline in conjunction with AWS CodeBuild and AWS Secrets Manager. By the end of this post, you’ll have a clear understanding of how to set up a robust, automated pipeline for your database changes, allowing you to focus on what really matters—delivering value to your customers through innovative features and optimized performance.

We are excited to announce HAQM Timestream for LiveAnalytics as a newly supported target endpoint for AWS Database Migration Service (AWS DMS). This addition allows you to move time-series data from an AWS DMS supported source database to Timestream. In this post, we show you how to use Timestream as a target for an example PostgreSQL source endpoint in AWS DMS.