AWS Database Blog

Category: Compute

Migrate from Amazon EC2 to Amazon ElastiCache Serverless with zero downtime

Migrate from Amazon EC2 to Amazon ElastiCache Serverless with zero downtime

On October 20, 2026, Amazon ElastiCache introduced online migration to ElastiCache Serverless for Valkey from self-managed Valkey and Redis OSS on Amazon EC2 with zero downtime. This post shows what’s supported at launch, how online migration works, and how to run a migration in the ElastiCache console.

Automating Oracle Data Guard switchover and failover on Amazon EC2

Automating Oracle Data Guard switchover and failover on Amazon EC2

Oracle Data Guard keeps a standby database in sync for high availability and disaster recovery, but running switchover and failover by hand on Amazon EC2 is slow and error-prone. This post shows how to automate both with AWS Step Functions and AWS Lambda, running validated pre-checks, the role transition, post-checks, and RTO/RPO tracking end to end.

Migrate CLR code to AWS Lambda when upgrading Amazon RDS for SQL Server to 2025

Migrate CLR code to AWS Lambda when upgrading Amazon RDS for SQL Server to 2025

After upgrading Amazon RDS for SQL Server to 2017 or later, CLR strict security leaves user-defined CLR assemblies unusable. This post shows how to migrate CLR logic with no native T-SQL equivalent to an AWS Lambda function, invoked from SQL Server 2025 through sp_invoke_external_rest_endpoint behind Amazon API Gateway.

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.

Automated PII redaction for Amazon RDS for PostgreSQL audit logs

In this post, we show you how to deploy a serverless pipeline that creates an irreversibly redacted, queryable archive of Amazon RDS for PostgreSQL audit logs. The pipeline permanently removes Social Security numbers (SSNs), credit cards, email, names, and more than 30 types of personally identifiable information (PII) before storing clean logs in Amazon S3 for query through Amazon Athena.

Build a semantic ontology to power AI assistants on AWS – Part 1

Build a semantic ontology to power AI assistants on AWS – Part 1

In this post, we show you how to build a semantic ontology that helps your AI assistants navigate enterprise data efficiently. You’ll learn how to structure a property graph store for data relationships, set up vector indexing for semantic search, and implement an automated fact-learning layer that improves use. This bottom-up approach grounds your ontology in the data that exists, building abstractions from observed patterns rather than theoretical models.

User authentication and session management with Amazon Aurora DSQL

In this post, you learn how to design and implement a user authentication service with session management on Amazon Aurora DSQL. You see the full request flow from client to database and back, explore the design considerations specific to Amazon Aurora DSQL, and discover practical lessons from building and testing against a live cluster.

Building Financial Hierarchies with Amazon Neptune for Treasury Operations

Building Financial Hierarchies with Amazon Neptune for Treasury Operations

In this post, we show how Amazon’s Finance Technology (FinTech) team uses Amazon Neptune to model complex corporate treasury structures as a property graph. These structures include the legal entity relationships, intercompany agreements, and bank account associations that govern payment routing and cash management.

Automate Amazon Aurora PostgreSQL major or minor version upgrade using AWS Systems Manager and Amazon EC2

Managing Aurora PostgreSQL-Compatible Edition upgrades across multiple database clusters can be time-consuming and error-prone when done manually. In this post, we show you how to automate Amazon Aurora PostgreSQL upgrades across your entire database fleet through consistent, repeatable procedures.