AWS Database Blog

Category: Amazon Aurora

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

Creating a proof of concept using Amazon Aurora

As customers move to the cloud, they’re looking for the best tools to run their applications. When considering relational databases, Amazon Aurora is a frequent choice. This is no surprise, given that Amazon Aurora is MySQL and PostgreSQL wire-compatible and that it can provide greater throughput than either. Aurora provides up to five times the […]

Read More

Deploy an Amazon Aurora PostgreSQL DB cluster with recommended best practices using AWS CloudFormation

In this blog post, I cover how to build a quick start reference deployment of Amazon Aurora PostgreSQL cluster. The cluster is based on AWS best practices for security and high availability and you can create it quickly by using AWS CloudFormation. I walk through a set of sample CloudFormation templates, which you can customize […]

Read More

Using the MariaDB JDBC driver with Amazon Aurora with MySQL compatibility

This blog post demonstrates how to use the MariaDB JDBC driver, known as MariaDB Connector/J, to connect to an Amazon Aurora cluster. In this post, we use the automatic failover capability of the connector to switch rapidly and seamlessly between master and replica in a failover situation. You can download MariaDB Connector/J from the MariaDB […]

Read More