The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Federated Tables in MySQL

Discussion in 'General Discussion' started by Nikoms, Nov 5, 2007.

  1. Nikoms

    Nikoms Member

    Joined:
    Nov 29, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Federated table in Mysql

    HEllo All!

    Does anyone know how to activate Federated table in cpanel?

    Thank you very much :)
     
    #1 Nikoms, Nov 5, 2007
    Last edited: Nov 5, 2007
  2. Nikoms

    Nikoms Member

    Joined:
    Nov 29, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    HEllo All!

    Does anyone know how to activate Federated table in cpanel?

    Thank you very much
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  4. Nikoms

    Nikoms Member

    Joined:
    Nov 29, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  5. Nikoms

    Nikoms Member

    Joined:
    Nov 29, 2006
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    up :p

    nobody?
     
  6. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    **Merged Duplicated Thread**
     
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    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: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:

    Code:
    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.
     
  8. Idaf_1er

    Idaf_1er Registered

    Joined:
    Nov 19, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  9. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page