Step 1: Install Enterprise Spider
This page details step 1 of the 3-step procedure "Deploy Spider Federated 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.
MariaDB Enterprise Spider depends on interconnect between the Spider Node and the Data Node. This may require adjustment to firewall and security settings.
Install on Debian/Ubuntu (APT)
On Debian and Ubuntu, the Enterprise Spider storage engine is not installed with MariaDB Enterprise Server 10.4 by default. An additional package must be installed.
On other operating systems, the Enterprise Spider storage engine is installed with MariaDB Enterprise Server 10.4 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.4.
On the Spider Node, use one of the following methods to configure MariaDB Enterprise Server 10.4 to load the Enterprise Spider storage engine plugin:
Load Spider with Configuration File
Choose a configuration file for custom changes to system variables and options.
It is not recommended to make custom changes to Enterprise Server's default configuration files, because your custom changes can be overwritten by other default configuration files that are loaded after.
Ensure that your custom changes will be read last by creating a custom configuration file in one of the included directories. Configuration files in included directories are read in alphabetical order. Ensure that your custom configuration file is read last by using the
z-prefix in the file name.
Some example configuration file paths for different distributions are shown in the following table:
Example configuration file pathCentOSRHELSLES
Load Spider with INSTALL SONAME
The INSTALL SONAME statement adds the Enterprise Spider storage engine to the mysql.plugin system table. When the Spider Node is restarted, MariaDB Enterprise Server reads the system table and reloads the plugin, so the statement only needs to be executed once.
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 | +--------------------------+---------------+