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
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.
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.
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 database services for open source engines
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.
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).
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.
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.
Sample use case
Web application backend with caching
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 »