What to choose: review our chart of distributed database choices and use cases
eXtremeDB for HPC delivers the benefits of distributed database management via distributed query processing, clustering and high availability options.
Distributed Query Processing
eXtremeDB for HPC partitions, or shards, a database and distributes query processing across multiple servers, CPUs and/or CPU cores. Performance is accelerated — dramatically, in some cases — via parallel execution of database operations and by harnessing the capabilities of many host computers rather than just one.
The benefits of distributed query processing are evident in McObjects recent STAC-M3 benchmarks. We partnered with E8 Storage, IBM, and Lucera Financial Infrastructures to name a few. In these tests, the eXtremeDB database was partitioned horizontally across up to 128 shards, resulting in record-setting performance managing tick data. Please use the following link to review a summary of the benchmark records.
eXtremeDB offers different distributed database options to address different objectives. Learn about Sharding with eXtremeDB, or review this table that lists different distributed database uses and options.
Sharding
eXtremeDB offers ultra-fast, elastically scalable data management with sharding.
Databases are partitioned (“sharded”), with each partition/shard managed by an instance of the DBMS server. Shards are typically distributed on a storage array (which may be a SAN) – with each server keeping a CPU core busy – or distributed across different physical servers with their own storage systems.
Read about using the eXtremeSQL distributed SQL engine in our on-line documentation
Learn more about eXtremeDB distributed query processing
Learn about Sharding for elastic scalability
High Availability
High availability enables deployment of a master database and one or more synchronized replica databases. Replication is between separate hardware instances and features application-directed fail-over with strategies that include 2-safe (synchronous) and 1-safe (asynchronous). It delivers “five nines” (99.999% uptime) reliability, or better, with eXtremeDB for HPC’s unsurpassed performance. In addition, read-only replicas are available to support distribution/load-balancing of database query/analysis/reporting requirements.
Read about High Availability in our on-line documentation
Learn more about eXtremeDB time-cognizant eager replication
Read our Q&A, What is a Distributed Database?
Read about High Availability in our on-line documentation
Learn more about eXtremeDB time-cognizant eager replication
Clustering
In clustered deployments, every eXtremeDB HPC database instance serves as a master. This means that changes to one node are efficiently replicated to others. It is unique as the first clustering database system to offer an embedded architecture. The database system runs within the application process at every node, eliminating the need for separate client and server modules.
Read about clustering our on-line documentation
Learn more about eXtremeDB independently audited speed records.
Learn about other eXtremeDB distributed database options
