How to enable the Federated/FederatedX storage engine on MariaDB 5.5?

Question

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?

score 2 · Accepted Answer · edited May 23 '17 at 12:40

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!

edited May 23 '17 at 12:40

Community

1

answered Oct 27 '13 at 07:15

LoremFooBar

21
1
3

score 1 · Answer 2 · answered Oct 21 '13 at 15:12

1

FederatedX is enabled by default in MariaDB 5.5

answered Oct 21 '13 at 15:12

Ian Gilfillan

156
3

How to enable the Federated/FederatedX storage engine on MariaDB 5.5?

2 Answers2

Linked