Federated
- Federated
-
Federated est un moteur de stockage pour le SGBD MySQL. Il permet d'accéder à des données stockées dans des bases de données distantes, et ce sans recourir à des systèmes de réplication ou de clustering.
Il a été introduit dans la version 5.0.3 de MySQL[1].
Exemple
- Sur le serveur distant, qui contient les données réelles :
CREATE TABLE `fournisseur` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`nom` VARCHAR(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE = MyISAM;
- Sur le serveur local, qui contient seulement un lien vers les données distantes :
CREATE TABLE `fournisseur` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`nom` VARCHAR(40) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE = FEDERATED
CONNECTION = 'mysql://login:password@serveur.com:3306/nombasedonnees/fournisseur';
Limitations
Les tables de type Federated sont soumises à de nombreuses limitations, souvent dues à leur nature même. Citons par exemple :
- La table distante doit être créée avant la table locale.
- Les transactions ne sont pas supportées[2].
- Les partitions utilisateur ne sont pas supportées.
Références
Voir aussi
Wikimedia Foundation.
2010.
Contenu soumis à la licence CC-BY-SA. Source : Article Federated de Wikipédia en français (auteurs)
Regardez d'autres dictionnaires:
federated — fed er*at*ed, adj. United by compact under a central organization, as governments or commercial organizations. Syn: federate. [WordNet 1.5] … The Collaborative International Dictionary of English
federated — index affiliated, associated, conjoint, mutual (collective) Burton s Legal Thesaurus. William C. Burton. 2006 … Law dictionary
federated — federation fed‧e‧ra‧tion [ˌfedəˈreɪʆn] noun [countable] 1. ORGANIZATIONS a group of organizations, clubs, or people that have joined together to form a single group to represent their interests, and often used in the names of professional… … Financial and business terms
federated — [[t]fe̱dəreɪtɪd[/t]] ADJ: ADJ n, v link ADJ to n Federated states or societies are ones that have joined together for a common purpose. Whether to stay in the federated state or become independent is a decision that has to be made by the people … English dictionary
federated — adjective united under a central government • Syn: ↑federate • Similar to: ↑united * * * federated adjective Thesaurus: words used to describe systems and types of governmenthyponym … Useful english dictionary
Federated search — is the simultaneous search of multiple online databases and is an emerging feature of automated, Web based library and information retrieval systems. It is also often referred to as a portal, as opposed to simply a Web based search… … Wikipedia
Federated Auto Parts 300 — Veranstaltungsort: Nashville Superspeedway Hauptsponsor: Federated Auto Parts Erstes Rennen: 2002 Distanz: 300 Meilen (482,8 km) Anzahl Runden: 225 Ehemalige Namen: Inside Traxx 300 (2002 … Deutsch Wikipedia
Federated Portal Network — (FPN) is a framework for remote content sharing between enterprise portals.In a Federated Portal Network each portal can act as a producer, exposing the content to other portals or as a consumer, using the content shared by other producer portals … Wikipedia
Federated States of Micronesia at the 2009 World Championships in Athletics — Federated States of Micronesia at the World Championships in Athletics … Wikipedia
Federated Farmers — of New Zealand Incorporated is an organisation in New Zealand which lobbies on behalf of its member farmers. It has a network of 24 provinces and seven industry groups. Federated Farmers provides a locally based, democratic organisation that… … Wikipedia