Deploy Federated MariaDB Enterprise Spider Topology on ES 10.4

This procedure describes how to deploy the Federated MariaDB Enterprise Spider topology with MariaDB Enterprise Server 10.4. The procedure incrementally deploys MariaDB Enterprise Spider on an existing MariaDB Enterprise Server 10.4 deployment.

In the Federated MariaDB Enterprise Spider topology, a Spider Node contains one or more "virtual" Spider Tables. A Spider Table does not store data. When a Spider Table is queried, the Enterprise Spider storage engine uses a MariaDB foreign data wrapper to read from and write to a Data Table on a Data Node.

This procedure has 3 steps, which are executed in sequence.

This page provides an overview of the topology, requirements, and deployment procedure.

The topology described is representative of basic product capabilities. MariaDB products can be deployed to form other topologies, leverage advanced product capabilities, or combine the capabilities of multiple topologies.

Prerequisites

  • MariaDB Enterprise Server 10.4 must be deployed on the Spider Node. If ES has not yet been deployed on the Spider Node, see "Deploy" for instructions.

  • MariaDB Enterprise Server must be deployed on the Data Node. If ES has not yet been deployed on the Data Node, see "Deploy" for instructions.

Support

Production customers can obtain support by submitting a support case.

Components

The following MariaDB Enterprise components are used by this topology:

Component

Function

MariaDB Enterprise Server

Modern SQL database.

MariaDB Enterprise Spider

Storage engine used by Spider Tables to read from and write to Data Tables using the MariaDB foreign data wrapper.

Term Definitions

Term

Definition

Data Node

A Data Node is a MariaDB Enterprise Server node that contains one or more Data Tables.

Data Table

A Data Table stores data for a Spider Table. When a Spider Table is queried, the Enterprise Spider storage engine uses the MariaDB foreign data wrapper to read from and write to the Data Table on a Data Node. The Data Table must be created on the Data Node with the same structure as the Spider Table. The Data Table must use a non-Spider storage engine, such as InnoDB or ColumnStore.

ODBC Data Source

An ODBC Data Source relies on an ODBC Driver and an ODBC Driver Manager to query an external data source.

ODBC Driver

An ODBC Driver is a library that integrates with a ODBC Driver Manager to query an external data source.

ODBC Driver Manager

An ODBC Driver Manager allows applications to use ODBC Drivers.

Spider Node

A Spider Node is a MariaDB Enterprise Server node that contains one or more Spider Tables.

Spider Table

A Spider Table is a virtual table that does not store data. When a Spider Table is queried, the Enterprise Spider storage engine uses foreign data wrappers to read from and write to Data Tables on Data Nodes or ODBC Data Sources.

Topology

Federated MariaDB Enterprise Spider Topology

In the Federated MariaDB Enterprise Spider topology, a Spider Node contains one or more "virtual" Spider Tables. A Spider Table does not store data. When a Spider Table is queried, the Enterprise Spider storage engine uses a MariaDB foreign data wrapper to read from and write to a Data Table on a Data Node.

The Federated MariaDB Enterprise Spider topology consists of:

  • One MariaDB Enterprise Server node is a Spider Node

  • One MariaDB Enterprise Server node is a Data Node

The Spider Node:

  • Contains one or more Spider Tables

  • Uses the Enterprise Spider storage engine plugin for Spider Tables

  • Uses a MariaDB foreign data wrapper to query the Data Table on the Data Node

The Data Node:

  • Contains a Data Table for each Spider Table

  • Uses a non-Spider storage engine for each Data Table, such as InnoDB or ColumnStore

For additional information, see "Federated MariaDB Enterprise Spider Topology".

Requirements

Node Count

  • One or more MariaDB Enterprise Server nodes must be deployed as Spider Nodes. The Spider Nodes contain Spider Tables.

  • One or more MariaDB Enterprise Server nodes must be deployed as Data Nodes. The Data Nodes contain Data Tables.

Operating Systems

MariaDB Enterprise Spider is available on select platforms:

  • CentOS 8

  • CentOS 7

  • Debian 10

  • Debian 9

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 7

  • SUSE Linux Enterprise Server 15

  • SUSE Linux Enterprise Server 12

  • Ubuntu 20.04

  • Ubuntu 18.04