The Ultimate Guide to High Availability with MariaDB

Loading the CONNECT Storage Engine

You are viewing an old version of this article. View the current version here.
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.[so|dll]';

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, which is automatically done when using the standard install commands.

In some environments, you may get an error about a missing library, libodbc:

INSTALL SONAME 'ha_connect';
ERROR 1126 (HY000): Can't open shared library '/home/ian/MariaDB_Downloads/10.1.17/lib/plugin/ha_connect.so' 
  (errno: 2, libodbc.so.1: cannot open shared object file: No such file or directory)

In this case, just install the missing library, for example:

sudo apt-get install libodbc1

See also

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.