AWS Database Blog

Category: Amazon RDS

Understanding statistics in PostgreSQL

July 2023: This post was reviewed for accuracy. PostgreSQL has become the preferred open-source relational database for many enterprise developers and startups, and powers leading business and mobile applications. AWS provides two managed PostgreSQL options: Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Database statistics play a key role in […]

Build high availability for Amazon RDS Custom for Oracle using read replicas

A high availability solution for the database stack is an important aspect to consider when migrating or deploying Oracle databases in the AWS Cloud to help ensure that the architecture can meet the service level agreement (SLA) of the application. Unavailability of a critical database can lead to application outage, interruption to business operations, inaccessibility […]

Migrate from Oracle RAC to AWS: Alternatives on AWS

Oracle Real Application Clusters (RAC) are a way of accessing a database from multiple database servers. This provides some added high availability (HA) features over a single-instance database. In this post, we talk about why you might choose Oracle RAC for your Oracle databases, and the different ways to implement similar architecture on AWS while […]

Securely assess database schema migrations using AWS SCT, Amazon RDS for Oracle, and AWS Secrets Manager

Database migration is a multi-step process comprised of assess, mobilize, and modernize phases with different tools and technologies involved. You can use tools such as AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to accelerate each of these phases. An important part of AWS SCT is the report that it […]

Scale modern serverless applications with Amazon RDS Proxy for SQL Server

Many applications, including those built on modern serverless architectures, can have a large number of open connections to the database server and may open and close database connections at a high rate, exhausting database memory and compute resources. Databases can also suffer from transient failures, impacting application availability. Finally, applications need to maintain database credentials to […]

Connect an on-premises application server to Amazon RDS on Outposts

AWS Outposts rack brings native AWS services to virtually any customer data center or on-premises facility. Outposts is a fully managed service that extends AWS infrastructure, services, APIs, and tools to customer premises. In this post, we detail the connectivity required to connect on-premises applications to Amazon Relational Database Service (Amazon RDS) on Outposts. For […]

Convert­ Oracle partitions and sub-partitions to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL

Organizations are looking to migrate on-premises Oracle database workloads to Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition. Most heterogeneous database migrations present unique challenges. One among them is converting Oracle schemas with partitioned (and sub-partitioned) tables to PostgreSQL-compatible partitioned tables. PostgreSQL declarative partitioning is a flexible way to manage […]

Options to run deprecated major versions of Oracle databases on AWS

Oracle Database version 12c is past end of support, as announced by Oracle. Oracle 12c Release 1 (12.2.0.1) stands unsupported beyond March 31, 2022, and Oracle 12c Release 2 (12.1.0.2) is unsupported beyond July 31, 2022. After these dates, Oracle no longer releases Critical Patch Updates for these versions. To ensure that our customers continue […]

Managed Oracle Data Guard Switchover with Amazon RDS for Oracle

Amazon Relational Database Service (Amazon RDS) for Oracle now supports a fully managed, switchover-based role transition for Oracle Database replicas using Oracle Data Guard. You can initiate a switchover to a replica that is mounted or open read-only and the replicas can reside within an Availability Zone of a Region, across an Availability Zones of […]

Validate database objects post-migration from Microsoft SQL Server to Amazon RDS for MySQL and Amazon Aurora MySQL

Database object validation plays a key role in the database migration process. It’s the process of determining whether all the source database objects have been successfully migrated to the target database by comparing their types and counts. If you skip the validation phase, you may encounter runtime errors due to missing database objects, which can […]