YES支持并開啟

DEFAULT支持并開啟, 并且為默認引擎

NO不支持

DISABLED支持,但未開啟

參考一下在windows下的解決辦法，在my.cnf中增加一行

復制代碼 代碼如下:

federated

1. 查看當前支持的存儲引擎

SQL>show engines;

復制代碼 代碼如下:

+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine| Support | Comment| Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| CSV| YES| CSV storage engine| NO| NO | NO|
| MRG_MYISAM | YES| Collection of identical MyISAM tables| NO| NO | NO|
| MEMORY| YES| Hash based, stored in memory, useful for temporary tables | NO| NO | NO|
| InnoDB| DEFAULT | Supports transactions, row-level locking, and foreign keys | YES| YES | YES|
| MyISAM| YES| Default engine as of MySQL 3.23 with great performance| NO| NO | NO|
+------------+---------+------------------------------------------------------------+--------------+------+------------+
5 rows in set (0.00 sec)

2. 安裝federated存儲引擎

由于編譯時沒有選擇federated，所以打算通過INSTALL PLUGIN的方式安裝，正常情況下，federated是支持動態安裝的：
=== Federated Storage Engine ===
Plugin Name:federated
Description:Connects to tables on remote MySQL servers
Supports build: static and dynamic
Configurations: max, max-no-ndb

可是執行以下命令時報錯：

SQL>install plugin federated soname 'ha_federated.so';
ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_federated.so' (errno: 2 undefined symbol: dynstr_append_mem)
搜了一下，發現是個老問題，竟然到現在都沒解決，可見MySQL團隊的效率和管理的混亂。?id=40942
沒有辦法了，只有重新編譯MySQL源碼了, 加上--with-plugins=federated。從5.1.26開始，默認MySQL不啟用federated存儲引擎，所以需要在my.cnf中加入federated選項或是在命令行用--federated選項啟動mysqld。編譯后的結果如下：

SQL>show engines;

復制代碼 代碼如下:

+------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine| Support | Comment| Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| CSV| YES| CSV storage engine| NO| NO | NO|
| MRG_MYISAM | YES| Collection of identical MyISAM tables| NO| NO | NO|
| FEDERATED | YES| Federated MySQL storage engine| NO| NO | NO|
| MyISAM| YES| Default engine as of MySQL 3.23 with great performance| NO| NO | NO|
| InnoDB| DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES| YES | YES|
| MEMORY| YES| Hash based, stored in memory, useful for temporary tables| NO| NO | NO|
+------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)