AWS Database Blog
Category: Database
Another Database Migration Playbook goes live—migrate from Microsoft SQL Server to Amazon Aurora MySQL!
We’re excited to present the first edition of the Microsoft SQL Server to Amazon Aurora MySQL Compatibility Migration Playbook. AWS Database Migration Service (AWS DMS) and AWS Schema Conversion Tool (AWS SCT) help you reduce the effort associated with migration from commercial engines to open-source and Amazon-managed databases. Thus, they help reduce cost and avoid […]
Read MoreBest practices for securing sensitive data in AWS data stores
This blog post focuses on general data security patterns and corresponding AWS security controls that protect your data. Although I mention Amazon RDS and DynamoDB in this post, I plan to cover the implementation-specific details related to Amazon RDS and DynamoDB in two subsequent posts.
Read MoreAmazon RDS Under the Hood: Single-AZ instance recovery
This post describes Amazon RDS Single-AZ RTO and RPO expectations for MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server databases. Amazon Aurora uses a different technology and storage subsystem designed for the cloud. Its single instance recovery process and scenarios are described in the Aurora FAQ.
Read MoreHow to use Amazon DynamoDB global tables to power multiregion architectures
More and more, AWS customers want to make their applications available to globally dispersed users by deploying their application in multiple AWS Regions. These global users expect fast application performance. In this post, I describe how to use Amazon DynamoDB to power the database of a global backend deployed in multiple AWS Regions. I use […]
Read MoreHow to use DynamoDB global secondary indexes to improve query performance and reduce costs
In this post, I demonstrate several ways to use global secondary indexes to query your data, accelerate your application’s performance, and reduce your monthly DynamoDB bill.
Read MoreIntuit story: Automate migration from on-premises MySQL to Amazon Aurora
Databases are core to many of our applications at Intuit. The database team has been working out which architecture to standardize on and what run books and tools to build in order to migrate and then operate in the cloud. We realized that the fastest way to resolve our questions would be to take one of our existing on-premises applications and run it through an actual migration to Amazon Aurora.
Read MoreUse virtual partitioning in the AWS Schema Conversion Tool
In this post, we look at how to use virtual partitioning to optimize your data warehouse migrations using AWS SCT. Virtual partitioning speeds up large table extraction using parallel processing. It is a recommended best practice for data warehouse migrations.
Read MoreHow to use the new Amazon DynamoDB key diagnostics library to visualize and understand your application’s traffic patterns
Today, we released the Amazon DynamoDB key diagnostics library, which enables you to view graphs and dashboards of your most accessed database items. A DynamoDB table can be used in two different capacity modes—provisioned and on-demand. DynamoDB automatically supports your access patterns as long as the traffic against a given item does not exceed 3,000 […]
Read MoreHow to solve some common challenges faced while migrating from Oracle to PostgreSQL
Companies are experiencing exponential data growth year-over-year. Scaling the databases and the hardware infrastructure to keep up is becoming more and more challenging. If your workloads just are not suitable for non-relational data stores, how do you overcome the scaling challenges without spending tons of money in managing the underlying infrastructure? Amazon RDS for PostgreSQL and Amazon […]
Read MoreFriday, November 30: Amazon DynamoDB sessions at re:Invent
This blog post includes the Amazon DynamoDB sessions, workshops, and chalk talks taking place today at AWS re:Invent 2018. You also can see this list in the live session catalog. Follow us on @DynamoDB for re:Invent and other tweets. Friday, November 30 11:30 AM DAT352-R – Migrate Your Nonrelational Database to AWS In this session, learn how […]
Read More