Category: Expert (400)

Customers may prefer to host their Oracle database workloads in a managed service such as HAQM Relational Database Service (HAQM RDS) for Oracle because of the benefits offered by managed services. However, there could be workloads that have dependencies on Oracle features that aren’t supported by HAQM RDS for Oracle. For example, the flashback database […]

January 2025: The calculations in this post have been updated following DynamoDB’s 50% reduction in on-demand throughput pricing. Refer to New – HAQM DynamoDB lowers pricing for on-demand throughput and global tables to learn more. Your HAQM DynamoDB table might store millions, billions, or even trillions of items. If you ever need to perform a […]

Customers who prefer to host their Oracle database workloads in a managed service such as HAQM Relational Database Service (HAQM RDS) for Oracle or HAQM RDS Custom for Oracle do so because of the benefits offered by managed services. One of the major features that customers love about HAQM RDS for Oracle is the ease […]

With the flexibility of HAQM Relational Database Service (HAQM RDS) Custom for Oracle, you can customize your database, underlying server, and operating system configurations to support the various requirements of your workloads. In this series, we discuss best practices and step-by-step instructions to perform common customizations on HAQM RDS Custom for Oracle without breaking the […]

HAQM Relational Database (HAQM RDS) Custom automates database administration tasks and operations. RDS Custom makes it possible for you as a database administrator to access and customize your database environment and operating system. With RDS Custom, you can customize to meet the requirements of legacy, custom, and packaged applications. HAQM RDS Custom for Oracle supports […]

Many customers deploy the Oracle Database to an on-premises data centers running general purpose hardware or a highly customized Oracle Exadata hardware. These Oracle database customers are now looking to migrate to HAQM Relational Database Service (HAQM RDS) for Oracle, which is a fully managed commercial database that makes it easy to set up, operate, […]

Modifying the schema of a SQL database can be time-consuming, resource-intensive, and error-prone. It can also require long periods of downtime that negatively affects the end-user experience. In this post, I walk you through performing schema changes using Instant DDL and HAQM Relational Database Service (HAQM RDS) Blue/Green Deployments for HAQM Aurora MySQL-Compatible Edition with […]

When developing applications, you often need to implement a counter to accurately track actions such as votes cast, the available quantity of a resource in an eCommerce store, or tickets available for an event. These counters must be updated as the resource quantity changes. In this post, we explore seven approaches to implementing resource counters […]

In this post, we show you how to use AWS Glue to perform vertical partitioning of JSON documents when migrating document data from HAQM Simple Storage Service (HAQM S3) to HAQM DynamoDB. You can use this technique for other data sources, including relational and NoSQL databases. DynamoDB can store and retrieve any amount of data, […]

AWS Database Migration Service (AWS DMS) is used for migrating databases to AWS, but you can also use it for replicating data with low latency from any supported source to any supported target. When working with Oracle database, AWS DMS stops replicating data changes due to reset logs when the standby database is transitioned to […]