AWS Database Blog

Category: Advanced (300)

Automatic reconnection to Amazon RDS for Oracle read replicas during disaster recovery

Amazon RDS for Oracle offers ease of operability, maintenance, scalability, and reliability while migrating Oracle workloads to AWS. The read replica in Amazon RDS for Oracle is a physical copy of the primary database that can be set up either in mounted or read-only mode. In mounted mode, the replica instance isn’t open for read operations, however in read-only mode, it allows read operations on the replica instance. During managed Oracle Data Guard Switchover with Oracle RDS for Oracle, the database role reversal takes place between the RDS for Oracle primary database and its replica. Similarly, in case of a disaster, you can promote the read replica to a standalone instance. In both scenarios, the application needs to point to the endpoint of the new primary database to establish connectivity. In this post, we provide guidance to configure the automatic reconnection of the application to a standby database during a disaster recovery incident while using replication with Oracle Data Guard using Oracle services and a TNS names connection alias.

Migrating tables from IBM Db2 for z/OS to Amazon RDS for Db2

Amazon RDS for Db2 is the latest addition to the Amazon RDS family of database engines. When it comes to selecting the relational database to migrate data from Db2 for z/OS, RDS for Db2 provides the best compatibility among other relational database management systems (RDBMSs) thereby minimizing the migration effort and timelines. In this post, we outline the migration methodology for converting schema and data from Db2 on z/OS to RDS for Db2.

Get started with Amazon MemoryDB for Valkey

Today, Amazon MemoryDB announces support for Valkey version 7.2, with 30% lower instance hour pricing as compared to Amazon MemoryDB for Redis OSS. With MemoryDB for Valkey, there is no charge for data written up to 10 TB per month, and then billed at $0.04/GB for any data written over 10 TB. Valkey is an […]

Get started with Amazon ElastiCache for Valkey

Today, Amazon ElastiCache announces support for Valkey version 7.2 with Serverless priced 33% lower and self-designed (node-based) clusters priced 20% lower than other supported engines. With ElastiCache Serverless for Valkey, customers can create a cache in under a minute and get started as low as $6/month. Valkey is an open source, high performance, key-value datastore […]

Load balancing strategies for Amazon RDS for SQL Server read replicas to scale read workloads and reduce latency

Amazon Relational Database Service (Amazon RDS) for SQL Server makes it straightforward to set up, operate, and scale SQL Server deployments in the AWS Cloud. The service allows DBAs to focus on high-value tasks such as query optimization, query construction, and schema design rather than time-consuming database administration tasks including provisioning, backups, software patching, monitoring, […]

Vector search for Amazon DynamoDB with zero ETL for Amazon OpenSearch Service

As organizations increasingly rely on Amazon DynamoDB for their operational database needs, the demand for advanced data insights and enhanced search capabilities continues to grow. Leveraging the power of Amazon OpenSearch Service and Amazon Bedrock, you can now unlock generative artificial intelligence (AI) capabilities for your DynamoDB data. In this post, we show how you […]

How BCM One migrated data from an unencrypted Amazon RDS for PostgreSQL database instance to a new encrypted instance using AWS DMS

This post is co-authored with Kate Fike, Software Engineer at BCM One. BCM One is a leading global provider of NextGen Communications and Managed Services to IT leaders and channel resellers. They have multiple NextGen Communications brands, including Flowroute. Flowroute offers SIP trunking and a business messaging platform for mission-critical voice applications. In this post, […]

Configure cross-account Amazon S3 as a source or target for AWS DMS

In this post, we delve into the intricacies of configuring AWS DMS replication instances to use an S3 bucket in a different account. We also explore the process of establishing a connection between AWS DMS Serverless and S3 buckets across distinct accounts.