MySQL DataController: Difference between revisions

Revision as of 01:10, 14 July 2015

Latest revision as of 06:01, 9 December 2020

(2 intermediate revisions by 2 users not shown)

Line 1:

{{Orphan|date=May 2011}}

{{Infobox Software

| name = MySQL Datacontroller Plugin Storage Engine

Line 18 ⟶ 16:

| genre = [[Database engine]]

| license = [[GNU General Public License]]

| website = [httphttps://wwwlaunchpad.acentera.comnet/mysql-datacontroller/ http://www.acentera.com/mysql-datacontroller/]

}}

Line 29 ⟶ 27:

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

<sourcesyntaxhighlight lang="sql">

create table foo (

id int,

Line 35 ⟶ 33:

dt date)

ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo'

</syntaxhighlight>

</source>

The connection URL is in the format of:

Line 53 ⟶ 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]]