开发者

How to check if Federation is enabled

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!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜