Step 1: Install Enterprise Spider

Overview

This page details step 1 of the 3-step procedure "Deploy Spider Sharded Topology".

This step installs the Enterprise Spider storage engine plugin on the Spider Node.

Interactive commands are detailed. Alternatively, the described operations can be performed using automation.

Allow Interconnect

MariaDB Enterprise Spider depends on interconnect between the Spider Node and all Data Nodes. This may require adjustment to firewall and security settings.

Install via APT (Debian/Ubuntu)

On Debian and Ubuntu, the Enterprise Spider storage engine is not installed with MariaDB Enterprise Server 10.3 by default. An additional package must be installed.

On other operating systems, the Enterprise Spider storage engine is installed with MariaDB Enterprise Server 10.3 by default.

On the Spider Node, install MariaDB Enterprise Spider:

$ sudo apt install mariadb-plugin-spider

Load the Spider Plugin

The Enterprise Spider storage engine plugin must be loaded by MariaDB Enterprise Server 10.3.

MariaDB Enterprise Server 10.3 includes the install_spider.sql script. The install_spider.sql script configures MariaDB Enterprise Server 10.3 to load the Enterprise Spider storage engine plugin.

On the Spider Node, use MariaDB Client to run the install_spider.sql script:

$ mysql --user root --password < /usr/share/mysql/install_spider.sql

Test Plugin Installation

On the Spider Node, confirm that the Enterprise Spider storage engine plugin is loaded by querying the information_schema.PLUGINS table:

SELECT PLUGIN_NAME, PLUGIN_STATUS
FROM information_schema.PLUGINS
WHERE PLUGIN_LIBRARY LIKE "ha_spider%";
+--------------------------+---------------+
| PLUGIN_NAME              | PLUGIN_STATUS |
+--------------------------+---------------+
| SPIDER                   | ACTIVE        |
| SPIDER_ALLOC_MEM         | ACTIVE        |
| SPIDER_WRAPPER_PROTOCOLS | ACTIVE        |
+--------------------------+---------------+

When the Enterprise Spider storage engine is loaded, the PLUGIN_NAME column contains the value SPIDER and the PLUGIN_STATUS column contains the value ACTIVE.

Next Step

Navigation in the procedure "Deploy Spider Sharded Topology":

  • This page was step 1 of 3.