MySQL Federated

MySQL Federated Storage EngineOriginal author(s)| Patrick Galbraith, Brian Aker

|

Initial release| 2005
Operating system| Linux, Mac OS X, Unix; Windows
Platform| x86, x86-64, SPARC, MIPS, PowerPC
Available in| C/C++
Type| Database engine
License| GNU General Public License
Website| http://mysql.bkbits.net

Federated is a storage engine for the MySQL MariaDB relational database management system that allows creation of a table that is a local representation of a foreign (remote) table. It uses the MySQL client library API as a data transport, treating remote tables as if they were located on the local server. Each Federated table that is defined there is one .frm (data definition file containing information such as the URL of the data source). The actual data can exist on a local or remote MySQL instance.

To create a Federated table, one has to specify a URL in the "CONNECTION" string:

create table t1 (
a int,
b varchar(32))
ENGINE=FEDERATED CONNECTION='mysql://user@hostname/test/t1'

The connection URL is in the format of:

scheme://user:pass@host:port/schema/tablename

Upon creation of a Federated table, the user must ensure that the remote data source does indeed exist or an error will be issued.

The MySQL Federated Storage Engine was authored by Patrick Galbraith and Brian Aker and is currently being maintained by Patrick Galbraith and Antony Curtis. It was introduced in 2005 with MySQL 5.0.

## External links

* MySQL Documentation on Federated Storage Engine

* v
* t
* e

MySQL

Editions|

* MySQL
* MySQL Enterprise
* MySQL Cluster

MySQL tools|

* MySQL Workbench
* SQLyog
* phpMyAdmin
* HeidiSQL
* Navicat
* Database Workbench
* DBeaver

Storage engines|

* MyISAM
* Falcon
* InnoDB
* XtraDB
* MySQL Federated
* MySQL Archive
* Aria
* TokuDB

Procedural Language|

* MySQL Stored Procedures (a variant of SQL/PSM Standard)

Forks and Branches|

* Drizzle
* MariaDB
* Percona
* WebScaleSQL

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/MySQL Federated. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:MySQL_Federated&oldid=721207"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template