W3cubDocs

/MariaDB

Spider Feature Matrix

MariaDB starting with 10.0.4

The Spider storage engine was introduced in MariaDB 10.0.4

Not complete yet - still being updated

F(*) Federation only , P(*)partioning only . Spider column is for SpiderForMySQL found on the Spider web sIte.

Feature Spider 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, failed node is remove from the list of replicas Yes Yes
Enable a failed backend to re enter the cluster transparently No No
Synchronize DDL to backend, table modification, schema changes No No
Synchronize DDL to other Spider No No
GTID tracking per table on XA error No Yes
Transparent partitioning No No
Covered by generic SQL test case Yes Yes
Heterogenous Backends
MariaDB and MySQL database backend Yes Yes
Oracle database backend, if build from source against the client library 'ORACLE_HOME' Yes Yes
Local table attachment Yes Yes
Performance
Index Condition Pushdown No No
Engine Condition Pushdown Yes Yes
Concurrent backend scan Yes No
Concurrent partition scan Yes No
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 No Yes
HANDLER use prepared statement No Yes
HANDLER_SOCKET protocol backend propagation Yes Yes
HANDLER_SOCKET backend translation from SQL No No
Map reduce for ORDER BY ... LIMIT Yes Yes
Map reduce for MAX & MIN & SUM 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 F(*)
Direct SQL execution to backend via UDF Yes Yes
Table re synchronization between backends via UDF Yes Yes
Maintain Index and Table Statistics of remote backends Yes Yes
Can use Independent Index and Table Statistics No Yes
Maintain local or remote table increments Yes Yes
LOAD DATA INFILE translate to bulk inserting Yes Yes
Performance Schema Probes Yes Yes
Load Balance Reads to replicate weight control Yes Yes
Fine tuning tcp timeout, connections retry Yes Yes
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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/spider-feature-matrix/