MariaDB starting with 10.0

The CONNECT engine was introduced in MariaDB 10.0.

The CONNECT storage engine is enabled like any other plugin, for instance using the INSTALL SONAME command:

INSTALL SONAME 'ha_connect';

For the INSTALL command to work, the libraries (ha_connect.dll, ha_connect.so, ha_connect.so.0, or ha_connect.so.0.0.0) must be placed in the standard MariaDB plugin directory.

If the package is missing, you get an error such as /usr/lib64/mysql/plugin/ha_connect.so missing. You will have to install the connect package MariaDB-connect-engine, or mariadb-connect-engine-10.0 from the MariaDB repository.

Tracing

When the CONNECT library is loaded, MariaDB has changed the current directory to its data directory. Therefore, if tracing is desired, the connect.ini file, the configuration file used by CONNECT, must be copied to the MariaDB data directory.

The connect.ini file is just used to set the CONNECT trace on or off. For example:

[CONNECT]
Trace=0

Change the 0 to 1 (or 2 for more tracing) if console tracing is desired. Note that to test this handler, MariaDB should be started with the --console parameter because CONNECT prints some error and trace messages on the console[1].


  1. In some Linux versions, this is re-routed into the error.log file.

Comments

Comments loading...