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;