AWS Database Blog

Sameer Malik

Author: Sameer Malik

Monitor query plans for HAQM Aurora PostgreSQL

As we continue to innovate and add new features on behalf of our customers, you can now maintain and manage query plans in HAQM Aurora PostgreSQL-Compatible Edition. This feature enables you to identify the query plans contributing to the current database load and track the performance statistics of query plans over time. In this post, […]

Managed disaster recovery and managed reader farm with HAQM RDS for Oracle using Oracle Active Data Guard

Many AWS users are taking advantage of the managed database offerings in the HAQM Relational Database Service (HAQM RDS) portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. With HAQM RDS for Oracle, users can significantly reduce the administrative overhead of managing and maintaining an Oracle database. HAQM RDS for Oracle […]

Introduction to Aurora PostgreSQL cluster cache management

HAQM Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of Aurora delivers up to three times the throughput of standard PostgreSQL running on the same hardware. This enables existing PostgreSQL applications and tools to run […]

Implementing cross-region disaster recovery using Oracle GoldenGate for HAQM RDS for Oracle

Many AWS users take advantage of the managed service offerings available in the AWS portfolio to do the heavy lifting in their day-to-day activities. HAQM RDS is one of these services and is ideal for your relational database deployments. With RDS, you can significantly reduce the administrative overhead of managing and maintaining a relational database. […]

Use cases for query plan management in HAQM Aurora PostgreSQL

This blog post is the second in a series. The previous blog post talks about the need for the stable, consistent database performance amid changes that otherwise can cause regression on execution plans of the SQL statements. It also demonstrates how query plan management (QPM) for HAQM Aurora with PostgreSQL compatibility helps you overcome plan […]

Introduction to Aurora PostgreSQL Query Plan Management

Like all AWS services, the roadmap for HAQM Aurora PostgreSQL is driven mostly by customer feedback and requests for product enhancement. The feedback from several enterprise customers who have migrated their databases from Oracle and Microsoft SQL Server to HAQM Aurora suggests two things. Enterprises that run their database workloads for critical applications require optimal […]

VPC Configuration

Cross-Region Automatic Disaster Recovery on HAQM RDS for Oracle Database Using DB Snapshots and AWS Lambda

Sameer Malik is a specialist solutions architect and Christian Williams is an enterprise solutions architect at HAQM Web Services. Many AWS users are taking advantage of the managed service offerings that are available in the AWS portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. HAQM Relational Database Service (HAQM RDS) […]