Bug #82959 Remove FEDERATED storage engine

• Submitted: 12 Sep 2016 19:26
• Modified: 13 Sep 2016 0:02
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Federated storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.0
• OS: Any
• CPU Architecture: Any

[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] MySQL Verification Team

Thank you for the bug report.