Category: Best Practices

Databases form a key part of any enterprise and managing databases during an M&A requires careful planning and implementation to ensure a smooth transition and to maintain data integrity. In this post, we highlight some of the key considerations for successful database management during a merger or acquisition spanning from data assessment to integration strategies.

For those seeking to achieve consistent database transaction performance, Amazon RDS has introduced a new feature: dedicated log volume (DLV). This feature is an additional storage volume specifically for database transaction logs. In this post, we examine common DLV performance benefits, use cases, monitoring capabilities, and the cost of deployment.

In this post, we explore the key factors to consider when selecting a database for your generative AI applications. We focus on high-level considerations and service characteristics that are relevant to fully managed databases with vector search capabilities currently available on AWS. We examine how these databases differ in terms of their behavior and performance, and provide guidance on how to make an informed decision based on your specific requirements.

Parallel indexing in Amazon DocumentDB (with MongoDB compatibility) significantly reduces the time to create indexes. In this post, we show you how parallel indexing works, its benefits, and best practices for implementation.

Change data capture (CDC) is the process of capturing changes to data from a database and publishing them to an event stream, making the changes available for other systems to consume. Amazon DynamoDB CDC offers a powerful mechanism for capturing, processing, and reacting to data changes in near real time. Whether you’re building event-driven applications, […]

AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your databases to AWS securely with minimal downtime and zero data loss. You can use this service for both homogeneous or heterogeneous migrations. Data migration challenges can vary depending on the size of the data, complexity of the data […]

You can use AWS Database Migration Service (AWS DMS) for many use cases, such as migrating from legacy or on-premises databases to managed cloud services, replicating ongoing data changes from online transaction processing (OLTP) databases such as Amazon Relational Database Service (Amazon RDS) to an online analytical processing (OLAP) data warehouse such as Amazon Redshift, […]

Customers are actively exploring opportunities to optimize their expenses, aligning with the Cost Optimization pillar of the AWS Well-Architected Framework. In this post, we discuss the following tools that you can use to analyze your spend and optimize your Amazon Relational Database Service (Amazon RDS) costs.

In this post, we show you how to successfully set up SSL connectivity with Amazon Relational Database Service (Amazon RDS) for Oracle. For the purpose of this post, we have considered scenarios of SSL connectivity with the source as a SQL Plus client over a Linux platform and also a Java application client. SSL connectivity […]

Amazon Relational Database Service (Amazon RDS) Multi-AZ DB Clusters are a great way to improve the performance and reduce the cost of demanding database workloads. Since RDS Multi-AZ DB Clusters were launched in March 2022, they have become an increasingly popular option for workloads that need more performance than a single RDS instance can support. […]