Bug #37069 Make federated disabled by default
Submitted: 29 May 2008 12:35 Modified: 12 Jul 2008 18:44
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S4 (Feature request)
Version:5.0, 5.1, 6.0 OS:Any
Assigned to: Georgi Kodinov CPU Architecture:Any

[29 May 2008 12:35] Georgi Kodinov
Description:
Currently the federated engine is loaded when the server is started.
It can be disabled on startup with the --skip-federated server command line option.
I would like to have it not loaded by default. 
In this case it can be re-enabled at startup by the --federated server command line option.

How to repeat:
make sure federated is compiled.
start the server.
make sure federated is available (but it should not be) in INFORMATION_SCHEMA.engines if it's compiled in.

Suggested fix:
Change the server code so that federated is not activated by default (even if the storage engine is compiled in) unless specifically enabled with the --federated server command line option.
[30 May 2008 10:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47248

2654 Georgi Kodinov	2008-05-30
      Bug#37069: Make federated disabled by default
      
      The federated storage engine is now disabled by default.
      mysql-test-run.pl is updated to enable it whenever it's required and available.
[30 May 2008 12:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47254

2654 Georgi Kodinov	2008-05-30
      Bug#37069: Make federated disabled by default
      
      The federated storage engine is now disabled by default.
      mysql-test-run.pl is updated to enable it whenever it's required and available.
[3 Jun 2008 10:12] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47345

2633 Georgi Kodinov	2008-06-03
      Bug#37069 (5.0): implement --skip-federated
[3 Jun 2008 13:14] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47365

2633 Georgi Kodinov	2008-06-03
      Bug#37069 (5.0): implement --skip-federated
[12 Jun 2008 16:52] Paul DuBois
Noted in 5.0.64, 5.1.26 changelogs.

The FEDERATED storage engine now is disabled by default in binary
distributions. The engine is still available and can be enabled by
starting the server with the --federated option.

Setting report to Need Doc Info pending push of fix into 6.0.x.
[17 Jun 2008 8:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/47962

2638 Tatiana A. Nurnberg	2008-06-17 [merge]
      merge
[18 Jun 2008 16:56] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/48110
[18 Jun 2008 16:57] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/48111
[2 Jul 2008 8:38] Georgi Kodinov
Pushed in 6.0.6
[12 Jul 2008 18:44] Paul DuBois
Noted in 6.0.6 changelog.
[17 Jul 2008 14:34] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49933

2644 Georgi Kodinov	2008-07-17
      Folow-up on Bug#37069: fix a valgrind warning
      Don't initalize federated if it's disabled by a command line option.
[22 Jul 2008 18:34] Bugs System
Pushed into 5.0.68
[28 Jul 2008 13:45] Bugs System
Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080721102431-z5e57evh2lrdqaj8) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)
[28 Jul 2008 14:45] Bugs System
Pushed into 6.0.7-alpha  (revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (version source revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (pib:3)
[28 Jul 2008 16:45] Bugs System
Pushed into 5.1.28  (revid:davi.arnaut@sun.com-20080722182431-0i2f1yc4uocime9q) (version source revid:davi.arnaut@sun.com-20080722182431-0i2f1yc4uocime9q) (pib:3)
[1 Aug 2008 16:31] Paul DuBois
Correction: See Bug#38483: FEDERATED was not disabled in the server itself in 5.0; it's set to disabled only in the my.cnf files shipped with distributions.
[1 Aug 2008 16:35] Paul DuBois
Noted in 5.0.64 changelog.

The FEDERATED storage engine is now disabled by default in the .cnf
files shipped with MySQL distributions (my-huge.cnf, my-medium.cnf,
and so forth). This affects server behavior only if you install one
of these files.
[13 Sep 2008 23:49] Bugs System
Pushed into 6.0.7-alpha  (revid:kgeorge@mysql.com-20080717143341-h2sjuze0ks45e0qs) (version source revid:timothy.smith@sun.com-20080813063149-5o63l7vlvbm6nuhm) (pib:3)