Step 3: Test Spider Federated Topology

Overview

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

This step tests MariaDB Enterprise Spider.

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

Test Enterprise Server Service

Use Systemd to test whether the MariaDB Enterprise Server service is running.

This action is performed on the Spider Node and Data Node.

Check if the MariaDB Enterprise Server service is running by executing the following:

If the service is not running on any node, start the service by executing the following on that node:

Test Local Client Connections

Use MariaDB Client to test the local connection to the Enterprise Server node.

This action is performed on the Spider Node and Data Node:

The sudo command is used here to connect to the Enterprise Server node using the root@localhost user account, which authenticates using the unix_socket authentication plugin. Other user accounts can be used by specifying the --user and --password command-line options.

Test Data Node Client Connection

Use to test a client connection to the Data Node from the Spider Node using the Spider user.

This action is performed on the Spider Node:

The host and port of the Data Node can be provided using the --host and --port command-line options. The credentials for the Spider user can be provided using the --user and --password command-line options.

If the Spider user is unable to connect to the Data Node from the Spider Node, check the password for the Spider user account on the Data Node.

For additional information, see "".

Test Spider Storage Engine Plugin

Query the information_schema.PLUGINS table to confirm that the Enterprise Spider storage engine is loaded.

This action is performed on the Spider Node.

Execute the following query:

The PLUGIN_STATUS column for each Spider-related plugin should contain ACTIVE.

For additional information, see "".

Test Write Operations

Write to the Spider Table using an statement to test write operations.

This action is performed on the Spider Node.

Execute the following query:

Test Read Operations

Read from the Spider Table using a statement to test read operations.

This action is performed on the Spider Node.

Execute the following query:

Next Step

Navigation in the procedure "Deploy Spider Federated Topology".

This page was step 3 of 3.

This procedure is complete.