The Ultimate Guide to High Availability with MariaDB

Loading the CONNECT handler

You are viewing an old version of this article. View the current version here.

The CONNECT handler must be enabled like any other plugin, for instance using the INSTALL PLUGIN command:

INSTALL PLUGIN CONNECT SONAME 'ha_connect';

In case you get an error "/usr/lib64/mysql/plugin/ha_connect.so missing" , you probably have to install the connect package MariaDB-connect-engine from the MariaDB repository

To be visible the ha_connect.dll or ha_connect.so, ha_connect.so.0, ha_connect.so.0.0.0 libraries must be placed in the standard MariaDB plugin directory, which is automatically done when using the standard INSTALL commands. However, a few additional requirements must be fulfilled. 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 in the MariaDB data directory. Currently, the connect.ini file is just used to set the CONNECT trace on or off and could be:

[CONNECT]
Trace=0

Change 0 to 1 or 2 (more trace) if a console tracing is desired. Note that to test this handler, MariaDB should be executed with the --console parameter because CONNECT prints some error and trace messages on the console. In some Linux versions, this is re-routed into the error.log file.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.