Category: Advanced (300)

Standard upgrade paths break active Debezium CDC replication slots on Amazon Aurora PostgreSQL, forcing hours-long re-snapshots. This post shows how to use native PostgreSQL logical replication to bridge a source and target cluster and cut your Debezium connectors over to the new major version with a brief, measured write pause and no re-snapshot.

Oracle Database 26ai is now available on Amazon RDS for Oracle, bringing generative AI, vector search, and machine learning into the engine. In this post, part 1 of a three-part series, learn how to set up Select AI to run natural language queries against your relational data using foundation models on Amazon Bedrock, all from within a private Amazon RDS instance.

When an Amazon RDS or Amazon Aurora PostgreSQL certificate expires and client trust stores aren’t updated, connections fail without warning. This post shows how to enforce TLS for all PostgreSQL connections, configure client-side certificate verification, and deploy automated monitoring that alerts you before certificate rotation events.

Organizations running Amazon RDS and Amazon Aurora often pay full CloudWatch Logs ingestion rates for database logs they rarely access. This post shows how to build an automated, tag-driven solution that migrates RDS and Aurora CloudWatch log groups from the Standard to the Infrequent Access log class and cuts log ingestion costs by about 50%.

In this post, you learn how to use Amazon OpenSearch Service as a discovery layer that combines full-text, vector, and geospatial search across JSON documents in a single query, using a restaurant discovery app as a working example.

Learn how to configure connection pooling for the AWS Advanced JDBC Wrapper on Amazon Aurora and Amazon RDS. This post explains how the wrapper’s external and internal pooling differ, how to choose between them, and how the JDBC-WRAPPER-CONFIGURATION-ASSISTANT helps you build the right configuration.

Learn how to build zero-downtime write architectures for Amazon Neptune using a write queue pattern with Amazon SQS, Amazon Kinesis Data Streams, or Amazon MSK. By decoupling write acceptance from write execution, your application keeps accepting graph writes during maintenance windows, failovers, and scaling operations.

Many applications that use Amazon DynamoDB for operational data also need vector similarity search, which until now meant running a separate vector database. DynamoDB now supports native vector search. In this post, we build a semantic search application over research paper abstracts using Amazon Bedrock embeddings, and cover how vector search is metered.

Learn how to use the calling services feature in Amazon CloudWatch Database Insights to identify which applications are calling your databases and view their performance metrics, so you can pinpoint root causes and contact the right team in minutes rather than hours.

Learn how to migrate from self-managed Apache Cassandra to Amazon Keyspaces with zero downtime by deploying an extended version of the ZDM Proxy on AWS Fargate. This post covers the single CloudFormation stack, the six migration phases from historical data loading through validation and cutover, and security and cost best practices for production workloads.