AWS Database Blog

Category: Database

How Autodesk Increased Database Scalability and Reduced Replication Lag with Amazon Aurora

Autodesk is a leader in 3D design, engineering, and entertainment software. Autodesk makes software for people who make things. If you’ve ever driven a high-performance car, admired a towering skyscraper, used a smartphone, or watched a great film, chances are you’ve experienced what millions of Autodesk customers are doing with their software. Autodesk has successfully […]

Read More

How to plan and optimize Amazon Aurora with MySQL compatibility for consolidated workloads

Amazon Aurora with MySQL compatibility is a popular choice for customers looking to consolidate database workloads. Aurora MySQL is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. It also delivers up to five times the throughput of the standard MySQL community […]

Read More

Stream changes from Amazon RDS for PostgreSQL using Amazon Kinesis Data Streams and AWS Lambda

In this post, I discuss how to integrate a central Amazon Relational Database Service (Amazon RDS) for PostgreSQL database with other systems by streaming its modifications into Amazon Kinesis Data Streams. An earlier post, Streaming Changes in a Database with Amazon Kinesis, described how to integrate a central RDS for MySQL database with other systems […]

Read More

Best practices for migrating RDS for MySQL databases to Amazon Aurora

MySQL is the most popular open-source database in the world. However, many customers find that the undifferentiated heavy lifting of backups, high availability, and scaling of MySQL databases to be complex, time-consuming, or both. This is one of the leading reasons why customers move their existing MySQL footprint to Amazon RDS for MySQL. Amazon RDS […]

Read More

AWS Schema Conversion Tool introduces new features in build 616

We are excited to introduce a new version of AWS Schema Conversion Tool (AWS SCT) that includes support for PostgreSQL 10 partitioning, a new server-level Assessment Report, support for table-valued functions, and more. For those of you who are new to AWS SCT, this tool helps convert your existing database schema from one database engine […]

Read More

Failover with Amazon Aurora PostgreSQL

Replication, failover, resilience, disaster recovery, and backups—it can be challenging to achieve any or all of these in a traditional or non-cloud-based architecture. In addition, they sometimes require a considerable re-engineering effort. Due to the high implementation and infrastructure costs that are involved, some businesses are compelled to tier their applications so that only the […]

Read More

How to work with native CDC support in AWS DMS

AWS Database Migration Service (AWS DWS) today launches native CDC support and the ability to start and stop the AWS DMS replication from a specific checkpoint. When you work with this feature, you can use checkpoints such as a log sequence number (LSN) in Microsoft SQL Server, a system change number (SCN) in Oracle, and […]

Read More

Build a notification mechanism to manage Amazon RDS manual snapshots

It’s no secret that data is an essential part of running a business, no matter how large or small a business may be. Many companies host their business data using relational databases. As a result, backup and recovery are important aspects of keeping the business running. Amazon RDS customers use a mixture of strategies to […]

Read More

Cal Poly’s software engineering capstone class builds MySQL capture and replay on AWS

At California Polytechnic State University, the software engineering school’s capstone class was created in support of the university’s “Learn by Doing” philosophy. Students in the class experience over the course of a full school year what it’s like to work on a collaborative industry project. This is Dr. David Janzen’s tenth year teaching this course, […]

Read More

How to rapidly develop applications on Amazon Cloud Directory with Managed Schema

Now, Amazon Cloud Directory makes it easier than ever for you to rapidly develop applications by using Managed Schema. You can create a directory and start creating and retrieving objects from it at a faster pace by using the managed schema. With this launch, we are making available one Cloud Directory Managed Schema, called QuickStartSchema. […]

Read More