I want to know what the command is that I can run in the sh开发者_开发百科ell to find out if Federation is enabled on a MySQL server or not?
Thanks.
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
Edit the file /etc/mysql/my.cn At the [mysqld] section add:
[mysqld] federated
Restart MySql Server and it's done!
精彩评论