MySQL Forums
Forum List  »  Federated Storage Engine

Tables Created with FEDERATED option are created with MyISAM engine.
Posted by: richard parris
Date: October 07, 2008 04:51AM

I am attempting to set up a database with federated tables to enable reporting across two servers with the same structure. My problem is that whenever I attempt to create a federated table the engine for the table created is listed as having MyISAM as it's engine.

I have followed the instructions here:
http://dev.mysql.com/doc/refman/5.0/en/federated-use.html
to create a database on the remote server ('china.cn') and attempted to create a federated table, in a database ('federated') on the local server ('japan.jp'):

CREATE TABLE federated_table (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
other INT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://user:password@china.cn:3306/test/test_table';

This runs without issue.

However, the table is created with the MyISAM engine. (phpMyAdmin lists the table 'Type' as MyISAM and exporting the table shows the engine as MyISAM.)

I have made sure that the japan.jp mysqld has been started with the --federated option.

I am running MySQL 5.0.66a on Japan on a Centos4 VPS and MySQL 5.0.0.45 in China on a Centos5 VPS.



Edited 1 time(s). Last edit at 10/07/2008 04:52AM by richard parris.

Options: ReplyQuote


Subject
Views
Written By
Posted
Tables Created with FEDERATED option are created with MyISAM engine.
7876
October 07, 2008 04:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.