AWS Database Blog

Category: Amazon RDS

Revolutionize retail recommendations for ecommerce with Amazon RDS for PostgreSQL and generative AI

In today’s digital age, ecommerce has become an integral part of our lives, offering convenience and endless product options at our fingertips. To enhance online shopping experience, retailers use personalized product recommendations as a key strategy to engage customers and boost sales. Among the cutting-edge technologies fueling this revolution is the vector database, a powerful […]

PostgreSQL architecture considerations for application developers: Part 1

Although the application layer is the portion the world accesses for many cloud architectures, it seems that we rarely consider how we can optimize our application for the database we’re using. When using any relational database engine, it’s important to consider not just schema design, but understanding how databases read and write data to their […]

Receive SNS notifications about Amazon RDS for SQL Server when database state changes to Offline or Online

Monitoring is an important aspect for any relational database management system (RDBMS). A good monitoring setup gives us better visibility and control of our database setups. Many of our customers use Amazon CloudWatch metrics and Amazon Relational Database Service (Amazon RDS) event notifications to monitor different metrics and events. Amazon RDS event subscription offers instance-level […]

Improve app performance through pipelining queries to Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL

PostgreSQL is an open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. AWS offers Amazon Relational Database Service (Amazon RDS) and Amazon Aurora as fully managed relational database services. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition make it […]

Migrate a multi-TB SQL Server database to Amazon RDS Custom for SQL Server using Amazon S3 and Amazon EBS

This is the first in a two-part series of posts on how to migrate a multi-TB database to Amazon Relational Database Services (Amazon RDS) Custom for SQL Server. Amazon RDS Custom for SQL Server is a managed database service that automates setup, operation, backups, high availability, and scaling of databases while granting access to the […]

Cross-account Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL migration with reduced downtime using AWS DMS

Migrating an Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL database from one AWS account to another is a common use case in scenarios when you acquire, sell, or merge operations, or if you’re reorganizing your AWS accounts and organizational structure. In this post, we discuss the steps and best […]

Migrate PostgreSQL from Google Cloud Platform to Amazon RDS with minimal downtime

In this post, we walk you through a procedure to migrate the PostgreSQL database from Google Cloud Platform (GCP) Cloud SQL to Amazon Relational Database Service (Amazon RDS) for PostgreSQL. To accomplish this task, we use AWS Database Migration Service (AWS DMS), a data migration and replication service. Using AWS DMS you can do the […]

Implement Oracle GoldenGate bidirectional replication between Amazon RDS for Oracle databases

In this post, we test Oracle GoldenGate (OGG) bidirectional replication between two Amazon Relational Database Service (Amazon RDS) for Oracle instances. This can allow mission-critical applications to be highly available across Regions and provide data redundancy and resilience. Active-active replication allows multiple database instances with the same application tables to support read/write operations running independently […]

Migrate on-premises SQL Server workloads to Amazon RDS Custom for SQL Server using distributed availability groups

In this post, we provide a SQL Server Always On cluster database migration pattern solution to Amazon Relational Database Service (Amazon RDS) Custom for SQL Server using distributed availability groups. This solution helps reduce the migration downtime through continuous data synchronization combined with a failover process. This post is not a high availability and disaster […]

Generate AWR reports for Amazon RDS for Oracle read replicas

Oracle database administrators rely on tools such as Oracle’s Automatic Workload Repository (AWR) report to identify and resolve issues that are occurring in a database. Amazon Relational Database Service (Amazon RDS) for Oracle allows you to create read replicas to offload read-only workloads. Because the instances are read only, you can’t generate AWR reports to […]