AWS Database Blog

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 […]

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 […]

Leveraging SQLAgentOperatorRole in RDS SQL Server

This blog post was reviewed and updated May 2022, to improve readability by adding more step-by-step guidance. SQL Server is a relational database management system developed by Microsoft. Amazon RDS for SQL Server makes it easier to setup, operate, and scale SQL Server deployments in the Cloud. One of the RDS SQL Server components is […]

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 […]

How SimilarWeb moved to Amazon DynamoDB from Couchbase and saved 70%

This is a guest blog post by Doron Grinzaig, a software developer at SimilarWeb, in partnership with AWS solutions architect, Leonid Koren, and AWS senior technical account manager, Ziv Shenhav. NoSQL databases are a great fit for many modern mobile, web, and gaming applications that require scalable, flexible, and highly functional databases. However, NoSQL databases by […]

Upgrade your end-of-support SQL Server instances in VMware Cloud on AWS with ease

If you still have Microsoft SQL Server 2008 and 2008 R2 instances deployed, now is the time to upgrade them. Microsoft end of support (EoS) date for each is almost upon us—July 9, 2019. This means that after that there are no further security updates, which has security and also compliance implications, so don’t wait! Today, I’m excited […]

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 […]

How LifeOmic’s JupiterOne simplifies security and compliance operations with Amazon Neptune

This is a guest blog post by Erkang Zheng, the CISO at LifeOmic. Most organizations take a linear, list-based approach to security operations. It’s a two-dimensional process. First, identify resources. Second, manage their configurations. Ideally the tools and technologies for management also alert security analysts about changes in the environment and help with remediation. The […]

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.

Migrate from MongoDB to Amazon DocumentDB using the offline method

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. The Amazon DocumentDB Migration Guide outlines three primary approaches for migrating from MongoDB to Amazon DocumentDB: offline, online, and hybrid. The offline migration approach is the fastest and simplest of the three, but it […]