Automating the Switchover of Oracle E-Business Suite on Amazon RDS Custom for Oracle
Oracle E-Business Suite is a suite of business applications that encompasses modules for finance, supply chain, human resources, and customer relationship management. Given the critical nature of these applications, it is essential to design Oracle E-Business Suite for high availability. This includes the capability to promptly switch over both the application and the database to mitigate downtime. For further insights, check out another blog post here.
Joining Amazon RDS for SQL Server to Your Self-Managed Active Directory
by Steven Roberts, Priya Patel, and Daniel Kim
on 28 AUG 2023
in Advanced (300), Amazon RDS, RDS for SQL Server, Technical How-to
This article details the process of integrating your Amazon Relational Database Service (Amazon RDS) for SQL Server instances with a self-managed Active Directory (AD). Previously, RDS for SQL Server could only be joined to an AWS Managed Microsoft AD directory, but now you have the option to connect your on-premises AD via a trust. For more authoritative insights on this matter, you can refer to this article.
Securing Data at Rest on Amazon RDS Custom for Oracle with TDE – Part 2: Multi-Tenant Environments
by Prasad Matkar and Domenico di Salvia
on 23 AUG 2023
in Amazon RDS Custom, Expert (400), RDS for Oracle, Technical How-to
In the first part of this series, we discussed the implementation of Oracle Transparent Database Encryption (TDE) in Amazon RDS Custom for Oracle with local auto-login in a database where the multi-tenant option is disabled. This post will outline the steps to implement TDE in an Oracle database configured for multi-tenancy.
Securing Data at Rest on Amazon RDS Custom for Oracle with TDE – Part 1: Non-CDB Environments
by Prasad Matkar and Domenico di Salvia
on 23 AUG 2023
in Amazon RDS Custom, Expert (400), RDS for Oracle, Technical How-to
In this first part of our two-part series, we explore the options for establishing security using Transparent Data Encryption (TDE) to safeguard data at rest for an Oracle non-multi-tenant database in Amazon RDS Custom for Oracle. The second part will focus on TDE implementation for multi-tenant databases.
Introducing Amazon RDS for MariaDB 10.11 for Up to 40% Higher Transaction Throughput
by Sai Kiran Kshatriya
on 21 AUG 2023
in Advanced (300), Amazon RDS, Announcements, RDS for MariaDB
MariaDB is a widely-used open-source, high-performance database. Amazon RDS for MariaDB supports multiple major engine versions, including 10.4, 10.5, and 10.6. We are excited to announce support for MariaDB major version 10.11, which offers up to 40% higher transaction throughput compared to previous versions.
Deploying Multi-Region Amazon RDS for SQL Server Using Cross-Region Read Replicas with a Disaster Recovery Blueprint – Part 2
by Ravi Mathur
on 14 AUG 2023
in Advanced (300), Amazon Route 53, Amazon Simple Storage Service (S3), RDS for SQL Server, Technical How-to
In our earlier post, we initiated the setup of a multi-Region disaster recovery blueprint using Amazon Route 53, Amazon RDS for SQL Server, and Amazon S3. This post guides you through promoting RDS for SQL Server in the secondary AWS region and executing a cross-Region failover. For additional resources, check out this excellent Reddit link.
Deploying Multi-Region Amazon RDS for SQL Server Using Cross-Region Read Replicas with a Disaster Recovery Blueprint – Part 1
by Ravi Mathur
on 14 AUG 2023
in Advanced (300), Amazon Route 53, Amazon Simple Storage Service (S3), RDS for SQL Server, Technical How-to
Planning for disaster recovery and high availability is crucial for ensuring the continuity and resilience of business operations. When exploring disaster recovery strategies on AWS, there are two main approaches: in-region disaster recovery and cross-region disaster recovery. The choice between these depends on various factors, including the criticality of the application and the specific needs of your organization.
Data Consolidation for Analytical Applications Using Logical Replication for Amazon RDS Multi-AZ Clusters
by Vijay Karumajji, Sean Massey, and Shayon Sanyal
on 14 AUG 2023
in Advanced (300), Best Practices, Kinesis Data Streams, RDS for PostgreSQL, Technical How-to
Amazon RDS Multi-AZ deployments enhance the availability and durability of your database instances. You can deploy highly available, durable PostgreSQL databases across three Availability Zones using Amazon RDS Multi-AZ DB cluster deployments with two readable standby DB instances. With this setup, applications benefit from automatic failover, typically in under a minute.
Managing Case-Insensitive Data in PostgreSQL
by Baji Shaik and Scott Mead
on 11 AUG 2023
in Advanced (300), Amazon Aurora, Amazon RDS, PostgreSQL compatible, RDS for PostgreSQL
Understanding the case sensitivity of text data in PostgreSQL is crucial when executing queries or comparisons to ensure accurate results.