MySQL Forums
Forum List  »  Federated Storage Engine

5.0.77 - how to activate federated?
Posted by: Derek Wickersham
Date: February 02, 2012 04:39AM

I've read the documentation and checked the forums but still am unable to get federated working on MySQL 5.0.77 (specifically, mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1).


I added the following line to the [mysqld] section of /etc/my.cnf:
federated=1

I added --federated to the startup options for mysqld. Here are the active running processes:

# ps -ef | grep mysqld
root 2456 1 0 11:30 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql --federated
mysql 2511 2456 0 11:30 pts/0 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock --federated

However, it appears that federated is still not available:

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 | 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 |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

So, I need some guidance on what else needs to be done.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
5.0.77 - how to activate federated?
7300
February 02, 2012 04:39AM


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.