[OS12.1] how to enable mysql federated engine

English Applications
#1

Hi,

How do I enable mysql federated engine in opensuse 12.1. . when I check using show engines , federated engine is not list in it but I check the plugins.cnf show load federated.so

I tried add federated in my.cnf but getting error unknown option ‘–federated’ .

what should I do ? , do I have to recompile sources in order to enable it ? :’(

#2

Never mind, I found the solution.

first
mysql> install plugin federated soname ‘ha_federated.so’;

then add federated in my.cnf

it work!!!rotfl!