MySQL安装Federated引擎

Beginning with MySQL 5.0.64, the FEDERATED storage engine is not enabled by default in the running server; to enable FEDERATED, you must start the MySQL server binary using the --federated option.

从mysql官方文档可以看出, 从5.0.64以后Federated存储引擎默认不开启, 但我们需要使用的时候, 需要手动开启

mysql> show engines;

可以看出 FEDERATED 的 Support 为 NO

解决办法

安装

mysql> install plugin federated soname 'ha_federated.so';

配置文件开启

vi /etc/my.cnf

#*******************************************************#
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
federated  # 指定开启

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#*******************************************************#

或者启动时指定

mysqld --federated

重启服务

service mysqld restart

重新再查看

mysql> show engines;