Skip to main content

EloqSQL

A distributed SQL database powered by Data Substrate. Elastic at any scale for any workload.

MySQL Compatible

EloqSQL maintains compatibility with the MySQL protocol by leveraging the existing MySQL Parser and Executor as its compute engine. However, it replaces the Innodb storage engine with the enhanced Data Substrate. This advanced engine provides support for various transaction isolation levels, concurrency control protocols, distributed buffer pools, data persistence, and high availability, offering a more robust and scalable solution.

Elastic Parallel Logging

Write-intensive workloads demand highly scalable logging services. Traditional databases write and fsync redo logs to a single disk in the order of their sequence number, creating a bottleneck for the entire system. EloqSQL's patented one-phase commit technique allows concurrent transactions to write and synchronize redo logs to multiple disks in parallel. Benchmarks demonstrate a 4x improvement in transactions per second compared to MySQL.

Elastic Memory Cache

Read-intensive workloads demand highly scalable memory resources. To minimize read latency, keeping all hot data in memory is crucial. EloqSQL supports both hash and range partitioning, enabling it to store vast amounts of hot data across multiple hosts. As the hot data volume increases, EloqSQL can automatically scale out the cluster and rebalance the data range. Additionally, cold data is periodically checkpointed to key-value stores, which can serve cache miss read.

Decoupled Cloud Storage

Large datasets necessitate a decoupled storage layer that can be scaled independently of read and write traffic. Allocating additional compute and memory resources for cold data is wasteful. Traditional shared-nothing architectures require adding more compute nodes as data volume increases, even if read and write traffic remain constant. EloqSQL's decoupled cloud storage allows you to pay only for the disk space and IOPS costs associated with cold data, leading to cost savings and efficient resource utilization.