Category: Database

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 […]

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 […]

Amazon DynamoDB offers two types of backups: point-in-time recovery (PITR) and on-demand backups. PITR is used to recover your table to any point in time in a rolling 35 day window, which is used to help customers mitigate accidental deletes or writes to their tables from bad code, malicious access, or user error. On demand […]

This post was co-written with Tiju Titus John and Deepak Ram from Informatica. In this post, we discuss the significance of data governance and cataloging, and how Informatica’s latest product can help enterprises address challenges in this area of high complexity. We also discuss how Informatica uses a graph database solution based on Amazon Neptune […]

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 […]

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 […]

When moving from monoliths to microservices, you often need to propagate the same data from the monolith into multiple downstream data stores. These include purpose-built databases serving microservices as part of a decomposition project, Amazon Simple Storage Service (Amazon S3) for hydrating a data lake, or as part of a long-running command query responsibility segregation […]

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 […]

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 […]

Amazon DocumentDB is a scalable, highly durable, and fully managed database service for operating mission-critical JSON workloads for enterprises. Amazon DocumentDB simplifies your architecture by providing built-in security best practices, continuous backups, and native integrations with other AWS services. In this blog series, we discuss the approach for seamless migration of live data from a […]