Deploy MariaDB Enterprise Spider

To deploy the Enterprise Spider storage engine with MariaDB Enterprise Server, choose an Enterprise Spider topology and an ES version:

Topology

Diagram

Features

Federated MariaDB Enterprise Spider
Federated MariaDB Enterprise Spider Topology
  • 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

  • ES 10.3+

Sharded MariaDB Enterprise Spider
Sharded MariaDB Enterprise Spider Topology
  • 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

  • ES 10.3+

ODBC MariaDB Enterprise Spider
ODBC MariaDB Enterprise Spider Topology
  • Read from and write to tables on ODBC Data Sources

  • Spider Node uses Spider storage engine for ODBC Spider Tables

  • ODBC Spider Table is a "virtual" table

  • Spider uses ODBC foreign data wrapper to query ODBC Data Source

  • Supports transactions

  • ES 10.5