Federated Tables in MySQL

Nikoms

Member
Nov 29, 2006
19
0
151
Federated table in Mysql

HEllo All!

Does anyone know how to activate Federated table in cpanel?

Thank you very much :)
 
Last edited:

Nikoms

Member
Nov 29, 2006
19
0
151
HEllo All!

Does anyone know how to activate Federated table in cpanel?

Thank you very much
 

Nikoms

Member
Nov 29, 2006
19
0
151
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?
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
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:

Code:
mysql://user:[email protected]: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:

Code:
GRANT SELECT, DELETE, UPDATE on database.table to [email protected] 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

Registered
Nov 19, 2007
1
0
51
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

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
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.