AWS Database Blog
Category: Expert (400)
Build a sensor network using AWS IoT Core and HAQM DocumentDB
In this post, we discuss how you can build an Internet of Things (IoT) sensor network solution to process IoT sensor data through AWS IoT Core and store it with HAQM DocumentDB (with MongoDB compatibility). An IoT sensor network consists of multiple sensors and other devices like RFID readers made by various manufacturers, generating JSON […]
HAQM RDS for Oracle Transportable Tablespaces using RMAN
In this post, we show you how you can use the RMAN XTTS functionality to migrate from an Oracle database hosted on HAQM Elastic Compute CLoud (HAQM EC2) to HAQM RDS for Oracle. Combined with HAQM Elastic File System (HAQM EFS) integration, XTTS can help reduce the complexity of your migration strategy, reduce the number and copies of data and backups required (as well as associated storage space consumption), and reduce the application downtime associated with completing the migration of your data.
Improve performance of real-time analytics and mixed workloads using the Database In-Memory option on HAQM 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 HAQM Relational Database Service (HAQM RDS) for Oracle. The demand for real-time analytics requires analytic queries to be run in real time concurrently […]
Secure data at rest on HAQM RDS Custom for Oracle with TDE – Part 2: Multi-tenant environments
In Part 1 of this series, we discussed implementing Oracle Transparent Database Encryption (TDE) in HAQM Relational Database Service (HAQM RDS) Custom for Oracle with the local auto-login option in a database with the multi-tenant option disabled. In this post, we focus on outlining the implementation steps of TDE in an Oracle database with the […]
Secure data at rest on HAQM RDS Custom for Oracle with TDE – Part 1: non-CDB environments
In this first post of this two part series, we show you the options available to set up security using Transparent Data Encryption (TDE) to protect data at rest for an Oracle non-multi-tenant database running in HAQM Relational Database Service (HAQM RDS) Custom for Oracle. The second post will focus on the TDE implementation for […]
Configure HAQM RDS Custom for Oracle using AWS CloudFormation and AWS Systems Manager for JD Edwards One-Click
HAQM Relational Database Service (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. One way to configure your […]
Implement Oracle GoldenGate bidirectional replication between HAQM RDS for Oracle databases
In this post, we test Oracle GoldenGate (OGG) bidirectional replication between two HAQM Relational Database Service (HAQM 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 HAQM 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 HAQM Relational Database Service (HAQM 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 HAQM RDS Custom for Oracle
HAQM Relational Database Service (HAQM RDS) Custom is a managed database service that provides the flexibility to customize your database, underlying server, and operating system configurations needed to support applications that require more control than what a typical managed relational database service provides. HAQM RDS Custom for Oracle is built for legacy, custom, packaged applications, […]
Stream data with HAQM DocumentDB, HAQM MSK Serverless, and HAQM 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. HAQM Managed Streaming for Apache Kafka (HAQM MSK) is a fully-managed, highly available, and secure service that makes it simple for developers and DevOps managers to run applications […]