UNKNOWN STORAGE ENGINE ‘FEDERATED’

You may receive the following error with MariaDB on a Windows platform when attempting to create a table using the federatedx engine.

1 queries executed, 0 success, 1 ERRORS, 0 WARNINGS

QUERY: CREATE TABLE t1 ENGINE=FEDERATED CONNECTION="server"

Error CODE: 1286
UNKNOWN STORAGE ENGINE 'FEDERATED'

Execution TIME : 0 sec
Transfer TIME  : 0 sec
Total TIME     : 0 sec

The federatedx engine does not seem to be enabled by default (10.0.14 on Windows). To sort this out simply run…

INSTALL SONAME 'ha_federatedx.dll';

The output of SHOW PLUGINS should now display this…

Name                         Status    Type                Library            License  
FEDERATED                    ACTIVE    STORAGE ENGINE      ha_federatedx.dll  GPL      

Leave a Reply