Best Relational Database for Amazon Web Services (AWS)

Percona Server for MySQL is a free, fully-compatible, enhanced, open source drop-in replacement for MySQL. It provides superior performance, scalability, and instrumentation. With over 5,300,000 downloads, Percona Server’s self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability Percona Server for MySQL delivers enterprise-grade features and higher uptime, along with a number of key benefits that improve database performance and efficiency. It provides more time to focus on key priorities, as users need to spend less time on tuning and administering. Percona is a market leader in providing best-of-breed enterprise-class software, support, consulting, managed services, and training for on-premise and cloud-based open source databases. Percona was founded on the belief that everyone should have access to scalable, secure, efficient, and resilient database software features, without inflated fees or vendor lock-in.

ScaleGrid is a fully managed Database-as-a-Service (DBaaS) platform that helps you automate your time-consuming database administration tasks both in the cloud and on-premises. Easily provision, monitor, backup and scale your open source databases with high availability, advanced security, full superuser and SSH access, query analysis, and troubleshooting support to improve the performance of your deployments. Supported databases include: - MySQL - PostgreSQL - Redis™ - MongoDB® database - Greenplum™ (coming soon) The ScaleGrid platform supports both public and private clouds, including AWS, Azure, Google Cloud Platform (GCP), DigitalOcean, Linode, Oracle Cloud Infrastructure (OCI), VMware and OpenStack. Used by thousands of developers, startups, and enterprise customers including Atlassian, Meteor, and Accenture, ScaleGrid handles all your database operations at any scale so you can focus on your application performance.

SingleStore (formerly MemSQL) is a distributed, highly-scalable SQL database that can run anywhere. We deliver maximum performance for transactional and analytical workloads with familiar relational models. SingleStore is a scalable SQL database that ingests data continuously to perform operational analytics for the front lines of your business. Ingest millions of events per second with ACID transactions while simultaneously analyzing billions of rows of data in relational SQL, JSON, geospatial, and full-text search formats. SingleStore delivers ultimate data ingestion performance at scale and supports built in batch loading and real time data pipelines. SingleStore lets you achieve ultra fast query response across both live and historical data using familiar ANSI SQL. Perform ad hoc analysis with business intelligence tools, run machine learning algorithms for real-time scoring, perform geoanalytic queries in real time.

Virtuoso Universal Server is a modern platform built on existing open standards that harnesses the power of Hyperlinks ( functioning as Super Keys ) for breaking down data silos that impede both user and enterprise ability. Using Virtuoso, you can easily generate financial profile knowledge graphs from near real time financial activity that reduce the cost and complexity associated with detecting fraudent activity patterns. Courtesy of its high-performance, secure, and scalable dbms engine, you can use intelligent reasoning and inference to harmonize fragmented identities using personally identifying attributes such as email addresses, phone numbers, social-security numbers, drivers licenses, etc. for building fraud detection solutions. Virtuoso helps you build powerful solutions applications driven by knowledge graphs derived from a variety of life sciences oriented data sources.

Fully managed and hosted PostgreSQL with high performance and all the extensions you want out of the box. Set up fully managed PostgreSQL in less than 10 minutes — directly from our web console or programmatically via our API, CLI, Terraform provider or Kubernetes operator. Our stand-by nodes act automatically as read replicas, and you can also create additional read replicas in different public clouds and regions, even building multi-cloud architectures. Our Point-In-Time-Recovery lets you restore your data to any time within your selected retention period. A fully managed SQL relational database, deployable in the cloud of your choice. Known for reliability, a robust set of features, and exceptionally high performance. Fits well for almost any case, such as creating location-based services, mission critical business applications or simply as a general transactional database.

Save time & costs by streamlining data pipelines with zero-maintenance open source solutions. From ingestion to visualization, all are integrated, fully managed, and highly reliable, so your engineers will love working with data. You choose whether to use any of DoubleCloud’s managed open source services or leverage the full power of the platform, including data storage, orchestration, ELT, and real-time visualization. We provide leading open source services like ClickHouse, Kafka, and Airflow, with deployment on Amazon Web Services or Google Cloud. Our no-code ELT tool allows real-time data syncing between systems, fast, serverless, and seamlessly integrated with your existing infrastructure. With our managed open-source data visualization you can simply visualize your data in real time by building charts and dashboards. We’ve designed our platform to make the day-to-day life of engineers more convenient.

Apache Druid is an open source distributed data store. Druid’s core design combines ideas from data warehouses, timeseries databases, and search systems to create a high performance real-time analytics database for a broad range of use cases. Druid merges key characteristics of each of the 3 systems into its ingestion layer, storage format, querying layer, and core architecture. Druid stores and compresses each column individually, and only needs to read the ones needed for a particular query, which supports fast scans, rankings, and groupBys. Druid creates inverted indexes for string values for fast search and filter. Out-of-the-box connectors for Apache Kafka, HDFS, AWS S3, stream processors, and more. Druid intelligently partitions data based on time and time-based queries are significantly faster than traditional databases. Scale up or down by just adding or removing servers, and Druid automatically rebalances. Fault-tolerant architecture routes around server failures.

XTDB is an immutable SQL database designed to simplify application development and ensure data compliance. It automatically preserves data history, enabling comprehensive time-travel queries. Users can perform as-of queries and audits using SQL commands. XTDB is trusted by various companies to transform dynamic and temporal applications. It is easy to get started with via HTTP, plain SQL, or various programming languages, requiring only a client driver or Curl. Users can effortlessly insert data immutably, query it across time, and execute complex joins. Risk systems benefit directly from bitemporal modeling. Valid time can be used to correlate out-of-order trade data whilst making compliance easy. Exposing data across an organization is a challenge when things are changing all the time. XTDB simplifies data exchange and can power advanced temporal analysis. Modeling future pricing, tax, and discount changes requires extensive temporal queries.