Spider Storage Engine
Spider Topologies
Spider Federated
MariaDB Enterprise Spider enables reading from and writing to tables on remote Enterprise Server nodes. It uses the Spider storage engine for "virtual" Federated Spider Tables, querying Data Tables on Data Nodes (which use non-Spider engines) via a MariaDB foreign data wrapper. This solution supports transactions and is available with Enterprise Server 10.3+.
Read from and write to tables on remote ES nodes
Spider Node uses Spider storage engine for Federated Spider Tables
Federated Spider Table is a "virtual" table
Spider uses MariaDB foreign data wrapper to query Data Table on Data Node
Data Node uses non-Spider storage engine for Data Tables
Supports transactions
Enterprise Server 10.3+, Enterprise Spider
Spider Sharded
MariaDB Enterprise Spider facilitates horizontal scalability by sharding tables. It uses the Spider storage engine for partitioned "virtual" Sharded Spider Tables, querying Data Tables on Data Nodes (using non-Spider engines) for each partition via a MariaDB foreign data wrapper. This solution supports transactions and is available with Enterprise Server 10.3+.
Shard tables for horizontal scalability
Spider Node uses Spider storage engine for Sharded Spider Tables
Sharded Spider Table is a partitioned "virtual" table
Spider uses MariaDB foreign data wrapper to query Data Tables on Data Nodes for each partition
Data Node uses non-Spider storage engine for Data Tables
Supports transactions
Enterprise Server 10.3+, Enterprise Spider
empty para
Last updated
Was this helpful?