0

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?

2

2 Answers 2

2

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!

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

FederatedX is enabled by default in MariaDB 5.5

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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