mysqlfederated-storage-engine

How can I enable the federated engine in mysql after installation?

I have mysql 5.1.44:

mysql> show engines;
+------------+---------+
| Engine     | Support | 
+------------+---------+
| ndbcluster | NO      | 
| MRG_MYISAM | YES     | 
| BLACKHOLE  | YES     | 
| CSV        | YES     | 
| MEMORY     | YES     | 
| FEDERATED  | NO      | 
| ARCHIVE    | YES     | 
| InnoDB     | YES     | 
| MyISAM     | DEFAULT |

I need to enable federated engine in mysql. How can I do it?

Solution

  • Edit /etc/my.cnf and in the [mysqld] section, add the line: 

    federated

    It's equivalent to specifying --federated on the command line