# Amazon Aurora

Amazon Aurora is a serverless relational database service compatible with PostgreSQL and MySQL.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## From instant Aurora PostgreSQL databases to production-ready in your VPC

DevFeed: [From instant Aurora PostgreSQL databases to production-ready in your VPC](<https://devfeed.tech/articles/from-instant-aurora-postgresql-databases-to-production-ready-in-your-vpc-144611.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/from-instant-aurora-postgresql-databases-to-production-ready-in-your-vpc/>)

Author: Saurabh Kothawade

Published: 2026-11-19T22:13:11Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [CIDR and subnets](<https://devfeed.tech/topics/cidr-and-subnets.md>), [ReAct agent Python](<https://devfeed.tech/topics/react-agent-python.md>)

Tags: [access-management](<https://devfeed.tech/tags/access-management.md>), [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agent](<https://devfeed.tech/tags/ai-agent.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-vpc](<https://devfeed.tech/tags/amazon-vpc.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cli](<https://devfeed.tech/tags/aws-cli.md>), [cli](<https://devfeed.tech/tags/cli.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [console](<https://devfeed.tech/tags/console.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [express](<https://devfeed.tech/tags/express.md>), [iam](<https://devfeed.tech/tags/iam.md>), [networking](<https://devfeed.tech/tags/networking.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [production](<https://devfeed.tech/tags/production.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [verify](<https://devfeed.tech/tags/verify.md>), [vpc](<https://devfeed.tech/tags/vpc.md>)

### AI overview

Aurora PostgreSQL clusters created with express configuration can now move into a VPC through one modify operation, keeping their data and endpoint. The move briefly drops existing connections, switches off the internet access gateway, and requires a prepared DB subnet group, security group, private network path for every client, and suitable IAM permissions. Afterward, verify that the cluster is available with VPC networking enabled and the gateway disabled, then confirm clients reconnect; failed moves can return to gateway access and emit an RDS event. The same operation can be run through the console, AWS CLI, or an AI agent. Agent roles can be scoped to approved clusters and explicitly denied permission to move databases back out of a VPC. Creating directly in a VPC is also supported, though it takes longer than the seconds-long default setup. Moving back to gateway access briefly interrupts connections, requires IAM database authentication, and is blocked while VPC-dependent features are active.

### Source excerpt

Amazon Aurora PostgreSQL express configuration now supports VPC networking. You can move an existing cluster into your VPC with a single modify operation, keeping its data and endpoint, from the console, the AWS CLI, or an AI agent. This post shows how to move and verify a cluster, and how to let an agent do it with IAM guardrails.

## Performance impact of excessive logging in Amazon Aurora PostgreSQL

DevFeed: [Performance impact of excessive logging in Amazon Aurora PostgreSQL](<https://devfeed.tech/articles/performance-impact-of-excessive-logging-in-amazon-aurora-postgresql-144312.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/performance-impact-of-excessive-logging-in-amazon-aurora-postgresql/>)

Author: Baji Shaik

Published: 2026-11-19T19:10:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Logging](<https://devfeed.tech/topics/logging.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [performance-engineering](<https://devfeed.tech/topics/performance-engineering.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [audit-logging](<https://devfeed.tech/tags/audit-logging.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bottleneck](<https://devfeed.tech/tags/bottleneck.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [logging](<https://devfeed.tech/tags/logging.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [throughput](<https://devfeed.tech/tags/throughput.md>)

### AI overview

In a pgbench test on Aurora PostgreSQL 17, verbose logging had little effect at 8 clients, but at 800 clients, logging every statement reduced throughput by about 10%; adding `pgaudit.log = ALL` cut whole-run throughput from 16,202 to 5,039 TPS. Sampling showed sessions mostly active on CPU rather than waiting on instrumented resources, and a 537 MB log file written in under a minute supported a bottleneck in log generation and writing. The article recommends checking `pg_settings`, correlating slow periods with `pg_stat_activity` wait events and RDS log-file sizes, and testing at production-like concurrency. For audit needs, it suggests narrowing logged statement classes or using `pgaudit.log_statement = off` to retain structured audit details while dropping embedded SQL text; it advises confirming the reduction on the workload.

### Source excerpt

Excessive database and audit logging can quietly become a performance bottleneck in Amazon Aurora and Amazon RDS for PostgreSQL. Using a reproducible pgbench example, this post shows when logging overhead is negligible and when it cuts throughput by about three times, how to spot it with wait events and log file evidence, and how to reduce it.

## Design responsible AI controls for Amazon Aurora PostgreSQL

DevFeed: [Design responsible AI controls for Amazon Aurora PostgreSQL](<https://devfeed.tech/articles/design-responsible-ai-controls-for-amazon-aurora-postgresql-141279.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/machine-learning/design-responsible-ai-controls-for-amazon-aurora-postgresql/>)

Author: InduTeja Aligeti

Published: 2026-11-18T21:38:22Z

Content type: article

Language: en

Sources: [Artificial Intelligence](<https://devfeed.tech/sources/artificial-intelligence.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [responsible-ai](<https://devfeed.tech/topics/responsible-ai.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [ai-governance](<https://devfeed.tech/topics/ai-governance.md>), [Amazon Bedrock Knowledge Bases](<https://devfeed.tech/topics/amazon-bedrock-knowledge-bases.md>), [audit](<https://devfeed.tech/topics/audit.md>), [API Logging](<https://devfeed.tech/topics/api-logging.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [ai](<https://devfeed.tech/tags/ai.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [amazon-bedrock-guardrails](<https://devfeed.tech/tags/amazon-bedrock-guardrails.md>), [chatbot](<https://devfeed.tech/tags/chatbot.md>), [controls](<https://devfeed.tech/tags/controls.md>), [design](<https://devfeed.tech/tags/design.md>), [guardrails](<https://devfeed.tech/tags/guardrails.md>), [logging](<https://devfeed.tech/tags/logging.md>), [pgvector](<https://devfeed.tech/tags/pgvector.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rag](<https://devfeed.tech/tags/rag.md>), [responsible-ai](<https://devfeed.tech/tags/responsible-ai.md>), [sources](<https://devfeed.tech/tags/sources.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [traces](<https://devfeed.tech/tags/traces.md>)

### AI overview

The article details an Explainability design for a customer-support RAG chatbot using Aurora PostgreSQL, pgvector, Aurora ML, and Amazon Bedrock. It embeds documents and queries with the same Titan Text Embeddings V2 model, retrieves tenant-scoped chunks by cosine similarity, applies Bedrock Guardrails for privacy and contextual grounding, and logs retrieved chunk IDs, scores, actually cited sources, guardrail traces, and model ID in SQL. It stresses protecting interaction logs with PII redaction or encryption and row-level security, and archiving records to S3 before purging. Amazon Bedrock Knowledge Bases is presented as a simpler option when its default retrieval and citations suffice; custom logging suits cases needing provenance in a user-managed schema. Limitations include guardrail latency and charges, approximate HNSW search that may return fewer results after filtering, grounding that does not verify source-document accuracy, and synchronous embedding generation for large ingestions.

### Source excerpt

Learn how to make RAG chatbot answers traceable with Amazon Aurora PostgreSQL, pgvector, and Amazon Bedrock Guardrails, logging sources, scores, and guardrail traces in SQL.

## How United Airlines streams database changes to Apache Iceberg with Amazon Data Firehose

DevFeed: [How United Airlines streams database changes to Apache Iceberg with Amazon Data Firehose](<https://devfeed.tech/articles/how-united-airlines-streams-database-changes-to-apache-iceberg-with-amazon-data-firehose-141918.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/architecture/how-united-airlines-streams-database-changes-to-apache-iceberg-with-amazon-data-firehose/>)

Author: Guillaume Dupont

Published: 2026-11-18T20:37:39Z

Content type: article

Language: en

Sources: [AWS Architecture Blog](<https://devfeed.tech/sources/aws-architecture-blog.md>)

Topics: [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [AWS Glue](<https://devfeed.tech/topics/aws-glue.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [streaming data to S3 with Parquet](<https://devfeed.tech/topics/streaming-data-to-s3-with-parquet.md>), [Parquet files in Amazon S3](<https://devfeed.tech/topics/parquet-files-in-amazon-s3.md>), [Visual Studio Code](<https://devfeed.tech/topics/visual-studio-code.md>)

Tags: [airlines](<https://devfeed.tech/tags/airlines.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-data-firehose](<https://devfeed.tech/tags/amazon-data-firehose.md>), [amazon-kinesis](<https://devfeed.tech/tags/amazon-kinesis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [apache](<https://devfeed.tech/tags/apache.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [apache-iceberg-tables](<https://devfeed.tech/tags/apache-iceberg-tables.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudformation](<https://devfeed.tech/tags/aws-cloudformation.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [customer-solutions](<https://devfeed.tech/tags/customer-solutions.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [dms](<https://devfeed.tech/tags/dms.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [iceberg](<https://devfeed.tech/tags/iceberg.md>), [kinesis-data-streams](<https://devfeed.tech/tags/kinesis-data-streams.md>), [streams](<https://devfeed.tech/tags/streams.md>), [united-airlines](<https://devfeed.tech/tags/united-airlines.md>)

### AI overview

United Airlines describes a near-real-time CDC pipeline that moves Aurora MySQL changes through AWS DMS, Kinesis Data Streams, Lambda, and Amazon Data Firehose into Apache Iceberg tables on S3. Firehose applies inserts, updates, and deletes as Iceberg snapshots; the open tables can be queried through AWS Glue, Redshift, or Athena. United reports 5x lower average query latency and 2x shorter downstream Glue job processing time in its testing, with a low-volume test reaching about 10 seconds end-to-end. Buffer settings trade latency against cost and file size. The walkthrough uses DMS Serverless, Athena for validation, and a simplified single-table CloudFormation template; United's production setup uses provisioned DMS and primarily Redshift Serverless. The template's shard count and other demo settings are not production-tuned, and schema evolution and multi-table replication require additional handling.

### Source excerpt

United Airlines built a near-real-time change data capture pipeline that replicates reference data from Amazon Aurora MySQL to open Apache Iceberg tables using AWS DMS, Amazon Kinesis Data Streams, and Amazon Data Firehose. This post shows how to reproduce the serverless, multi-engine analytics pattern with AWS CloudFormation.

## How Stretto built an AI voice agent with Amazon Nova 2 Sonic

DevFeed: [How Stretto built an AI voice agent with Amazon Nova 2 Sonic](<https://devfeed.tech/articles/how-stretto-built-an-ai-voice-agent-with-amazon-nova-2-sonic-141098.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/machine-learning/how-stretto-built-an-ai-voice-agent-with-amazon-nova-2-sonic/>)

Author: Mariah Miller

Published: 2026-11-18T18:58:42Z

Content type: article

Language: en

Sources: [Artificial Intelligence](<https://devfeed.tech/sources/artificial-intelligence.md>)

Topics: [Conversational AI](<https://devfeed.tech/topics/conversational-ai.md>), [speech-to-speech](<https://devfeed.tech/topics/speech-to-speech.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-voice](<https://devfeed.tech/tags/ai-voice.md>), [ai-voice-agent](<https://devfeed.tech/tags/ai-voice-agent.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-connect](<https://devfeed.tech/tags/amazon-connect.md>), [amazon-elastic-container-service](<https://devfeed.tech/tags/amazon-elastic-container-service.md>), [amazon-nova](<https://devfeed.tech/tags/amazon-nova.md>), [amazon-sqs](<https://devfeed.tech/tags/amazon-sqs.md>), [anthropic](<https://devfeed.tech/tags/anthropic.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bankruptcy](<https://devfeed.tech/tags/bankruptcy.md>), [customer-solutions](<https://devfeed.tech/tags/customer-solutions.md>), [generative-ai](<https://devfeed.tech/tags/generative-ai.md>), [interviews](<https://devfeed.tech/tags/interviews.md>), [lead](<https://devfeed.tech/tags/lead.md>), [phone](<https://devfeed.tech/tags/phone.md>), [production](<https://devfeed.tech/tags/production.md>)

### AI overview

Stretto replaced Bankruptcy.com's short web form with Tara, a phone agent that gathers bankruptcy intake details conversationally, then uses attorney-defined rules to sort leads for attorney review. Amazon Nova 2 Sonic handles speech input and output in one model; Claude 3 Haiku extracts typed fields from transcripts, which are stored in Aurora. Twilio streams calls to a voice bridge on ECS Fargate. Because full interviews can exceed one streaming session's duration, the bridge opens a continuation stream and carries over text history. The team validated voice quality, latency, emotional tone, and interruptions before integration, then expanded from the 13-field form to a conditional intake spanning more than 18 categories. Consent and disclosures precede intake; attorneys retain final decisions. After roughly three months, Stretto reported a 20% relative conversion increase, about 96% field extraction accuracy in testing, approximately eight-minute completed calls, and 95% lower per-minute voice costs than its previous solution. Results were early and not yet broadly rolled out.

### Source excerpt

Stretto replaced its web-form lead capture with Tara, an AI voice agent built on Amazon Nova 2 Sonic that conducts bankruptcy intake interviews by phone and qualifies leads. See how Stretto, the AWS Generative AI Innovation Center, and CI&T designed the voice architecture, validated it for sensitive conversations, and moved it to production.

## pgjumbo: a new free desktop client for PostgreSQL

DevFeed: [pgjumbo: a new free desktop client for PostgreSQL](<https://devfeed.tech/articles/pgjumbo-a-new-free-desktop-client-for-postgresql-141065.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgjumbo-a-new-free-desktop-client-for-postgresql-3444/>)

Published: 2026-11-18T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [AppImage](<https://devfeed.tech/topics/appimage.md>)

Tags: [administration](<https://devfeed.tech/tags/administration.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [analyze](<https://devfeed.tech/tags/analyze.md>), [apple-silicon](<https://devfeed.tech/tags/apple-silicon.md>), [archive](<https://devfeed.tech/tags/archive.md>), [arm64](<https://devfeed.tech/tags/arm64.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [backup](<https://devfeed.tech/tags/backup.md>), [changes](<https://devfeed.tech/tags/changes.md>), [client](<https://devfeed.tech/tags/client.md>), [completion](<https://devfeed.tech/tags/completion.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [contents](<https://devfeed.tech/tags/contents.md>), [cron](<https://devfeed.tech/tags/cron.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [deb](<https://devfeed.tech/tags/deb.md>), [desktop](<https://devfeed.tech/tags/desktop.md>), [free](<https://devfeed.tech/tags/free.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

### AI overview

pgjumbo is a free desktop client for PostgreSQL 12+ on Windows, macOS, and Linux, including Amazon Aurora and RDS with IAM authentication. It can connect directly, over SSL, or through an SSH tunnel. Version 1.0.2 combines schema inspection, a query tool with completion and EXPLAIN views, and a data editor that previews statements before saving. Backup and restore use PostgreSQL's pg_dump tools and support selecting objects or rows, inspecting archive contents, and restoring to a new database. Maintenance tools cover VACUUM, ANALYZE, REINDEX, and per-table autovacuum settings. Object changes are shown as SQL for review; destructive statements on servers marked Production require confirmation.

### Source excerpt

pgjumbo is a new desktop client for PostgreSQL 12+, free to use, for Windows, macOS and Linux, with query, data and administration tools. pgjumbo connects to PostgreSQL 12+, including Amazon Aurora and RDS with IAM authentication, directly, over SSL or through an SSH tunnel. Installers are available for Windows (x64 and ARM64), macOS (Apple silicon and Intel) and Linux (AppImage, .deb and .rpm). Version 1.0.2 includes: An object explorer and inspector with each object's CREATE script, statistics and dependencies. A Query Tool with completion, syntax errors from PostgreSQL's own parser as you type, parameters, EXPLAIN as a table or a diagram, and results that can be sorted, filtered, compared and exported. A data editor that shows the statements before it saves them. Backup and restore built on pg_dump, pg_dumpall and pg_restore: choosing objects and rows, server backups as a folder of archives, reading an archive's contents before restoring, and restoring into a new database. Maintenance: what each table needs and what holds VACUUM back, VACUUM, ANALYZE and REINDEX as reviewed steps with progress, and autovacuum settings per table. Server activity, configuration, roles and privileges, logs, replication, pg_cron jobs and LISTEN/NOTIFY. Changes to objects are shown as SQL and reviewed before they run, and on servers marked Production, destructive statements ask for confirmation first. Download pgjumbo - Release notes for 1.0.2

## pgSherpa: a free PostgreSQL monitoring companion for macOS

DevFeed: [pgSherpa: a free PostgreSQL monitoring companion for macOS](<https://devfeed.tech/articles/pgsherpa-a-free-postgresql-monitoring-companion-for-macos-141066.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/pgsherpa-a-free-postgresql-monitoring-companion-for-macos-3446/>)

Published: 2026-11-18T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [macOS](<https://devfeed.tech/topics/macos.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>)

Tags: [app-store](<https://devfeed.tech/tags/app-store.md>), [apple-silicon](<https://devfeed.tech/tags/apple-silicon.md>), [companion](<https://devfeed.tech/tags/companion.md>), [desktop](<https://devfeed.tech/tags/desktop.md>), [free](<https://devfeed.tech/tags/free.md>), [intel](<https://devfeed.tech/tags/intel.md>), [keychain](<https://devfeed.tech/tags/keychain.md>), [locks](<https://devfeed.tech/tags/locks.md>), [macos](<https://devfeed.tech/tags/macos.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [screen](<https://devfeed.tech/tags/screen.md>), [server](<https://devfeed.tech/tags/server.md>), [servers](<https://devfeed.tech/tags/servers.md>), [statement](<https://devfeed.tech/tags/statement.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>), [transaction](<https://devfeed.tech/tags/transaction.md>), [write](<https://devfeed.tech/tags/write.md>)

### AI overview

pgSherpa is a free macOS desktop companion that polls PostgreSQL 12-18 servers and surfaces issues with explanatory text and supporting rows. It offers a SQL box with server-version-specific `\h` help, plus reports for activity, locks, query statistics, vacuum progress, indexes, and replication. Statements run in read-only transactions unless switched to write. Setup requires a role with `pg_monitor`; no server extension or agent is installed. The excerpt says credentials stay in the macOS Keychain and that the app has no account or telemetry. It supports macOS 12 or later on Apple silicon and Intel Macs.

### Source excerpt

CortexRidge has released pgSherpa, a free desktop companion for PostgreSQL on macOS, now available on the Mac App Store. pgSherpa sits in a corner of the screen and polls one or more PostgreSQL servers (PostgreSQL 12 to 18). When something needs attention it says so in a sentence, with the rows behind it: Health: lock-wait chains, long-running and idle-in-transaction sessions, replication lag and replication slots, vacuum and transaction ID wraparound, connection limits. Security: the server's version compared with the latest PostgreSQL minor release and the CVEs fixed since, plus configuration such as SSL, MD5 passwords and superuser count. Cloud: backups, failovers, maintenance windows and replicas for DigitalOcean Managed Databases, Supabase and Amazon RDS / Aurora PostgreSQL, read from the provider's API. SQL: a query box with PostgreSQL completion and \h syntax help for the server's own version. Every statement runs in a read-only transaction unless the user switches it to write. Reports: ready-made views of pg_stat_activity, pg_locks, pg_stat_statements, vacuum progress, indexes and replication. pgSherpa needs only a role with pg_monitor. It installs no extension and no agent on the server, and it has no account and no telemetry; passwords and keys stay in the macOS Keychain. It runs on macOS 12 or later, on Apple silicon and Intel Macs. Mac App Store: https://apps.apple.com/app/id6833955115 More information: https://cortexridge.com/

## Reducing database incident MTTR by 73% with a custom AWS DevOps Agent Skill

DevFeed: [Reducing database incident MTTR by 73% with a custom AWS DevOps Agent Skill](<https://devfeed.tech/articles/reducing-database-incident-mttr-by-73-with-a-custom-aws-devops-agent-skill-139360.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/devops/reducing-database-incident-mttr-by-73-with-a-custom-aws-devops-agent-skill/>)

Author: Chetan Suri

Published: 2026-11-17T22:27:48Z

Content type: tutorial

Language: en

Sources: [AWS DevOps & Developer Productivity Blog](<https://devfeed.tech/sources/aws-devops-developer-productivity-blog.md>)

Topics: [Agent Skills](<https://devfeed.tech/topics/agent-skills.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [DevOps](<https://devfeed.tech/topics/devops.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Post Mortem](<https://devfeed.tech/topics/post-mortem.md>)

Tags: [agent-skill](<https://devfeed.tech/tags/agent-skill.md>), [aws](<https://devfeed.tech/tags/aws.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [database](<https://devfeed.tech/tags/database.md>), [decision](<https://devfeed.tech/tags/decision.md>), [devops](<https://devfeed.tech/tags/devops.md>), [devops-agent](<https://devfeed.tech/tags/devops-agent.md>), [incidents](<https://devfeed.tech/tags/incidents.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [mttr](<https://devfeed.tech/tags/mttr.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [reduction](<https://devfeed.tech/tags/reduction.md>)

### AI overview

A custom AWS DevOps Agent Skill uses signal classification and a prioritized decision tree to guide Aurora PostgreSQL incident investigations across five failure modes: connection exhaustion, replication lag, slow query regression, storage pressure, and parameter drift. In a controlled internal test of three simulated incidents, average time to identify root cause fell from 52 to 14 minutes, and wrong hypotheses per incident fell from 3.0 to 0.3. The comparison covered connection exhaustion, slow query regression, and parameter drift, so the reported results do not establish performance across every branch or production conditions. The guide requires an AWS account and Agent Space access to the cluster, CloudWatch metrics and Performance Insights, and the Operator Web App; it recommends deploying for Incident RCA and On-demand agents, excluding Incident Triage because the procedure is too thorough for fast triage.

### Source excerpt

Database incidents routinely take 45 to 60 minutes to triage. This post shows how to build a custom AWS DevOps Agent Skill that encodes expert Aurora PostgreSQL triage into decision-tree logic across five failure modes, cutting mean time to resolution from 52 minutes to 14 minutes (a 73% reduction) in a controlled test.

## Add your organization's runbooks and policies using Retrieval Augmented Generation (RAG) on Amazon Aurora PostgreSQL

DevFeed: [Add your organization's runbooks and policies using Retrieval Augmented Generation (RAG) on Amazon Aurora PostgreSQL](<https://devfeed.tech/articles/add-your-organization-s-runbooks-and-policies-using-retrieval-augmented-generation-rag-on-amazon-aurora-postgresql-138650.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/add-your-organizations-runbooks-and-policies-using-retrieval-augmented-generation-rag-on-amazon-aurora-postgresql/>)

Author: Narendra Tawar

Published: 2026-11-17T19:43:40Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Bedrock Knowledge Bases](<https://devfeed.tech/topics/amazon-bedrock-knowledge-bases.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Vectors & LLMs](<https://devfeed.tech/topics/vectors-llms.md>), [Enhancing AI model performance](<https://devfeed.tech/topics/enhancing-ai-model-performance.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Access Control](<https://devfeed.tech/topics/access-control.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [amazon-bedrock-knowledge-bases](<https://devfeed.tech/tags/amazon-bedrock-knowledge-bases.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [kiro](<https://devfeed.tech/tags/kiro.md>), [pgvector](<https://devfeed.tech/tags/pgvector.md>), [policies](<https://devfeed.tech/tags/policies.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rag](<https://devfeed.tech/tags/rag.md>), [retrieval](<https://devfeed.tech/tags/retrieval.md>), [retrieval-augmented-generation-rag](<https://devfeed.tech/tags/retrieval-augmented-generation-rag.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

The walkthrough connects a Kiro DBA assistant to team runbooks and policies using Amazon Bedrock Knowledge Bases, Amazon S3, and Aurora PostgreSQL with pgvector. Bedrock chunks documents, creates Titan Text Embeddings V2 vectors, and stores them with text in Aurora; at query time, the Retrieval MCP server returns relevant chunks for the assistant to ground its recommendations. Setup requires Aurora PostgreSQL 15.4 or later, pgvector, the RDS Data API, and appropriate Bedrock, S3, and Secrets Manager access. The Knowledge Base needs the `mcp-multirag-kb=true` tag for automatic MCP discovery. For structured policies, section-based custom chunking may improve retrieval precision over default chunking. In the example, retrieval surfaces required peer review, CAB approval, and a manual snapshot before schema changes, while suggesting reader-endpoint traffic redirection as an immediate mitigation. The article also stresses that steering files are soft guardrails; read-only database permissions and IAM deny policies provide additional write protection. Re-sync documents as they change, and restrict `bedrock:Retrieve` access to protect sensitive runbooks.

### Source excerpt

In Part 2 of this series, you connect your Kiro DBA assistant to your team's runbooks and policies. Store runbooks in Amazon S3, index them with Amazon Bedrock Knowledge Bases on Amazon Aurora PostgreSQL using pgvector, and wire up retrieval so the assistant grounds its recommendations in your own documentation.

## Build an AI-powered DBA assistant for Amazon Aurora and Amazon RDS with Kiro

DevFeed: [Build an AI-powered DBA assistant for Amazon Aurora and Amazon RDS with Kiro](<https://devfeed.tech/articles/build-an-ai-powered-dba-assistant-for-amazon-aurora-and-amazon-rds-with-kiro-138651.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/build-an-ai-powered-dba-assistant-for-amazon-aurora-and-amazon-rds-with-kiro/>)

Author: Narendra Tawar

Published: 2026-11-17T19:43:17Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-powered](<https://devfeed.tech/tags/ai-powered.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [apply](<https://devfeed.tech/tags/apply.md>), [build](<https://devfeed.tech/tags/build.md>), [change](<https://devfeed.tech/tags/change.md>), [change-management](<https://devfeed.tech/tags/change-management.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [database](<https://devfeed.tech/tags/database.md>), [dba](<https://devfeed.tech/tags/dba.md>), [diagnostic](<https://devfeed.tech/tags/diagnostic.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [incidents](<https://devfeed.tech/tags/incidents.md>), [kiro](<https://devfeed.tech/tags/kiro.md>), [rds](<https://devfeed.tech/tags/rds.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

Kiro can investigate Aurora PostgreSQL performance incidents in one interface by combining two MCP servers: the PostgreSQL server runs diagnostic queries and reads database details, while the CloudWatch server reads metrics, alarms, and logs. Database Insights load, top SQL, and wait events are also retrieved through read-only AWS CLI calls. Setup requires Kiro, Python 3.10+ and uv, AWS credentials with appropriate read permissions, and an Aurora cluster with Database Insights enabled. The assistant is read-only by default and recommends changes for the DBA to review and apply through change management. The article describes three safeguards: steering rules, a PostgreSQL read-only role, and IAM permissions that deny mutations. Its recommendations may need validation because it lacks historical performance data, runbooks, and environment-specific context. The example fix is applied manually after taking a snapshot, then checked with explain plans.

### Source excerpt

Learn how to build a DBA assistant with Kiro that investigates and resolves Amazon Aurora PostgreSQL performance incidents through natural language. Using two MCP servers, the agent reads Amazon CloudWatch metrics and Database Insights, runs diagnostic queries, and surfaces fixes you apply through your change management process.

## PostgreSQL large objects: Best practices for Amazon Aurora and RDS

DevFeed: [PostgreSQL large objects: Best practices for Amazon Aurora and RDS](<https://devfeed.tech/articles/postgresql-large-objects-best-practices-for-amazon-aurora-and-rds-136897.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/postgresql-large-objects-best-practices-for-amazon-aurora-and-rds/>)

Author: Sachin Murkar

Published: 2026-11-16T23:46:00Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [monitor](<https://devfeed.tech/tags/monitor.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prevent](<https://devfeed.tech/tags/prevent.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [triggers](<https://devfeed.tech/tags/triggers.md>), [upgrades](<https://devfeed.tech/tags/upgrades.md>)

### AI overview

PostgreSQL large objects can hold values up to 4 TB and support efficient partial reads and updates, but they live outside application tables, so autovacuum does not remove unlinked objects. The article recommends monitoring their count and storage, checking reference columns against vacuumlo's scan criteria, and using dry-run mode before cleanup. vacuumlo recognizes columns named oid or lo, but misses other domains over oid and columns such as integer, bigint, text, or custom types; missed references can be permanently deleted as supposed orphans. lo_manage triggers can unlink objects on row updates or deletes, but do not run for DROP or TRUNCATE. High object counts can also increase OID allocation contention and complicate major upgrades through pg_dump/pg_restore memory use. The guidance includes reducing orphan counts, testing upgrades on a clone, and considering temporary instance scaling when counts remain high.

### Source excerpt

PostgreSQL large objects live outside your tables and are referenced only by an OID, so autovacuum never reclaims the orphans. This post shows how to monitor orphaned large objects on Amazon Aurora and Amazon RDS for PostgreSQL, run vacuumlo safely, set up lo_manage triggers, prevent OID exhaustion, and prepare for major version upgrades.

## Fix Amazon Aurora MySQL error 63955: Virtual index ID overflow

DevFeed: [Fix Amazon Aurora MySQL error 63955: Virtual index ID overflow](<https://devfeed.tech/articles/fix-amazon-aurora-mysql-error-63955-virtual-index-id-overflow-133436.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/fix-amazon-aurora-mysql-error-63955-virtual-index-id-overflow/>)

Author: Kartik Saini

Published: 2026-11-13T21:10:28Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [infrastructure monitoring](<https://devfeed.tech/topics/infrastructure-monitoring.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Elastic Block Store (Amazon EBS)](<https://devfeed.tech/topics/amazon-elastic-block-store-amazon-ebs.md>), [TTL in DNS](<https://devfeed.tech/topics/ttl-in-dns.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [backups](<https://devfeed.tech/tags/backups.md>), [dump](<https://devfeed.tech/tags/dump.md>), [error](<https://devfeed.tech/tags/error.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [index](<https://devfeed.tech/tags/index.md>), [limit](<https://devfeed.tech/tags/limit.md>), [logical](<https://devfeed.tech/tags/logical.md>), [migration](<https://devfeed.tech/tags/migration.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [rebuild](<https://devfeed.tech/tags/rebuild.md>), [restore](<https://devfeed.tech/tags/restore.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [virtual](<https://devfeed.tech/tags/virtual.md>)

### AI overview

Aurora MySQL error 63955 means the cluster has exhausted virtual index IDs: indexes containing virtual columns--including functional and multi-valued indexes--fail, while existing data and ordinary indexes remain usable. Changing a generated column to STORED can unblock that particular index, but does not reset the IDs. The documented fix is a logical dump and restore; snapshots, clones, point-in-time recovery, and Blue/Green deployments copy physical structures and do not clear the condition. The described migration uses a clone, binary log replication, MyDumper/MyLoader, and a new Aurora MySQL 3.10.0-or-later cluster. It requires planning for a source reboot to enable binary logging, preserving the clone's source log position, migrating users and grants separately, validating the restore, and limiting rollback because schema changes can break reverse replication. On 3.10.0 or later, monitor the error log for VIRTUAL_INDEX_ID_OVERFLOW_WARNING; it is the only stated advance signal.

### Source excerpt

An Amazon Aurora MySQL cluster can exhaust its virtual index ID limit, after which any CREATE INDEX that includes a virtual column fails with error 63955 until you rebuild the databases. This post shows how to recognize the error, why backups cannot clear it, and how to run a logical dump-and-restore migration with monitoring to catch it next time.

## Improve RDS Proxy multiplexing for PostgreSQL, Part 1: Common causes

DevFeed: [Improve RDS Proxy multiplexing for PostgreSQL, Part 1: Common causes](<https://devfeed.tech/articles/improve-rds-proxy-multiplexing-for-postgresql-part-1-common-causes-133437.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/improve-rds-proxy-multiplexing-for-postgresql-part-1-common-causes/>)

Author: Pavel Rabinovich

Published: 2026-11-13T21:08:09Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [fragmentation](<https://devfeed.tech/tags/fragmentation.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [multiplexing](<https://devfeed.tech/tags/multiplexing.md>), [pool](<https://devfeed.tech/tags/pool.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [proxy](<https://devfeed.tech/tags/proxy.md>), [rds](<https://devfeed.tech/tags/rds.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

RDS Proxy multiplexing for PostgreSQL is reduced when sessions are pinned, client identities fragment the pool, or transactions remain open. CloudWatch indicators help distinguish them: elevated session-pinned connections suggest pinning; many backend connections with low borrowing and pinning can indicate fragmentation; sustained borrowing and open transactions point to transactions held too long. Fixes include upgrading the PostgreSQL JDBC driver to 42.7.x or newer, removing application SET statements, setting Spark JDBC writes to isolationLevel=NONE, and using InitQuery for shared session defaults. Standardize username, database, and ApplicationName among clients that should share a pool, while preserving separate users when privilege or audit needs require them. Commit promptly or enable autocommit where explicit transaction control is unnecessary. PostgreSQL targets do not support the proxy's SET pinning filter, and CloudWatch gauges can miss short-lived borrow cycles.

### Source excerpt

RDS Proxy multiplexes many client connections across a small pool of database connections, but connection pinning, pool fragmentation, and uncommitted transactions can silently disable that benefit for PostgreSQL workloads. Part 1 shows how to recognize each condition with Amazon CloudWatch metrics and the fix that restores multiplexing.

## Refresh a single tenant across accounts with Aurora MySQL and Amazon S3

DevFeed: [Refresh a single tenant across accounts with Aurora MySQL and Amazon S3](<https://devfeed.tech/articles/refresh-a-single-tenant-across-accounts-with-aurora-mysql-and-amazon-s3-129589.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/refresh-a-single-tenant-across-accounts-with-aurora-mysql-and-amazon-s3/>)

Author: Mansi Panchal

Published: 2026-11-11T22:08:37Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Distributed Systems & Parallel Computing](<https://devfeed.tech/topics/distributed-systems-parallel-computing.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Cloud Networking](<https://devfeed.tech/topics/cloud-networking.md>), [Resource Access Manager (RAM)](<https://devfeed.tech/topics/resource-access-manager-ram.md>)

Tags: [access-management](<https://devfeed.tech/tags/access-management.md>), [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [amazon-simple-storage-service-amazon-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-amazon-s3.md>), [amazon-simple-storage-service-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-s3.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudtrail](<https://devfeed.tech/tags/aws-cloudtrail.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [data](<https://devfeed.tech/tags/data.md>), [encrypted](<https://devfeed.tech/tags/encrypted.md>), [load](<https://devfeed.tech/tags/load.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [network](<https://devfeed.tech/tags/network.md>), [refresh](<https://devfeed.tech/tags/refresh.md>), [route](<https://devfeed.tech/tags/route.md>), [s3](<https://devfeed.tech/tags/s3.md>), [select](<https://devfeed.tech/tags/select.md>), [separate](<https://devfeed.tech/tags/separate.md>), [staging](<https://devfeed.tech/tags/staging.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [using](<https://devfeed.tech/tags/using.md>)

### AI overview

The article describes refreshing one tenant in an existing non-production Aurora MySQL cluster without a network route between AWS accounts. A production-side copy-on-write clone exports tenant-scoped table data to a shared, encrypted S3 staging bucket; the non-production cluster imports the per-table manifests through its own S3 gateway endpoint. Cross-account access relies on IAM and bucket policies plus a production-account customer-managed KMS key, with no database connection between clusters. The workflow requires matching destination schemas, tenant-ID indexes, careful classification of tenant-scoped, tenant-derived, and shared tables, and tenant-only deletion before import. Per-table parallelism and retries limit the impact of failures, but exports are uncompressed and do not parallelize within a table, so the largest table can determine refresh time. The excerpt also notes key-collision risks, production-data handling requirements, and that this pattern is for a single tenant rather than a whole-cluster copy.

### Source excerpt

Move a single tenant's data between Amazon Aurora MySQL clusters in two separate AWS accounts with no network route between them, using Aurora cloning, SELECT INTO OUTFILE S3, and LOAD DATA FROM S3. The clusters never connect, and one encrypted Amazon S3 staging bucket is their only shared touchpoint.

## Resilient IAM database authentication with Amazon Aurora Global Database writer endpoint

DevFeed: [Resilient IAM database authentication with Amazon Aurora Global Database writer endpoint](<https://devfeed.tech/articles/resilient-iam-database-authentication-with-amazon-aurora-global-database-writer-endpoint-129590.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resilient-iam-database-authentication-with-amazon-aurora-global-database-writer-endpoint/>)

Author: Raunak Gupta

Published: 2026-11-11T22:01:27Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [Access Control](<https://devfeed.tech/topics/access-control.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [changes](<https://devfeed.tech/tags/changes.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [cross](<https://devfeed.tech/tags/cross.md>), [database](<https://devfeed.tech/tags/database.md>), [failover](<https://devfeed.tech/tags/failover.md>), [global](<https://devfeed.tech/tags/global.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [iam](<https://devfeed.tech/tags/iam.md>), [id](<https://devfeed.tech/tags/id.md>), [passwordless](<https://devfeed.tech/tags/passwordless.md>), [policy](<https://devfeed.tech/tags/policy.md>), [primary](<https://devfeed.tech/tags/primary.md>), [region](<https://devfeed.tech/tags/region.md>), [resource](<https://devfeed.tech/tags/resource.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [with](<https://devfeed.tech/tags/with.md>), [writer](<https://devfeed.tech/tags/writer.md>)

### AI overview

A stable Aurora Global Database writer endpoint handles routing after a cross-Region promotion, while IAM authentication requires the token's SigV4 signing Region and `rds-db:connect` authorization to match the new primary. The walkthrough discovers the current primary Region through `describe-global-clusters`, signs a token for it, and lists each Regional cluster resource ID in the IAM policy; this keeps connections working with the same endpoint and policy after switchover or failover. IAM authentication must be enabled on both clusters, clients need cross-Region network access and TLS, and discovery needs a healthy Region during an impairment. Managed failover may lose writes not yet replicated and requires compatible engine versions. The excerpt also advises caching Region discovery to limit throttling, refreshing tokens per connection because they expire after 15 minutes, and respecting DNS TTL. AWS Advanced Drivers can automate token handling; the JDBC wrapper additionally supports Global Database failover reconnection.

### Source excerpt

Learn how to combine the Amazon Aurora Global Database writer endpoint with IAM database authentication so that passwordless access survives a cross-Region switchover or failover with no configuration changes. This walkthrough signs the token for the dynamically discovered primary Region and scopes the policy to every Regional cluster resource ID.

## Offline assessment and conversion with AI agents in AWS DMS

DevFeed: [Offline assessment and conversion with AI agents in AWS DMS](<https://devfeed.tech/articles/offline-assessment-and-conversion-with-ai-agents-in-aws-dms-129588.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/offline-assessment-and-conversion-with-ai-agents-in-aws-dms/>)

Author: Nelly Susanto

Published: 2026-11-11T18:56:08Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [AWS Database Migration Service](<https://devfeed.tech/topics/aws-database-migration-service.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-database-migration-service](<https://devfeed.tech/tags/aws-database-migration-service.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [dms](<https://devfeed.tech/tags/dms.md>), [dms-schema-conversion](<https://devfeed.tech/tags/dms-schema-conversion.md>), [offline](<https://devfeed.tech/tags/offline.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

AWS DMS Schema Conversion can assess and convert schemas before either database is reachable by importing exported SQL Server DDL from S3 as an offline source and using a virtual target. An MCP-enabled AI agent with the DMS Schema Conversion skill can create the virtual data providers and migration project, run assessment and conversion, and export reports and SQL for review. The workflow requires properly formatted, separate Unicode .sql files, an S3 bucket and DMS access role, plus AWS credentials with permissions for DMS, Secrets Manager, S3, and RDS. In the SalesDB-to-Aurora PostgreSQL example, about 99% of 792 SQL syntax elements converted automatically; one stored procedure needed manual changes for transaction control and @@TRANCOUNT. When ready, users can apply reviewed SQL themselves or switch the target provider to a live connection and have DMS apply it. Turning off Virtual Mode cannot be undone.

### Source excerpt

Learn how to use an AI agent with AWS DMS Schema Conversion to assess and convert SQL Server database schemas from exported DDL scripts in Amazon S3, using offline source and virtual target mode. You can start migration planning before you have source database connectivity or a provisioned target.

## Build an Oracle AWR-style report for RDS/Aurora PostgreSQL

DevFeed: [Build an Oracle AWR-style report for RDS/Aurora PostgreSQL](<https://devfeed.tech/articles/build-an-oracle-awr-style-report-for-rds-aurora-postgresql-129581.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/build-an-oracle-awr-style-report-for-rds-aurora-postgresql/>)

Author: Tushar Rajput

Published: 2026-11-11T18:20:16Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Insight for DBAs](<https://devfeed.tech/topics/insight-for-dbas.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [Amazon EventBridge](<https://devfeed.tech/topics/amazon-eventbridge.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [based](<https://devfeed.tech/tags/based.md>), [build](<https://devfeed.tech/tags/build.md>), [built-in](<https://devfeed.tech/tags/built-in.md>), [cron](<https://devfeed.tech/tags/cron.md>), [database](<https://devfeed.tech/tags/database.md>), [event](<https://devfeed.tech/tags/event.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [ids](<https://devfeed.tech/tags/ids.md>), [load](<https://devfeed.tech/tags/load.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [post](<https://devfeed.tech/tags/post.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [rds](<https://devfeed.tech/tags/rds.md>), [rds-for-postgresql](<https://devfeed.tech/tags/rds-for-postgresql.md>), [report](<https://devfeed.tech/tags/report.md>), [style](<https://devfeed.tech/tags/style.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

The article presents `awr_lite`, a SQL-based AWR-style reporting solution for RDS and Aurora PostgreSQL built from `pg_stat_statements` and `pg_cron`. It stores snapshots every 15 minutes by default, samples active sessions every 10 seconds, and generates reports between snapshot IDs with load, activity, ranked SQL, segment, wait-event, and configuration sections. Installation requires PostgreSQL 14 or later, both extensions, an `rds_superuser` user, parameter changes and a reboot; objects and cron jobs must share the monitored database. Collection runs on the writer, and windows spanning statistics resets have unreliable deltas. Aurora lacks the WAL figures and restricts cron to one database per cluster; other databases need external scheduling. The sampler stores raw query text and client addresses, so the article advises reviewing exposure and report contents before sharing. CloudWatch Database Insights remains useful for continuous one-second graphical wait analysis.

### Source excerpt

PostgreSQL has no built-in Oracle AWR equivalent. This post shows how to build an AWR-style, snapshot-based performance report for Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL using pg_stat_statements and pg_cron, producing top-SQL, database-activity, wait-event, and load-profile reports between any two snapshot IDs, entirely in SQL.

## Help prevent out-of-memory restarts on Aurora MySQL 8.4

DevFeed: [Help prevent out-of-memory restarts on Aurora MySQL 8.4](<https://devfeed.tech/articles/help-prevent-out-of-memory-restarts-on-aurora-mysql-8-4-129584.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/help-prevent-out-of-memory-restarts-on-aurora-mysql-8-4/>)

Author: Aayushi Mittal

Published: 2026-11-11T16:51:16Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [memory handling](<https://devfeed.tech/topics/memory-handling.md>)

Tags: [1-3](<https://devfeed.tech/tags/1-3.md>), [2](<https://devfeed.tech/tags/2.md>), [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [control](<https://devfeed.tech/tags/control.md>), [event](<https://devfeed.tech/tags/event.md>), [help](<https://devfeed.tech/tags/help.md>), [learn](<https://devfeed.tech/tags/learn.md>), [management](<https://devfeed.tech/tags/management.md>), [memory](<https://devfeed.tech/tags/memory.md>), [memory-management](<https://devfeed.tech/tags/memory-management.md>), [memory-pressure](<https://devfeed.tech/tags/memory-pressure.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oom](<https://devfeed.tech/tags/oom.md>), [out-of-memory](<https://devfeed.tech/tags/out-of-memory.md>), [prevent](<https://devfeed.tech/tags/prevent.md>), [protection](<https://devfeed.tech/tags/protection.md>), [take](<https://devfeed.tech/tags/take.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

Aurora MySQL 8.4 enables automatic memory management by default to respond to memory pressure before the operating system kills `mysqld` and restarts the cluster. The article shows how to monitor `AuroraMemoryHealthState`, recovery status and CloudWatch counters, then use error logs and Performance Schema to identify whether connection buffers, temporary tables or another consumer is driving pressure. In its test, Aurora shed work with query declines and connection terminations while keeping the database up; disabling protection led to an OOM restart. The article recommends keeping automatic management on for most 8.4 workloads and alerting on sustained memory-health values above zero. Manual control requires explicitly setting `aurora_oom_response` on 8.4, where it is empty by default when automatic management is off; some actions have pairing or deployment limits. Serverless v2 scales capacity before terminating connections and does not support `tune` or `tune_buffer_pool`. Applications should handle error 1041.

### Source excerpt

Out-of-memory restarts drop every connection and force an Aurora MySQL cluster restart. Learn how Aurora MySQL 8.4's automatic memory management prevents them: confirm protection is active, read the signals during a memory-pressure event, monitor OOM avoidance with CloudWatch, and decide when to take manual control.

## Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights

DevFeed: [Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights](<https://devfeed.tech/articles/diagnose-amazon-aurora-mysql-performance-using-cloudwatch-database-insights-129583.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/diagnose-amazon-aurora-mysql-performance-using-cloudwatch-database-insights/>)

Author: Aayushi Mittal

Published: 2026-11-11T16:46:38Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [connection pool](<https://devfeed.tech/topics/connection-pool.md>), [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [database](<https://devfeed.tech/tags/database.md>), [diagnose](<https://devfeed.tech/tags/diagnose.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-performance](<https://devfeed.tech/tags/mysql-performance.md>), [performance](<https://devfeed.tech/tags/performance.md>)

### AI overview

CloudWatch Database Insights represents database activity as average active sessions (DB load), plots it against Max vCPU, and breaks it down by wait event and top SQL. Sustained load above capacity suggests queuing, though lock waits can stall work even below that line. The article recommends tracing dominant waits to correlated SQL before changing the system: tune CPU-heavy queries; use EXPLAIN and indexes for table reads; batch Aurora redo-log writes; reduce hot-key contention and transaction length for SYNCH waits; use connection pooling for connection churn; and limit or paginate results when client-return waits dominate. Scaling or Aurora replicas are options when CPU remains the bottleneck after tuning. Standard mode provides per-instance views and seven days of history; Advanced mode adds fleet monitoring and past-period analysis, with additional cost. Fleet triage ranks instances by load before drilling into waits and SQL.

### Source excerpt

When an Aurora MySQL or Amazon RDS for MySQL database slows down, it can be hard to tell why. This post shows how to read DB load in Amazon CloudWatch Database Insights, interpret the most common MySQL wait events, and turn each into a concrete action, so you can fix the real bottleneck instead of scaling up to a larger instance.

## ReinDB: read-only performance monitoring for PostgreSQL, first database free

DevFeed: [ReinDB: read-only performance monitoring for PostgreSQL, first database free](<https://devfeed.tech/articles/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-119626.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/reindb-read-only-performance-monitoring-for-postgresql-first-database-free-3432/>)

Published: 2026-11-05T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>)

Tags: [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [first](<https://devfeed.tech/tags/first.md>), [free](<https://devfeed.tech/tags/free.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [linux](<https://devfeed.tech/tags/linux.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [performance](<https://devfeed.tech/tags/performance.md>), [performance-monitoring](<https://devfeed.tech/tags/performance-monitoring.md>), [pg-stat-statements](<https://devfeed.tech/tags/pg-stat-statements.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [windows](<https://devfeed.tech/tags/windows.md>)

### AI overview

ReinDB monitors PostgreSQL performance by learning each database's and statement's hour-by-hour baseline from pg_stat_statements, then flagging deviations ranked by the extra database time they cost. Flags include supporting evidence such as plan history and a testable fix script with an undo for each step. It requires one read-only login and installs nothing in the database. It can run hosted, onsite on Linux or Windows, or in the customer's AWS or Google Cloud account; MySQL, SQL Server, and Oracle are also supported. The first database is free for one person with no time limit or card requirement.

### Source excerpt

Bandlei has released ReinDB, read-only performance monitoring for PostgreSQL, self-managed or on Amazon RDS and Aurora. ReinDB learns what normal looks like for each database and statement, hour by hour, using pg_stat_statements, and flags what drifts from it, ranked by the extra database time each change costs. Each flag shows the evidence, including plan history, and a fix script your DBA can test, with an undo for each step. ReinDB installs nothing in your database and needs one read-only login. It runs hosted, onsite on Linux or Windows, or in your own AWS or Google Cloud account. MySQL, SQL Server and Oracle are also supported. The first database is free for one person, with no time limit and no card. A free 109-page guide, Rein In Your Database, covers the tuning method behind it. More at reindb.com.

## Build an organization-wide Amazon RDS posture dashboard with Kiro

DevFeed: [Build an organization-wide Amazon RDS posture dashboard with Kiro](<https://devfeed.tech/articles/build-an-organization-wide-amazon-rds-posture-dashboard-with-kiro-115549.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/build-an-organization-wide-amazon-rds-posture-dashboard-with-kiro/>)

Author: Sam Mukherjee

Published: 2026-11-03T16:38:19Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Amazon EventBridge](<https://devfeed.tech/topics/amazon-eventbridge.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [AWS Organizations](<https://devfeed.tech/topics/aws-organizations.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [kiro](<https://devfeed.tech/tags/kiro.md>), [organization](<https://devfeed.tech/tags/organization.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

The solution collects existing AWS posture events from five services into one organization-wide Amazon CloudWatch dashboard for RDS and Aurora. It shows the latest status per resource for deletion protection, Multi-AZ, and backups, plus engine/version details where available, protection changes with principal and source IP, and engines nearing end of standard support. Member accounts forward events directly to a central EventBridge bus; CloudWatch Logs, metric filters, alarms, and dashboard widgets provide the view without a maintained Lambda or separate database. A baseline seed fills the pre-deployment gap. The transition alarm is suited to paging when protection is disabled; the recurring Security Hub state alarm serves as a reminder. The dashboard is read-only, near real-time, and relies on events within its time range; Security Hub CSPM and AWS Config remain authoritative inventory sources. Deployment requires several configured AWS services, and the Trusted Advisor feed requires an eligible support plan. In the tested account, estimated custom-metric costs were $15-$45 monthly, with a stated worst case around $90.

### Source excerpt

Deletion protection on an Amazon RDS database is a single setting that anyone can switch off, and across hundreds of accounts there is no single place to see which databases still run without it. This post shows how to track Amazon RDS posture organization-wide with one Amazon CloudWatch dashboard, built and verified with Kiro.

## AWS contributes a large-transaction binary log optimization to MySQL

DevFeed: [AWS contributes a large-transaction binary log optimization to MySQL](<https://devfeed.tech/articles/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql-112630.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/aws-contributes-a-large-transaction-binary-log-optimization-to-mysql/>)

Author: Xueting Wu

Published: 2026-11-02T16:57:08Z

Content type: news

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [transaction-log](<https://devfeed.tech/topics/transaction-log.md>), [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bolt](<https://devfeed.tech/tags/bolt.md>), [crash-recovery](<https://devfeed.tech/tags/crash-recovery.md>), [large](<https://devfeed.tech/tags/large.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [rds-for-mysql](<https://devfeed.tech/tags/rds-for-mysql.md>), [throughput](<https://devfeed.tech/tags/throughput.md>), [transaction](<https://devfeed.tech/tags/transaction.md>)

### AI overview

BOLT removes the large-transaction binlog copy that can block all MySQL commits: once a transaction exceeds a configurable threshold (128 MB by default), MySQL promotes its spill file into the binlog sequence. A header event lets crash recovery seek to the transaction's end instead of scanning its contents. In the described controlled benchmarks, a 50 GiB transaction's commit took about 2.5 seconds with BOLT versus about 7 minutes without it; binlog recovery took about 0.1 seconds versus about 4 minutes. Throughput also rose in tested workloads containing large transactions. These results are benchmark-specific, and remaining commit time includes durable spill-file writes and InnoDB commit. BOLT is enabled by default in Aurora MySQL; a future MySQL innovation release is planned. Large transactions can still reduce replica parallelism and cause lag, so the post recommends batching them where the application allows.

### Source excerpt

When MySQL commits a large transaction, writing it to the binary log can freeze every other commit on the server for minutes. This post introduces Binary Log Optimization for Large Transactions (BOLT), an AWS contribution to community MySQL that makes commit latency independent of transaction size, speeds crash recovery, and improves throughput.

## The New York Times cut Oracle migration time from 18 to 5 months

DevFeed: [The New York Times cut Oracle migration time from 18 to 5 months](<https://devfeed.tech/articles/the-new-york-times-cut-oracle-migration-time-from-18-to-5-months-102232.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/the-new-york-times-cut-oracle-migration-time-from-18-to-5-months/>)

Author: Eli DOE

Published: 2026-10-26T17:24:10Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [llm-reasoning](<https://devfeed.tech/topics/llm-reasoning.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agent-architecture](<https://devfeed.tech/tags/agent-architecture.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agent](<https://devfeed.tech/tags/ai-agent.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [automate](<https://devfeed.tech/tags/automate.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-database-migration-service](<https://devfeed.tech/tags/aws-database-migration-service.md>), [code](<https://devfeed.tech/tags/code.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [customer-solutions](<https://devfeed.tech/tags/customer-solutions.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [migration](<https://devfeed.tech/tags/migration.md>), [new-york-times](<https://devfeed.tech/tags/new-york-times.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [remediation](<https://devfeed.tech/tags/remediation.md>), [revenue](<https://devfeed.tech/tags/revenue.md>), [schema](<https://devfeed.tech/tags/schema.md>), [subscription](<https://devfeed.tech/tags/subscription.md>), [the-new-york-times](<https://devfeed.tech/tags/the-new-york-times.md>)

### AI overview

The New York Times reports migrating its PLATO subscription revenue engine from Oracle to Amazon Aurora PostgreSQL in about five months, versus an initial estimate of up to 18, with zero revenue impact at cutover, 18,500 requests per second at go-live, and 100% row-level data accuracy. AWS DMS Schema Conversion handled database objects and flagged items needing manual work; the Mactores Aedeon Agent used Claude on Amazon Bedrock to remediate embedded Oracle SQL across Java, Groovy/Gradle, Python, Go, and shell code, with iterative validation. AWS DMS continuously replicated data, while reverse replication to Oracle supported rollback. The team also mirrored live traffic to PostgreSQL before cutover and used readiness gates for infrastructure, security, monitoring, data validation, and rollback. The account describes a particular migration; it does not establish that the approach will achieve the same results elsewhere.

### Source excerpt

Learn how The New York Times migrated its PLATO subscription revenue engine from Oracle to Amazon Aurora PostgreSQL in about 5 months instead of 18, using an AI-agent-native approach on Amazon Bedrock with AWS DMS to automate schema conversion and multi-language code remediation at enterprise scale.

## Readyon Builds Four Layer Tenant Isolation for Multi Tenant Amazon EKS

DevFeed: [Readyon Builds Four Layer Tenant Isolation for Multi Tenant Amazon EKS](<https://devfeed.tech/articles/readyon-builds-four-layer-tenant-isolation-for-multi-tenant-amazon-eks-100607.md>)

Original publisher: [Read original article](<https://www.infoq.com/news/2026/10/readyon-four-layer-isolation/>)

Author: Leela Kumili

Published: 2026-10-26T14:07:00Z

Content type: news

Language: en

Sources: [InfoQ](<https://devfeed.tech/sources/infoq.md>)

Topics: [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>), [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>), [Amazon Elastic Kubernetes Service](<https://devfeed.tech/topics/amazon-elastic-kubernetes-service.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-eks](<https://devfeed.tech/tags/amazon-eks.md>), [amazon-elastic-kubernetes-service](<https://devfeed.tech/tags/amazon-elastic-kubernetes-service.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [architecture-design](<https://devfeed.tech/tags/architecture-design.md>), [argo-cd](<https://devfeed.tech/tags/argo-cd.md>), [cloud-security](<https://devfeed.tech/tags/cloud-security.md>), [development](<https://devfeed.tech/tags/development.md>), [devops](<https://devfeed.tech/tags/devops.md>), [eks](<https://devfeed.tech/tags/eks.md>), [gitops](<https://devfeed.tech/tags/gitops.md>), [isolates](<https://devfeed.tech/tags/isolates.md>), [isolation](<https://devfeed.tech/tags/isolation.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [layer](<https://devfeed.tech/tags/layer.md>), [multi-tenancy](<https://devfeed.tech/tags/multi-tenancy.md>), [multi-tenant-data](<https://devfeed.tech/tags/multi-tenant-data.md>), [network-security](<https://devfeed.tech/tags/network-security.md>), [news](<https://devfeed.tech/tags/news.md>), [observability](<https://devfeed.tech/tags/observability.md>), [policy](<https://devfeed.tech/tags/policy.md>), [readyon-four-layer-isolation](<https://devfeed.tech/tags/readyon-four-layer-isolation.md>), [security](<https://devfeed.tech/tags/security.md>), [tenant-isolation](<https://devfeed.tech/tags/tenant-isolation.md>), [threat-modeling](<https://devfeed.tech/tags/threat-modeling.md>), [virtual-pc](<https://devfeed.tech/tags/virtual-pc.md>)

### AI overview

ReadyOn describes four overlapping isolation layers for its Harmony platform on Amazon EKS: per-tenant Kubernetes namespaces with RBAC and default-deny policies; dedicated Karpenter node pools guarded by tenant and workload taints plus admission checks; VPC security groups that restrict database access to each tenant's node pool; and dedicated Aurora clusters instead of row-level filtering in a shared database. It also uses tenant-scoped Secrets Manager paths, short-lived IAM Roles for Service Accounts credentials, and dedicated observability backends. The excerpt says Kubernetes controls alone do not separate workloads on underlying nodes, and notes that observability should connect workload identity to database and network enforcement to reveal gaps. ReadyOn reports that adversarial exercises have not found a successful cross-tenant path to date; the excerpt does not provide independent verification.

### Source excerpt

ReadyOn has detailed a four-layer tenant isolation architecture for its Harmony platform on Amazon EKS. The design combines Kubernetes namespaces, dedicated Karpenter node pools, VPC security groups, and per-tenant Aurora databases, with controls evaluated against a 10-stage multi-tenant threat model focused on cross-tenant access and lateral movement. By Leela Kumili

[Next page](<https://devfeed.tech/topics/amazon-aurora.md?cursor=WyIyMDI2LTEwLTI2VDE0OjA3OjAwKzAwOjAwIiwgIjA5OWZmNzNkLTZkZmEtNDIzMS05ZDM1LTZmZDFjMTMyODVkZSJd>)