AWS Database Blog

Category: Expert (400)

Announcing distributed KV caching for self-hosted LLMs with Amazon ElastiCache

Announcing distributed KV caching for self-hosted LLMs with Amazon ElastiCache

Today, we are announcing the general availability of distributed KV caching with Amazon ElastiCache for Valkey, a capability that cuts self-hosted LLM inference costs by up to 40% and time to first token by up to 80%. Learn how it works, review benchmark results across workloads and models, deploy it on your own GPU fleet, and size the savings with the open-source KVTrace tool.

Multi-tenancy with Amazon ElastiCache: Choosing the right isolation model

Multi-tenancy with Amazon ElastiCache: Choosing the right isolation model

Choosing a multi-tenancy isolation model for Amazon ElastiCache for Valkey comes up in nearly every SaaS architecture review. This post walks through the options, from dedicated clusters to shared infrastructure with per-tenant encryption, and shows how to match each model to your blast radius and compliance requirements.

Run least-privilege AWS DMS CDC migration from SQL Server

Run least-privilege AWS DMS CDC migration from SQL Server

Configure AWS DMS change data capture (CDC) from a self-managed SQL Server source without granting sysadmin to the endpoint login. This least-privilege pattern uses certificate-signed wrapper procedures, granular permissions, and AWS Secrets Manager to meet separation-of-duties requirements while preserving full CDC functionality.

Working with foreign key constraints in Aurora DSQL

Working with foreign key constraints in Aurora DSQL

Amazon Aurora DSQL supports foreign key constraints, letting you enforce referential integrity directly in the database. This post covers defining foreign keys, immediate versus deferred enforcement, adding constraints to existing tables, and how optimistic concurrency control resolves conflicts in distributed workloads.

Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server

Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server

Learn how to use AWS DMS and a Db2 gateway server on Amazon EC2 to migrate and replicate data from an on-premises IBM Db2 database on z/OS to Amazon Aurora PostgreSQL. This post covers configuring the gateway, creating DMS resources, running a full load with periodic full-load refresh, and validating the migration.

How to stream PostgreSQL changes to Amazon S3 with AWS Fargate

How to stream PostgreSQL changes to Amazon S3 with AWS Fargate

In this post, we show you how to build a fully managed, event-driven change data capture (CDC) pipeline. It streams row-level changes from Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL to Amazon S3 in near real time. You deploy the entire pipeline with a single AWS CloudFormation template, and it can run in private subnets with no internet gateway without exposing resources to the public internet.

Megabytes in milliseconds: How Fire TV uses parallel queries and vertical partitioning to serve millions of customers in Amazon DynamoDB

How Amazon Fire TV redesigned its Continue Watching watch-progress data model on Amazon DynamoDB with vertical partitioning and hash-prefixed sort keys for parallel reads, removing item-size limits, cutting write costs by 97%, and keeping reads under 50 milliseconds at any profile size.

Oracle Machine Learning for SQL on Amazon RDS: Build machine learning models entirely in SQL

Oracle Machine Learning for SQL on Amazon RDS: Build machine learning models entirely in SQL

Learn how to build, train, and score a credit risk machine learning model entirely in SQL using Oracle Machine Learning for SQL (OML4SQL) on Amazon RDS for Oracle. The built-in AutoML feature selects the best algorithm automatically, with no data movement and no external machine learning platforms.