Enable FEDERATED ENGINE error

Asked May 12 '14 at 17:09

Active May 12 '14 at 17:09

Viewed 1,045 times

I need to enable FEDERATED ENGINE on Mysql (MySQL version: 5.5.35)

I set in /etc/my.cnf file line federated.

Restart my mysql server, then check in mysql using command SHOW ENGINES, and result is:

FEDERATED   NO  Federated MySQL storage engine  NULL    NULL    NULL

Also I tried to instal plugin federated , but the result is:

mysql> install plugin federated soname 'ha_federated.so';
ERROR 1125 (HY000): Function 'federated' already exists

I read this. But with no luck.

FEDERATED still not supported. any Advices?

edited May 23 '17 at 12:27

Community

asked May 12 '14 at 17:09

sergio

Is your MySQL built with federated support enabled? (`-DWITH_FEDERATED_STORAGE_ENGINE`). – Wrikken May 12 '14 at 17:41
Did you put `federated` in the `[mysqld]` section of my.cnf? – Michael - sqlbot May 13 '14 at 01:22
@Wrikken, where can I check this or change value(from 0 to 1)? – sergio May 13 '14 at 07:23
@Michael, you was right!!I didn't put federated in the [mysqld] section!!)Great!now it works!!You can make an answer and I will accept it! – sergio May 13 '14 at 08:16

0 Answers0