Installing the CONNECT storage engine

The CONNECT storage engine is not installed by default. So, the first thing that we have to do is to install and enable it.

How to do it...

1. On Fedora, CentOS, or Red Hat systems, we can run the following command line:

   sudo yum install MariaDB-connect-engine
   

   On Debian, Ubuntu, or Linux Mint systems, we can run the following command line:

   sudo apt-get install mariadb-connect-engine-10.0
   

2. On all systems, launch the mysql command-line client and connect it to our MariaDB server with a user that has the SUPER privilege.

3. Enable the CONNECT storage engine by running the following command line:

   INSTALL SONAME 'ha_connect'; 
   

4. Verify the installation by running the following two commands and look for CONNECT in the output:

   SHOW ENGINES;
   SHOW PLUGINS;
   

How it works...

On Windows and MacOS, the CONNECT storage engine is included but not active. On Linux, we need to install the CONNECT package before we can enable it using the mysql command-line client.

See also

• The full...