Open Source Databases

Open source databases now support a vast array of modern applications, ranging from the most popular mobile apps, to the leading eCommerce platforms, to mission critical enterprise systems for F500 organizations. In fact, open source databases like MySQL, PostgreSQL, MongoDB, and Redis all rank among the world’s most popular databases. Fast-growing companies and large enterprises alike prefer open source databases due to their low cost, freedom from traditional license models, flexibility, community-backed development and support, and large ecosystems of tools and extensions. While open source databases are widely available, they can become difficult and time-consuming to manage in production environments. AWS Database services make it easy to manage open source database workloads in the cloud with performance, scalability, and availability.

Popular open source database engines

MySQL is the most widely adopted open source relational database and serves as the primary relational data store for many popular websites, applications, and commercial products.

AWS Offerings

PostgreSQL is a feature-rich open source relational database backed by more than 20 years of community development. It is the primary data store for many web, mobile, geospatial, and analytics applications.

AWS Offerings

MariaDB is a popular variant of MySQL which was founded by the original developers of MySQL. While MariaDB is maintained separately from MySQL and includes its own rich feature sets, it retains a high degree of MySQL compatibility, including library binary equivalency, and exact matching with APIs.

AWS Offerings

MongoDB is an open source, NoSQL database that provides support for JSON-styled, document-oriented storage systems. Its offers a flexible data model and provides full index support, sharding, and replication.

AWS Offerings

Redis is a fast, open source, in-memory key-value data store for use as a database, cache, message broker, and queue. Redis is a popular choice for caching, session management, real-time analytics, geospatial, chat/messaging, media streaming, and gaming leaderboards.

AWS Offerings

Memcached is an easy-to-use, high-performance, in-memory data store. It offers a mature, scalable, open-source solution for delivering sub-millisecond response times making it useful as a cache or session store.

AWS Offerings

AWS database services for open source engines

Amazon Relational Database Service (RDS)

A managed service that makes it easy to set up, operate, and scale a relational database in the cloud. Amazon RDS supports 6 familiar engines, including 3 open source databases: MySQL, PostgreSQL, and MariaDB. RDS supports the latest major and minor versions of open source databases, ensuring that the code, applications, and tools you already use today can be used with Amazon RDS.

Learn more »

Amazon Aurora

A MySQL- and PostgreSQL-compatible relational database built for the cloud. Amazon Aurora gives you 5x the performance of MySQL and 3x of PostgreSQL, with the security, availability, and reliability of commercial-grade databases at 1/10th the cost. Aurora features a distributed storage system that auto-scales up to 64TB per database instance. It delivers high performance and availability with up to 15 read replicas, point-in-time recovery, continuous backup, and replication across three Availability Zones (AZs).

Learn more »

Amazon ElastiCache

A Redis- and Memcached-compatible in-memory data store that gives you microsecond latency for millions of reads and writes per second. Built on open source Redis, Amazon ElastiCache for Redis works with your Redis clients and uses the open Redis data format to store your data. Amazon ElastiCache for Memcached is a Memcached-compatible in-memory key-value store service that can be used as a cache or a data store.

Learn more »

Amazon DocumentDB

A fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. Amazon DocumentDB is designed from the ground-up to give you the performance, scalability, and availability you need when operating mission-critical MongoDB workloads at scale. Amazon DocumentDB implements the Apache 2.0 open source MongoDB 3.6 and 4.0 APIs, allowing you to use your existing MongoDB drivers and tools with Amazon DocumentDB.

Learn more »

Sample use case

Web application backend with caching

Managed Open Source

Customer stories

Airbnb is a community marketplace that allows property owners and travelers to connect with each other for the purpose of renting unique vacation spaces around the world. Airbnb moved its MySQL database to Amazon Relational Database Service (Amazon RDS) because it simplifies much of the time-consuming administrative tasks typically associated with databases. Amazon RDS allows difficult procedures, such as replication and scaling, to be completed with a basic API call or through the AWS Management Console. Learn more »

Grab is an online transportation network and technology company with the goal to make transportation accessible to everyone. Grab is available across six countries in Singapore, Malaysia, Indonesia, Thailand, Vietnam, and Philippines. By using Amazon Redshift and Amazon ElastiCache for Redis, Grab is able to use real time data computation and data streams to support 1.5 million bookings in Southeast Asia. Learn more »

Trimble is a global leader in telematics solutions. They had a significant investment in on-premises hardware in North America and Europe running Oracle databases. Rather than refresh the hardware and renew the licenses, they opted to migrate the databases to AWS. They ran the AWS Schema Conversion Tool to analyze the effort, and then migrated their complete database to a managed PostgreSQL database on Amazon RDS. Learn more »

Getting started

Tutorial

Create and Connect to a MySQL Database with Amazon RDS

In this tutorial, you will learn how to create an environment to run your MySQL database (we call this environment an 'instance'), connect to the database, and delete the DB instance. 

Learn more »
Tutorial

Create and Connect to a PostgreSQL Database with Amazon RDS

In this tutorial, you will learn how to create an environment to run your PostgreSQL database (we call this environment an 'instance'), connect to the database, and delete the DB instance.

Learn more »
Tutorial

Create and Connect to a MariaDB Database with Amazon RDS

In this tutorial, you will learn how to create an environment to run your MariaDB database (we call this environment an 'instance'), connect to the database, and delete the DB instance.

Learn more »
Tutorial

Configure and connect to serverless MySQL database with Amazon Aurora Serverless

In this tutorial, you will learn how to configure and connect to Amazon Aurora Serverless.

Learn more »
Tutorial

Getting started with Amazon ElastiCache for Redis

Find topics that lead you through creating, granting access to, connecting to, and finally deleting a Redis (cluster mode disabled) cluster using the ElastiCache Management Console.

Learn more »
Tutorial

Speeding up WordPress with Amazon ElastiCache for Memcached

In this tutorial we will explore how to improve the performance of your WordPress website with Amazon ElastiCache for Memcached.

Learn more »

Resources

Videos

AWS re:Invent 2018: Deep Dive on MySQL Databases on Amazon RDS (1:00:27)
AWS re:Invent 2018: Deep Dive on PostgreSQL Databases on Amazon RDS (46:25)
AWS re:Invent 2018: Reliable & Scalable Redis in the Cloud with Amazon ElastiCache (1:00:56)

Webinars

Documentation