Installing upgrading on Centos 5 for FEDERATED tables.

[richard parris]

I am wondering if anyone can help me here. I am going around in circles and fear I am missing something fundamental.

I am running two Centos 5 virtual machines in Japan and China running MySQL (mysql-server-5.0.68-1.el4_6). I am wanting to use Federated tables to enable reporting across all of our data.

On both servers 'SHOW ENGINES;' yields:

mysql> SHOW ENGINES;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | YES | Supports transactions and page-level locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | NO | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)


I have been trying to enable the federated engine for several days now. My approaches have included:

Adding a single line: 'federated' to the [mysqld] section of /etc/my.cnf
This resulted in a logged error stating 'federated' is an unknown variable.

Adding a single line: 'federated=yes' to the [mysqld] section of /etc/my.cnf
This resulted in a logged error stating 'federated=yes' is an unknown variable.

I have attempted to install the MySQL-Max rpm supplied at dev.mysql.com with the following error:

# rpm -Uvh MySQL-Max-5.0.24-0.glibc23.i386.rpm
error: Failed dependencies:
MySQL-server >= 5.0 is needed by MySQL-Max-5.0.24-0.glibc23.i386

Despite "# rpm -qa | grep -i mysql" returning:

mysql-server-5.0.45-7.el5
perl-DBD-MySQL-3.0007-1.fc6
mysql-devel-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
mysql-5.0.45-7.el5

My conclusion so far is that the binaries I am running do not have the Federated engine compiled in. Is there a managed method for gaining the Federated Engine's functionality? I could compile from source with the relevant flags but this will involve doing so again for every upgrade/update.

From the poorcity of the documentation on this subject, the fact that Federated support is no longer compiled in by default and the lack of availability of pre-compiled binaries, i get the feeling that this Functionality is if not just unsupported, possibly being phased out. This leaves me wondering whether some other method of replicating the data between sites for reporting purposes would be more sensible as I am not yet tied into anything specific.

Has anyone solved the this problem?

Thanks,

richard