AWS Database Blog

Upgrade Your End of Support Microsoft 2008 R2 Workloads in AWS with Ease

Many IT organizations have run the Microsoft Windows Server 2008 R2 operating system, SQL Server 2008 and SQL Server 2008 R2 database systems for over a decade. End-of-support (EOS) dates are fast approaching (July 2019 for SQL Server and January 2020 for Windows Server). Thus, it’s critical these systems get upgraded to a supported version […]

Read More

Run a petabyte scale cluster in Amazon Elasticsearch Service

When you use Amazon Elasticsearch Service (Amazon ES) for log data, you’re drinking from what usually becomes a forceful firehose. As your Elasticsearch and Kibana knowledge deepens, you find many compelling uses of your data. As your customer base scales up and you scale your infrastructure to handle it, you generate even more log data. […]

Read More

Classify OLTP and OLAP workloads using AWS SCT with Workload Qualification Framework (WQF)

Migration is a multiphase process, and different steps are involved based on the type of migration you’re doing. With the help of AWS Schema Conversion Tool (AWS SCT) reports and involvement of partners, you can automate more than 50 percent of the work. However, another large percentage of work still is required. This is where […]

Read More

Best practices for configuring parameters for Amazon RDS for MySQL, part 3: Parameters related to security, operational manageability, and connectivity timeout

In the previous blog post of this series, I discuss MySQL parameters used to optimize replication in Amazon RDS for MySQL and best practices related to them. In today’s post, I discuss the most important and commonly used MySQL parameters for implementing various security features in the RDS MySQL environment. I also discuss some of […]

Read More

How to use Amazon DocumentDB (with MongoDB compatibility) to build and manage applications at scale

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. Data in Amazon DocumentDB is stored as JSON-like documents and maps naturally to how data is modeled in applications. This approach makes the storing, querying, and processing of data between your application and Amazon […]

Read More

Increase availability for Amazon Elasticsearch Service by deploying in three Availability Zones

Today, Amazon Elasticsearch Service (Amazon ES) announced support for deploying your domains across three Availability Zones (AZ). This feature is available in all AWS Regions that support at least three Availability Zones. With this new feature, you can spread out your master and data nodes to gain better tolerance for Availability Zone failures. Additionally, the AWS Management […]

Read More

Deploy smart contracts to your private Ethereum blockchain network on AWS

The team that supports the GUI wallet referenced in this blog have decided to sunset their “Ethereum Wallet” application. In the process they have introduced a breaking change that prevents successful implementation of the steps outlined below. You can use blockchain for use cases where multiple parties need to transact and share data in a […]

Read More

Best practices for configuring parameters for Amazon RDS for MySQL, part 2: Parameters related to replication

In the previous blog post of this series, I discuss MySQL parameters used to tune and optimize Amazon RDS for MySQL performance and best practices related to them. In today’s post, I discuss the most important MySQL parameters used for replication configuration and optimizing replication in an RDS MySQL environment. Parameters related to both single […]

Read More

Using the MariaDB JDBC driver with Amazon Aurora with MySQL compatibility

This blog post demonstrates how to use the MariaDB JDBC driver, known as MariaDB Connector/J, to connect to an Amazon Aurora cluster. In this post, we use the automatic failover capability of the connector to switch rapidly and seamlessly between master and replica in a failover situation. You can download MariaDB Connector/J from the MariaDB […]

Read More

Create AWS CloudFormation templates for AWS DMS tasks using Microsoft Excel

This blog post talks about a tool that automates creation of AWS CloudFormation templates for AWS Database Migration Service (AWS DMS) tasks. If you are looking for how to create CloudFormation templates for your DMS tasks and don’t have knowledge of CloudFormation, read on. Many times during database migration activities where AWS DMS is involved, […]

Read More