Bug #82959 Remove FEDERATED storage engine
Submitted: 12 Sep 2016 19:26 Modified: 13 Sep 2016 0:02
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:8.0.0 OS:Any
Assigned to:

[12 Sep 2016 19:26] Daniël van Eeden
Description:
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html

On https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html there is a list of reasons why the federated engine is not so great.

The third-party federatedx engine is more advanced, but also not great.
https://launchpad.net/federatedx

Federated has a lot of bugs and missing features.

How to repeat:
Use the federated storage engine in a serious production setup.

Suggested fix:
Remove or deprecate the federated storage engine

- OR -

Implement it properly based on the SQL/MED standard. And make sure it can use transactions, X Protocol, etc.
https://en.wikipedia.org/wiki/SQL/MED
[13 Sep 2016 0:02] Miguel Solorzano
Thank you for the bug report.