开发者

How to check if Federation is enabled

开发者 https://www.devze.com 2023-02-12 01:40 出处:网络
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?

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

精彩评论

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