I upgraded from MySQL 5.1 to MariaDB 5.3 and then to 5.5 on a Windows machine. Everything works well, except I can't enable the federated storage engine. With MySQL 5.1 and MariaDB 5.3, I just added "federated" under [mysqld]. If I try to start MariaDB 5.5 with the same "federated" option, I get an error:

C:\Program Files\MariaDB 5.5\bin\mysqld.exe: unknown option '--federated'

How can I enable the federated storage engine?


FederatedX is enabled by default in MariaDB 5.5

  • show engines doesn't list it, and I get an error when trying to created a federated table "Unknown storage engine".
    – Amit E
    Oct 22 '13 at 12:15

Finally found the answer in a StackOverflow question. I missed one command that I didn't see documented anywhere:

install plugin federated soname 'ha_federated.so'

Just had to change ha_federated.so to ha_federatedx and run in a client and it works!

  • thanks, as the old federated (ha_federated) is also working but slowly.
    – Moshe L
    Feb 18 '20 at 14:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.