Home icon

How Gen replayed a database workload from Oracle to Amazon Aurora

Database Blog

This article discusses how Gen replayed an Oracle database workload on Amazon Aurora PostgreSQL-Compatible Edition to validate the migration before cutover. The key points are:

Specifically, the article covers:

  • Workload characteristics: Java application with Oracle database, 10 TB data, 1000 QPS peak load, 90% read and 10% write
  • Solution overview: Capture requests using NGINX mirror module, API Gateway, Lambda, and stream to Kinesis. Replay requests from Kinesis to Aurora using Lambda.
  • Mirroring and replay strategies: Read-only replay to keep Aurora in sync with Oracle using AWS DMS. Read/write replay to break replication for testing.
  • Tuning playback rate: Use Kinesis enhanced fan-out, multiple Lambda consumers per shard, increase shards to match capture rate.
  • Benefits: Validate performance, sizing, upgrades, identify bottlenecks before migration.
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 3
2026
Migrating data from Oracle to Amazon Aurora DSQL
Jun 10
2026
How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation (Part 1)
Jun 9
2025
Streamline Amazon Aurora database operations at scale: Introducing the AWS Database Acceleration Toolkit
May 12
2026
Migrating Amazon RDS for PostgreSQL to Amazon Aurora using seeded logical replication

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.