Need advice about which tool to choose?Ask the StackShare community!
ClustrixDB vs FoundationDB: What are the differences?
What is ClustrixDB? Clustered SQL database built for e-commerce. ClustrixDB is a scale-out SQL database built from the ground up with a distributed shared nothing architecture, automatic data redistribution (so you never need to shard), with built in fault tolerance, all accessible by a simple SQL interface and support for business critical MySQL features – replication, triggers, stored routines, etc.
What is FoundationDB? Multi-model database with particularly strong fault tolerance, performance, and operational ease. FoundationDB is a NoSQL database with a shared nothing architecture. Designed around a "core" ordered key-value database, additional features and data models are supplied in layers. The key-value database, as well as all layers, supports full, cross-key and cross-server ACID transactions.
ClustrixDB and FoundationDB can be categorized as "Databases" tools.
Some of the features offered by ClustrixDB are:
- Is built from the ground up with a shared-nothing architecture. There is no MySQL code in ClustrixDB
- Is built to scale transactions while maintaning ACID
- Scales to add capacity by simply adding commodity servers to the cluster
On the other hand, FoundationDB provides the following key features:
- Multiple data models
- Full, multi-key ACID transactions
- No locking
So, we started using foundationDB for an OLAP system although the inbuilt tools for some core things like aggregation and filtering were negligible, with the high through put of the DB, we were able to handle it on the application. The system has been running pretty well for the past 6 months, although the data load isn’t very high yet, the performance is fairly promising
Pros of ClustrixDB
- ClustrixDB is a scale-out RDBMS and drop-in replacement1
- Very High Connection Count1
- Relational Scale-Out database1
Pros of FoundationDB
- ACID transactions6
- Linear scalability5
- Multi-model database3
- Key-Value Store3
- Great Foundation3
- SQL Layer1