Content deleted Content added
←Created page with '{{Infobox Software | name = MySQL Datacontroller Plugin Storage Engine | logo = | screenshot = | caption = | author = Francis Lavalliere | developer = | release...' |
deorphan |
||
| (9 intermediate revisions by 8 users not shown) | |||
Line 16:
| genre = [[Database engine]]
| license = [[GNU General Public License]]
| website = [https://launchpad.net/datacontroller http://www.
}}
The '''MySQL Datacontroller''' storage engine for the [[MySQL]] [[relational database management system]] is a storage engine which allows a user to create a table that is a local representation of a foreign (remote) table.
The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server (MSSQL).
It utilizes the MySQL client library API, Free-TDS and OCILIB as a data transport, treating the remote data source the same way other storage engines treat local data sources.
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 Oracle, Microsoft SQL Server (MSSQL), or MySQL instance.
To create a Federated table, one has to specify a URL in the "CONNECTION" string:
<
create table foo (
id int,
Line 33:
dt date)
ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo'
</syntaxhighlight>
The connection URL is in the format of:
Line 41:
scheme://user:pass@host:port/DB/schema/tablename
Upon creation of a
The DataController Storage engine was first based
It was introduced in 2005 with MySQL 5.0.
Line 51:
* [http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html MySQL Documentation on Federated Storage Engine]
* [https://launchpad.net/datacontroller MySQL DataController Plugin]
* [http://www.acentera.com/mysql-datacontroller/ MySQL DataController Blog and Video demo]
[[Category:MySQL]]
{{database-software-stub}}
| |||