AWS Database Blog

Category: Amazon Aurora

Improving 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

Level Up Your Games with Amazon Aurora

Dhruv Thukral and Yahav Biran are solutions architects at Amazon Web Services. Amazon Aurora is a relational database that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Amazon Aurora offers two types of modes: provisioned and serverless. AWS gaming customers that use Aurora have typically observed higher […]

Read More

How to use ProxySQL with open source platforms to split SQL reads and writes on Amazon Aurora clusters

The blog post How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL introduces an architecture that uses the read and write split capabilities of Amazon Aurora PostgreSQL endpoints. This type of architecture works great for Aurora PostgreSQL clusters, but what if you are using Amazon Aurora MySQL clusters […]

Read More

Using Amazon Aurora to seamlessly increase capacity of WordPress database backends

WordPress powers 30 percent of all websites. It is the content management system that we’ve built our business on at Pagely. Our managed WordPress hosting runs entirely on Amazon Web Services. In the same way that Amazon has freed customers from the worries of managing physical hardware and data centers, Pagely enables clients to stop worrying about managing WordPress and instead focus on their mission. Pagely’s dedicated support and experience with successfully running WordPress at scale pairs nicely with Amazon’s technology offerings.

Read More

Best practices for Amazon Aurora MySQL database configuration

After migrating or launching your new Amazon Aurora MySQL instance in the AWS Cloud, have you asked yourself one or more of the following questions? “What are the next steps? How can I make it run optimally?” “Is it recommended to modify any existing parameters?” “What parameters should I modify?” If so, I hope that […]

Read More

Managing PostgreSQL users and roles

PostgreSQL is one of the most popular open-source relational database systems. With 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 commercial databases […]

Read More