Federated Tables in MySQL

[Nikoms]

HEllo All!

Does anyone know how to activate Federated table in cpanel?

Thank you very much

[Nikoms]

HEllo All!

Does anyone know how to activate Federated table in cpanel?

Thank you very much

[cpanelkenneth]

http://dev.mysql.com/doc/refman/5.0/...rated-use.html

[Nikoms]

Thanks,

But I can't create table in federated because, it's not activated....

So is there a checkbox or something where I can activate federated table?

[Nikoms]

up

nobody?

[cPanelDavidG]

**Merged Duplicated Thread**

[cpanelkenneth]

Using the cPanel provided RPMs and making certain that both servers are using MySQL 5, the example tables in the MySQL documentation worked. THe only variance needed was when defining the DSN I also needed to provide the password, so my DSN was in the format:

mysql://user:password@host:port/db/table

Some things to consider when troubleshooting:

1. The user specified in the DSN needs remote access to the remote MySQL instance. This means on the remote server, where the database table used by the federated is actually stored, a GRANT similar to the following needs performed:

GRANT SELECT, DELETE, UPDATE on database.table to user@host identified by 'password';

2. MySQL on the remote system needs to be listening to a TCP port. This may be disabled in your /etc/my.cnf file.

3. The MySQL TCP must not be firewalled (or at least allow connections from the other MySQL server).

4. Both servers must be using MySQL 5.0

5. The actual table must exist first on the remote MySQL server.

Installs on FreeBSD may differ.

If you still encounter difficulties, please post the actual error messages reported by MySQL.

[Idaf_1er]

I reply for Nikoms we work on the same server.
The problem, he don't come from the creation of the table.

But from the mysql server configuration.

This is the result "show engines;" :

'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', 'NO', 'Supports transactions and page-level locking'
'BLACKHOLE', 'NO', '/dev/null storage engine (anything you write to it disappears)'
'EXAMPLE', 'NO', 'Example storage engine'
'ARCHIVE', 'YES', 'Archive storage engine'
'CSV', 'NO', 'CSV storage engine'
'ndbcluster', 'NO', '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'


We use : WHM 11.11.0 cPanel 11.15.0-R17981
On : FEDORA 4 i686 on standard - WHM X v3.1.0

[cpanelkenneth]

I reply for Nikoms we work on the same server.
The problem, he don't come from the creation of the table.

But from the mysql server configuration.

This is the result "show engines;" :

'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', 'NO', 'Supports transactions and page-level locking'
'BLACKHOLE', 'NO', '/dev/null storage engine (anything you write to it disappears)'
'EXAMPLE', 'NO', 'Example storage engine'
'ARCHIVE', 'YES', 'Archive storage engine'
'CSV', 'NO', 'CSV storage engine'
'ndbcluster', 'NO', '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'


We use : WHM 11.11.0 cPanel 11.15.0-R17981
On : FEDORA 4 i686 on standard - WHM X v3.1.0

Thanks for the added info. Apparently support for Federated tables is not enabled in the MySQL RPMs provided for the Release branch - verified on two separate servers. The tests I performed earlier were on the Current branch, which has different RPMs.