AWS Database Blog

Tag: Amazon Aurora

Reducing Aurora PostgreSQL storage I/O costs

Cost reduction is one of the biggest drivers for many IT departments to explore migration of on-premises workloads to the cloud. This post shares experiences in cost management, with a focus on Amazon Aurora PostgreSQL tuning. History I recently had the privilege of leading the implementation of our Auto Telematics Application in AWS. To provide […]

Read More

Optimizing and tuning queries in Amazon RDS PostgreSQL based on native and external tools

PostgreSQL is one of the most popular open-source relational database systems. The product of more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complicated data workloads. PostgreSQL is considered to be the primary open-source database choice when migrating from […]

Read More

Build highly available MySQL applications using Amazon Aurora Multi-Master

Do you have transactional applications that have high uptime requirements? Do you want a relational database in the cloud to help you meet those requirements? The newly launched Amazon Aurora Multi-Master, is designed for applications that need a relational database resilient to node failures and highly available for both reads and writes. Amazon Aurora is […]

Read More

Automated query caching into Amazon ElastiCache for Amazon RDS, Amazon Aurora and Amazon Redshift

This is a guest blog post by Erik Brandsberg, CTO at Heimdall Data, in partnership with AWS Technical Evangelist Darin Briskman. Heimdall Data is an AWS Advanced Technology partner who in their own words “offers a database proxy on the AWS Marketplace that supports SQL query caching into Amazon ElastiCache for Redis without code changes. […]

Read More

Use the Data API to interact with an Amazon Aurora Serverless MySQL database

Amazon Aurora Serverless is an on-demand, automatically scaling configuration for Amazon Aurora (MySQL-compatible edition). The database automatically starts up, shuts down, and scales capacity based on your application’s needs. It enables you to run your database in the cloud without managing any database instances. It’s a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. Recently, AWS announced […]

Read More

Select the right encryption options for Amazon RDS and Amazon Aurora database engines

Customers are increasingly choosing to encrypt their AWS Cloud databases and data stores by default. This trend is only gaining speed with the evolving meaning of sensitive data (personally identifiable information [PII], etc.) within various regulatory frameworks. Customers also ask AWS for guidance on how to best adopt the latest database encryption options, while maintaining […]

Read More

Improve Business Continuity with Amazon Aurora Global Database

As your business grows increasingly global, your database needs similarly expand. Resources must be just as available to your team in Zurich as they are to your office in Beijing, with the same speed, security, and ease of access. Amazon Aurora Global Database expands your Amazon Aurora database across the planet. Aurora builds its storage volumes […]

Read More

Migrating mission-critical SaaS production workloads to Aurora MySQL from RDS Classic

Sumo Logic started around the same time as the AWS stack was starting to mature. The company initially chose infrastructure that was tried and tested, but also cutting-edge at the time, namely Amazon RDS for MySQL instances. However, over time, that choice started to cost us a significant number of developer hours. Developers spent time […]

Read More

Use cases for query plan management in Amazon Aurora PostgreSQL

This blog post is the second in a series. The previous blog post talks about the need for the stable, consistent database performance amid changes that otherwise can cause regression on execution plans of the SQL statements. It also demonstrates how query plan management (QPM) for Amazon Aurora with PostgreSQL compatibility helps you overcome plan […]

Read More

Introduction to Aurora PostgreSQL Query Plan Management

Like all AWS services, the roadmap for Amazon Aurora PostgreSQL is driven mostly by customer feedback and requests for product enhancement. The feedback from several enterprise customers who have migrated their databases from Oracle and Microsoft SQL Server to Amazon Aurora suggests two things. Enterprises that run their database workloads for critical applications require optimal […]

Read More