Enable Federated Engine on Mysql 5

[rmarinho]

Hi,

I've Plesk 8.2.1, and I need to enable federated engine option on mysql.

Does anyone have done this without corrupt plesk install?

Thank's,

 

[ib1984]

never tried this, but judging by the list of engine's limitations (here) a lot of index options which are native for InnoDB (and required by Plesk) are not supported. Also, 'ALTER TABLE' is not supported, thus upgrades won't work.
It's up to you to decide, but I wouldn't risk that much.

 

[quatre]

Hello.
I need this feature too.
How can I enable it?

Thanks.

 

[rmarinho]

Well, this is a tricky deal, and is only available on mysql 5.

1) Backup all data (Most important step.);

2) Login via ssh to your server and:
2.1: Check your mysql version

2.2ownload from:
http://dev.mysql.com/downloads/mysql/5.0.html#linux-icc
Version must be: Linux (non RPM, Intel C/C++ compiled, glibc-2.3)

2.3:Extract your download and move it to your preferred destination

3) After just go to directory you have created and then:
service mysqld stop
./bin/mysqld_safe &
after this:
mysql -u admin -p
and then type SHOW ENGINES\G see it field support on federated engine look like Support: YES

You must also create start and shutdown script.

And that's all.

Enjoy it.