Spider Feature Matrix
You are viewing an old version of this article. View
the current version here.
Not complete yet - still being updated
| Feature | Spider | MariaDB 10.0 | ||
|---|---|---|---|---|
| Clustering and High Availability | ||||
Commit, Rollback transactions on multiple backend | YES | YES | ||
Multiplexing to a number of replicas using xa protocol 2PC | YES | YES | ||
Split brain resolution based on a majority decision, The spider node gets error during accessing data node and on fix term asking, the failed node is remove from the list of replicas so that a failure still enable the cluster to be available | YES | YES | ||
Enable a failed backend to re enter the cluster transparently | NO | NO | ||
Synchronize DDL: table modification, schema changes done on the remote nodes. Spider does not talk to other spider nodes | NO | NO | ||
Transparent partitioning | NO | NO | ||
| Heterogenous Backends | ||||
Oracle database backend when build from source code on Oracle client library installed server with 'ORACLE_HOME' | YES | YES | ||
| Performance | ||||
Index Condition Pushdown | YES | YES | ||
Engine Condition Pushdown | YES | COMING | ||
Concurrent partition scan | YES | COMING | ||
Batched key access | YES | YES | ||
Block hash join | NO | YES | ||
HANDLER backend propagation | YES | YES | ||
HANDLER backend translation from SQL | YES | YES | ||
HANDLER OPEN cache per connection | COMING | COMING | ||
HANDLER use prepared statement | NO | COMING | ||
HANDLER_SOCKET protocol backend propagation | YES | COMING | ||
HANDLER_SOCKET backend translation from SQL | NO | NO | ||
HANDLER backend translation from SQL | YES | YES | ||
Map reduce for ORDER BY ... LIMIT | YES | YES | ||
Map reduce for MAX & MIN | YES | YES | ||
Map reduce for some GROUP BY | YES | YES | ||
Batch multiple WRITES in auto commit to reduce network round trip | YES | YES | ||
Relaxing backend consistency | YES | YES | ||
| Execution Control | ||||
Configuration at table and partition level, settings can change per data collection | YES | YES | ||
Configurable empty result set on errors. For API that does not have transactions replay | YES | YES | ||
Query Cache tuning per table of the on remote backend | YES | YES | ||
Index Hint per table imposed on remote backend | YES | YES | ||
SSL connections to remote backend connections | YES | YES | ||
Table definition discovery from remote backend | YES | YES | ||
Direct SQL execution to backend via UDF | YES | YES | ||
Table re synchronization between backends via UDF | YES | YES |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
