Prompt for MySQL Federated

The following prompt message is displayed in the MySQL Log file, which is related to the federated engine. This option is added during compilation but is not enabled in the configuration file, for more information about the federated engine, see the official MySQL reference documentation.

Http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html#federated-storage-engine

[Root @ 170_ddb ~] # Grep-I fed/home/MySQL/data/10_ccs.err

1. 120814 13:50:42 [note] plugin 'federated 'is disabled.
2. 120814 13:53:49 [note] plugin 'federated 'is disabled.
3. 120814 14:42:52 [note] plugin 'federated 'is disabled.

At the same time, running show engines in MySQL displays the following information:

2. MySQL>Show engines;
4. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
6. | Engine | Support | comment | transactions | XA | savepoints |
8. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
10. | CSV | Yes | CSV storage engine | no |
12. | Mrg_myisam | Yes | collection of identical MyISAM tables | no |
14. | Federated | no | federated MySQL storage engine | null |
16. | MyISAM | Yes | default engine as of MySQL 3.23 With great performance | no |
18. | InnoDB | default | supports transactions, row-level locking, and foreign keys | Yes |
20. | Memory | Yes | hash based, stored in memory, useful for temporary tables | no |
22. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
24. 6 rows in SET (0.01 Sec)

Add the following options to the MySQL STARTUP configuration file:

 

[Root @ 170_ddb ~] # Vim/usr/local/mysql5/etc/InnoDB. CNF
1. [Mysqld]
2. Federated

Restart MySQL and view logs again. The prompt is no longer displayed.

Run show engines again to display the following information:

 

2. MySQL>Show engines;
4. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
6. | Engine | Support | comment | transactions | XA | savepoints |
8. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
10. | CSV | Yes | CSV storage engine | no |
12. | Mrg_myisam | Yes | collection of identical MyISAM tables | no |
14. | Federated | Yes | federated MySQL storage engine | no |
16. | MyISAM | Yes | default engine as of MySQL 3.23 With great performance | no |
18. | InnoDB | default | supports transactions, row-level locking, and foreign keys | Yes |
20. | Memory | Yes | hash based, stored in memory, useful for temporary tables | no |
22. + ------------ + --------- + ---------------------------------------------------------- + -------------- + ------ + ------------ +
24. 6 rows in SET (0.00 Sec)

From the above information, we can see that Federated is supported.

This article from the "open source one member" blog, please be sure to keep this source http://521cto.blog.51cto.com/950229/963627