Federated servers
Federated server is used for working with FEDERATED storage engine. SUPER privilege is required for creating server of this type.
Note: This object is available from MySQL server version 5.0.3.
To create federated server
- select the Database | New Object item of the main menu, then select server objects in the appeared window and pick Federated Server;
- select the Federated Server | New Log file group... context menu item in the database explorer;
- press <Ctrl+N>, then select server objects in the appeared window and pick Federated Server.
Newly created object is automatically opened in Federated Server Editor.
There is a specific wizard for duplicating objects. To copy federated server use the Duplicate Federated Server <federated_server_name> item from the context menu. Duplicate object wizard in this case will be opened at the Selecting destination database, as the previous ones provide selecting of source database and object to copy.
To edit federated server:
- double-click a federated server in DBExplorer to open it in the Federated Server Editor;
or
- right-click a federated server in DBExplorer and select the Edit Federated Server <federated_server_name> item from the context menu.
To rename federated server:
- select the Rename Federated Server <federated_server_name> item from the context menu
or
- simply press Ctrl+R
To drop federated server:
- right-click a federated server in the DBExplorer and select the Drop Federated Server <federated_server_name> item;
or
- select a federated server and press Ctrl+Del.
|
See also: |