MariaDB Enterprise Spider Topologies

MariaDB Enterprise Spider supports multiple topologies. Several options are described below. MariaDB Enterprise Spider can be deployed in other topologies. The topologies on this page are representative of basic product capabilities.

For additional information, choose an Enterprise Spider topology:

Topology

Diagram

Use Cases

Federated MariaDB Enterprise Spider

Federated MariaDB Enterprise Spider Topology
  • Read from and write to tables on remote ES nodes

  • Migrate tables from remote ES node

  • Query tables on remote ES node

  • JOIN local tables with tables on remote ES node

  • ES 10.3+

Sharded MariaDB Enterprise Spider

Sharded MariaDB Enterprise Spider MariaDB Topology
  • Shard tables for horizontal scalability

  • Consolidate tables from remote ES nodes into one "virtual" table

  • Partition a large table across multiple remote ES nodes

  • Use regular partitioning syntax to define shards

  • ES 10.3+

ODBC MariaDB Enterprise Spider

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

  • Migrate data from an ODBC Data Source

  • Query data from an ODBC Data Source

  • JOIN local tables with data from an ODBC Data Source

  • ES 10.5+