AWS Database Blog

Category: Database*

How to Migrate from MySQL to Amazon Aurora using AWS SCT and AWS DMS

MySQL is a great open-source database engine, which a lot of companies use because it’s cost-effective. However, like any other open-source database, it takes a lot of work to get commercial-grade performance out of it. As the size of your database increases, the complexity of scaling and crash recovery in MySQL also increases. Scaling out […]

Read More

Get Started with Amazon Elasticsearch Service: Use Dedicated Master Instances to Improve Cluster Stability

Welcome to this introductory series on Elasticsearch and Amazon Elasticsearch Service (Amazon ES). In this and future articles, we provide the basic information that you need to get started with Elasticsearch on AWS. What dedicated master instances are and why you need them Dedicated master instances perform a single function in an Elasticsearch cluster: orchestration. […]

Read More

A serverless solution to schedule your Amazon DynamoDB On-Demand Backup

We recently released On-Demand Backup for Amazon DynamoDB. Using On-Demand Backup, you can create full backups of your DynamoDB tables, helping you meet your corporate and governmental regulatory requirements for data archiving. Now you can back up any table from a few megabytes to hundreds of terabytes of data in size, with the same performance […]

Read More

Amazon Aurora under the hood: indexing geospatial data using Z-order curves

When designing high-performance database systems like Amazon Aurora, you typically want to work on things that deliver the most impact for the broadest set of workloads. But sometimes, it pays to focus on specialized use cases where you have the opportunity to change the game. In this post, let’s take a look at how Aurora […]

Read More

Creating highly available IBM Db2 databases in AWS

by Nicholas Ansell | on | in Database* | Permalink | Comments |  Share

Many AWS customers run mission-critical workloads using the IBM Db2 database platform. Typically, these workloads require a highly available configuration to make sure that the database is available in the event of a node or site failure. The traditional IBM method to achieve high availability is to use shared storage and virtual IP addresses, which […]

Read More

Migrate Microsoft Azure SQL Database to Amazon Aurora

Increasingly, customers are looking to move databases from proprietary engines such as Oracle and Microsoft SQL Server to open source engines running on AWS. One of the preferred destinations for this data is Amazon Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database to an Amazon Aurora MySQL cluster […]

Read More

Monitor Amazon RDS for MySQL and MariaDB logs with Amazon CloudWatch

Amazon RDS has long offered customers the ability to view and download logs associated with their DB instances for troubleshooting purposes. Now, with Amazon Relational Database Service (Amazon RDS) for MySQL and Amazon RDS for MariaDB you can publish your DB instance log events directly to Amazon CloudWatch Logs. By publishing your logs, you can […]

Read More

AWS Database Migration Service and Amazon DynamoDB: What You Need to Know

This post describes the performance aspects of migrating data to Amazon DynamoDB using AWS DMS, minimizing downtime, and converting the data that is more suitable for DynamoDB using either map to record or map to document types.

Read More

Stream data into an Aurora PostgreSQL Database using AWS DMS and Amazon Kinesis Data Firehose

Using AWS Database Migration Service (AWS DMS), you can migrate data from various sources to most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to Oracle. It also supports heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. In addition, […]

Read More

Best Practices for Upgrading Amazon RDS for MySQL and Amazon RDS for MariaDB

One key feature of Amazon RDS is that you can easily upgrade a database instance to a new minor or major version of your database engine. You can perform upgrades on demand by using the AWS Management Console or AWS CLI. You can decide to automatically upgrade to a new minor engine version when it […]

Read More