33. Federated Servers

Starting from MySQL^TM v.5.1.15 you can manage the Federated Servers using the syntax CREATE / ALTER / DROP SERVER. This can help you in creating a FEDERATED table in a fast and more efficient way.

Creating a Federated Server
To create a Federated Server:

1. open the ''Server Object List'' (chap. 16);
2. right click on the ''Federated Servers'' node and select the ''Create Federated Server'' item from the popup menu;
3. use the ''Federated Servers Editor'' (sec. 33.1).

Editing a Federated Server
To edit a Federated Server:

1. open the ''Server Object List'' (chap. 16);
2. expand the ''Federated Servers'' node;
3. double click or right click on the Federated Server and select the ''Edit Federated Server'' item from the popup menu;
4. use the ''Federated Servers Editor'' (sec. 33.1).

Dropping a Federated Server
To drop a Federated Server:

1. open the ''Server Object List'' (chap. 16);
2. expand the ''Federated Servers'' node;
3. right click on the Federated Server and select the ''Drop Federated Server'' item from the popup menu.
4. confirm the requested operation.

Multi-Drop of Federated Servers
To drop a set of Federated Servers:

1. open the ''Server Object List'' (chap. 16);
2. right click on the node ''Federated Servers'' and select the ''Multi-Drop of Federated Servers'' item from the popup menu;
3. use the ''Multi-Drop Wizard'' (chap. 26).

See Also:

•  27: Server Properties
•  32: Server Extension

---

Copyright © 2007 - 2009 HoneySoftware - All Rights Reserved

Submit feedback on this topic.