AWS Database Blog

Category: Expert (400)

Improve performance of real-time analytics and mixed workloads using the Database In-Memory option on Amazon RDS for Oracle

In this post, I demonstrate how to improve the performance of real-time analytics and mixed workloads without impacting Online Transaction Processing (OLTP) using the Oracle Database In-Memory option for workloads running on Amazon Relational Database Service (Amazon RDS) for Oracle. The demand for real-time analytics requires analytic queries to be run in real time concurrently […]

Secure data at rest on Amazon RDS Custom for Oracle with TDE – Part 2: Multi-tenant environments

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Secure data at rest on Amazon RDS Custom for Oracle with TDE – Part 1: non-CDB environments

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Configure Amazon RDS Custom for Oracle using AWS CloudFormation and AWS Systems Manager for JD Edwards One-Click

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

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

Install additional software components on Amazon RDS Custom for Oracle

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Stream data with Amazon DocumentDB, Amazon MSK Serverless, and Amazon MSK Connect

A common trend in modern application development and data processing is the use of Apache Kafka as a standard delivery mechanism for data pipeline and fan-out approach. Amazon Managed Streaming for Apache Kafka (Amazon MSK) is a fully-managed, highly available, and secure service that makes it simple for developers and DevOps managers to run applications […]

Alternatives to the Oracle flashback database feature in Amazon RDS for Oracle

Customers may prefer to host their Oracle database workloads in a managed service such as Amazon Relational Database Service (Amazon 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 Amazon RDS for Oracle. For example, the flashback database […]

Cost-effective bulk processing with Amazon DynamoDB

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