How to Add Federated engine after installing Mysql

Question

I have Mysql 5.5.18
and upon show engines:

show engines;
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                         | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                         | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                      | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+

as you see federated engine is not one of the list. i need to enable it!! any idea of why BLACKHOLE, FEDERATED, and ARCHIVE engines are missing from the list? and how can i add/enable them?
EDIT
I have ubuntu 11.10 and installed mysql from ppa ... i have added the following to /etc/apt/sources.list

deb http://ppa.launchpad.net/nathan-renniewaldock/ppa/ubuntu oneiric main
deb-src http://ppa.launchpad.net/nathan-renniewaldock/ppa/ubuntu oneiric main

Thanks for your help

Answer 1

If Default installation/binary installation

In My opinion the BLACKHOLE , ARCHIVE are installed and enabled by default when you install the Mysql server.

but the FEDERATED is not enabled by default.For that do like this

You can enable it manually you have edit your my.cnf file.edit my.cnf and in the [mysqld] section, add the line:

federated

Now restart the Mysql server.

For adding Archive go to link http://timanovsky.wordpress.com/2010/10/09/enabling-archive-storage-engine-in-ius-mysql-5-1/

If you have installed from source then you was supposed to do like this:

For Blackhole: invoke configure with the --with-blackhole-storage-engine option.

For Archieve: invoke configure with the --with-archive-storage-engine option

For Federated: invoke configure with the --with-federated-storage-engine option

Answer 2

I have managed to find a solution...
there is a plugin already available at
/usr/lib/mysql/plugin/ha_federated.so
i just logged in to mysql as root and run the following query mysql>install plugin federated soname 'ha_federated.so';
then i added federated to my.cnf and restarted mysql

Answer 3

On ML with the MySQL 5.5 (current) all I needed to do was:

• Copy one of the existing files from /usr/local/mysql/support-files/ to /etc/my.cnf
• Add 'federated'(without quotes) to the [mysqld] section (not the end of the my.cnf file)
• Restart MySQL

This might also be useful for those that want an automated way to declare tables: http://sylnsr.blogspot.com/2012/11/auto-constructing-ddl-for-mysql.html