AWS Database Blog

Amazon Aurora as an Alternative to Oracle RAC

Written by David Yahalom, CTO and co-founder of NAYA Tech—a leading database, big data, and cloud professional and consulting service provider, located in San Jose, CA. In this post, I discuss how Amazon Aurora can serve as a powerful and flexible alternative to Oracle RAC. Both Oracle RAC and Amazon Aurora are designed to provide increased high availability and performance scalability for your databases.

Read More

Crowdsource Database Migration—Let’s Do It Together

We always treat database migration projects as a development exercise. Each project should have proper planning (that is, design), execution, and of course testing. Each step involves developer collaboration. Developers also just like to collaborate on tools, methodologies, and a nice piece of code. We want to facilitate developer collaboration for migration projects, to bring more tools and methods to the community to allow better, smoother, and faster migrations. As part of this effort, we recently launched two GitHub repositories, for AWS DMS samples and AWS DMS tools.

Read More

Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong (Part 2)

In our previous post, we covered the initial steps to debug AWS Database Migration Service (DMS) migrations for environmental issues. In this post, we continue the debugging process, discussing problems with migration tasks that aren’t in the list preceding and that aren’t due to environmental issues. We review CloudWatch graphs and task and table states to shed light on DMS migrations.

Read More

Part 1 – Role of the DBA When Moving to Amazon RDS: Responsibilities

This blog post is the first in a two-part series. In this first post, we discuss how moving to Amazon Relational Database Service (Amazon RDS) can change your role as a traditional DBA and bring more value to you, the business, key projects, and end users. In the next post, we will discuss how to use other AWS products to automate any remaining regular tasks in Amazon RDS.

Read More

Debugging Your AWS DMS Migrations: What to Do When Things Go Wrong (Part 1)

This post walks you through a troubleshooting flow chart to help you understand what could go wrong with migrations using AWS DMS, and it discusses best practices for debugging your AWS DMS migrations. This process involves creating the required AWS DMS components—like the replication instance, source and target endpoints, and the replication task to migrate data from the source endpoint to the target endpoint.

Read More

How the AWS Schema Conversion Tool Drove Trimble’s Database Migration Successes

By Todd Hofert, Director of Infrastructure Operations—FSM at Trimble Inc. The situation Recently, the Infrastructure Operations Group for Trimble’s Field Service Management division embarked on an aggressive initiative to migrate their privately hosted SaaS offerings to Amazon Web Services (AWS). The division faced the need for a hardware refresh, continuing cost reduction pressures, and a […]

Read More

Automating AWS DMS Migration Tasks

This blog post gives you a quick overview of how you can schedule migration tasks for the purpose of automating your migration. You create these tasks by using the AWS Database Migration Service (AWS DMS) and using native operating system tools for either Linux or Microsoft Windows.

Read More

Managing Amazon ElastiCache with Terraform

Nic Jackson is Developer Advocate at HashiCorp. Developers continue to pick Redis as their favorite NoSQL data store (see the Stack Overflow Developer Survey 2017). Amazon ElastiCache provides easy, fast, and highly available Redis on AWS. ElastiCache for Redis can be deployed via the AWS Management Console, AWS SDK, Amazon ElastiCache API, AWS CloudFormation, and […]

Read More

Introducing Amazon S3 and Microsoft Azure SQL Database Connectors in AWS Database Migration Service

We are excited to announce the addition of two new database connectors in AWS Database Migration Service (AWS DMS)—Amazon S3 as a source and Microsoft Azure SQL Database as a source. You can now migrate data from these two new sources to all AWS DMS supported targets. Amazon S3 as a source You can now […]

Read More

Viewing Amazon Elasticsearch Service Slow Logs

Today, Amazon Elasticsearch Service (Amazon ES) announced support for publishing slow logs to Amazon CloudWatch Logs. This new feature enables you to publish Elasticsearch slow logs from your indexing and search operations and gain insights into the performance of those operations. You can enable slow logs to identify whether a performance issue on your cluster […]

Read More