AWS Database Blog
Picking Your First Database to Migrate to Amazon RDS or Amazon Aurora with PostgreSQL-compatibility
David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on-premises and in the cloud. In a previous post, we covered the overall approach you can take to migrate your current […]
Read MoreCross-Region Automatic Disaster Recovery on Amazon RDS for Oracle Database Using DB Snapshots and AWS Lambda
Sameer Malik is a specialist solutions architect and Christian Williams is an enterprise solutions architect at Amazon Web Services. Many AWS users are taking advantage of the managed service offerings that are available in the AWS portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. Amazon Relational Database Service (Amazon RDS) […]
Read MoreReading Amazon S3 Data from Oracle on Amazon EC2
When you’re working with AWS services, Amazon S3 is the first choice to store text data files. In the past, to access S3 data, first you’d download the files and then perform extract, transform, and load (ETL) to load the data into Oracle. This approach has two drawbacks. It takes time to download and perform […]
Read MoreAmazon Aurora Under the Hood: Quorum Membership
Anurag Gupta runs a number of AWS database services, including Amazon Aurora, which he helped design. In this under the hood series, Anurag discusses the design considerations and technology underpinning Aurora. This post is the last in a four-part series discussing how Amazon Aurora uses quorums. In the first post, I described the benefits of […]
Read MoreAmazon Aurora Under the Hood: Reducing Costs Using Quorum Sets
Anurag Gupta runs a number of AWS database services, including Amazon Aurora, which he helped design. In this under the hood series, Anurag discusses the design considerations and technology underpinning Aurora. This post is the third in a four-part series discussing how Amazon Aurora uses quorums. I hope the discussion is useful to you as […]
Read MoreHow to Migrate Your Data Warehouse to Amazon Redshift Using the AWS Schema Conversion Tool Data Extractors
This blog post gives you a quick overview of how you can use the AWS Schema Conversion Tool (AWS SCT) data extractors to migrate your existing data warehouse to Amazon Redshift. Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to analyze all your data using your existing business intelligence […]
Read MoreAmazon Aurora Under the Hood: Quorum Reads and Mutating State
Anurag Gupta runs a number of AWS database services, including Amazon Aurora, which he helped design. In this under the hood series, Anurag discusses the design considerations and technology underpinning Aurora. In my last post, I talked about the benefits of using a quorum model. I discussed how such systems are resilient in the face […]
Read MoreBuilding Distributed Locks with the DynamoDB Lock Client
Alexander Patrikalakis and Sasha Slutsker are senior software development engineers with Amazon. TL;DR At Amazon, teams all across the company build upon AWS services just like AWS’s external customers. Here we have a contribution from Alex and Sasha, who work on teams supporting Amazon.com about a new client library that they developed to make their […]
Read MoreAmazon Aurora under the hood: quorums and correlated failure
Anurag Gupta runs a number of AWS database services, including Amazon Aurora, which he helped design. In this Under the Hood series, Anurag discusses the design considerations and technology underpinning Aurora. Amazon Aurora storage is a highly distributed system that needs to meet the stringent performance, availability, and durability requirements of a high-end relational database. […]
Read MoreImplementing DB Instance Stop and Start in Amazon RDS
This post is from Matt Merriel at AWS partner Kloud, and Marc Teichtahl, manager for AWS Partner Solutions Architecture Australia and New Zealand. Kloud uses the new stop and start capabilities in Amazon RDS to lower costs for customers who don’t require 24×7 access to their databases during the testing and development phases of their […]
Read More