How to check if Federation is enabled

Question

I want to know what the command is that I can run in the shell to find out if Federation is enabled on a MySQL server or not?

Thanks.

Answer 1

Login to mysql server and do SHOW ENGINES\G, this it what it says on one of my mysql servers:

*************************** 10. row ***************************
 Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine

Answer 2

Edit the file /etc/mysql/my.cn At the [mysqld] section add:

[mysqld] federated

Restart MySql Server and it's done!