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