Step 5: Start and Configure MariaDB Enterprise Server

Overview

This page details step 5 of the 9-step procedure "Deploy Xpand Storage Engine Topology".

This step starts and configures MariaDB Enterprise Server 10.5.

Several actions require connection to MariaDB Enterprise Server. A command-line client (mariadb) was included with your ES installation. These instructions describe connection via Unix domain socket. Alternatively, a different client and connection method could be used.

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

Configure Enterprise Server

MariaDB Enterprise Server 10.5 connects to MariaDB Xpand 5.3 through the Xpand storage engine plugin. You must configure Enterprise Server to load the storage engine plugin and configure the plugin to connect to the Xpand nodes.

Required Configuration

Enterprise Server nodes that connect to Xpand require that you set the following system variables and options:

System Variable/Option

Description

plugin_load_add

Set this to ha_xpand.so to load the Xpand storage engine

xpand_hosts

Set this to the IP addresses of the Xpand nodes.

xpand_password

Set this to the password of user configured on the Xpand node.

xpand_port

Set this to the port used by the Xpand nodes.

xpand_username

Set this to the user configured on the Xpand node.

Example Configuration

On each Enterprise Server node, edit a configuration file and set these system variables and options:

[mariadb]
plugin_load_add = ha_xpand.so
xpand_hosts     = 192.0.2.1
xpand_username  = xpand
xpand_password  = xpand_passwd
xpand_port      = 3306

Start Enterprise Server

On each Enterprise Server node, start the Enterprise Server process:

$ sudo systemctl start mariadb

Configure MariaDB Replication

Enterprise Server nodes access data from Xpand nodes using the Xpand storage engine. To see the tables on the Xpand nodes, each Enterprise Server must have the same database objects as the Xpand node.

Access to the tables created in Step 3 requires that you execute a CREATE DATABASE statement for the test database. MariaDB Replication can be used to synchronize databases and other objects. Without replication, the database needs to be created separately on each ES node.

MaxScale Database User

MaxScale requires a database user account to manage and monitor Enterprise Server.

This action is performed on each Enterprise Server node.

  1. Connect to the Enterprise Server node:

    $ sudo mariadb
    
  2. Use the CREATE USER statement to create a user account for MaxScale:

    CREATE USER maxscale@192.0.2.20 IDENTIFIED BY 'maxscale_passwd';
    
  3. Use the GRANT statement to grant the required privileges for the MaxScale user:

    GRANT SHOW DATABASES ON *.* TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.columns_priv TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.db TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.procs_priv TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.proxies_priv TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.roles_mapping TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.tables_priv TO maxscale@192.0.2.20;
    GRANT SELECT ON mysql.user TO maxscale@192.0.2.20;
    

Next Step

Navigation in the procedure "Deploy Xpand Storage Engine Topology":

  • This page was step 5 of 9.