Displaying and editing MySQL and MariaDB Federated Servers
This module a part of the host administration
Module for managing server connections for the MySQL FEDERATED engine.
Connections can be created, edited and deleted.
Create a new server connection
Edit:
Edit server connection.
Test connection:
Tests the server connection. Only works if the server on which the MyWAY SQL Manager is installed has network access to the server connection.
Delete:
Deletes the server connection.
Edit server connection:
Name:
Name of the connection.
Host:
IP address or name of server to connect to.
Port:
Port with which the SQL server is to be addressed.
Database:
Database to be made available by the connected server.
User:
Database user to log on to remote server with.
Password:
Password of database user.
Wrapper:
Interface for the data connection. Set when the connection is created.
Socket:
Socket descriptor, if required.
Owner:
Owner of the connection. Currently has no effect.
Test connection:
Tests the server connection. Only works if the server on which the MyWAY SQL Manager is installed has network access to the server connection.
Save:
Saves the settings.
Abort:
Closes the editing form.
Create new server connection:
Apply from:
Connection data can be taken over from the servers connected in the MyWAY SQL Manager.
Name:
Name of the new server connection.
Host:
IP address or name of remote server to connect to.
Port:
Port with which the remote SQL server is to be addressed.
Database:
Database to be made available by the connected server.
User:
Database user to log on to remote server with.
Password:
Password of database user.
Wrapper:
Interface for the data connection.
Socket:
Socket descriptor, if required.
Owner:
Owner of the connection. Currently has no effect.
Test connection:
Tests the server connection. Only works if the server on which the MyWAY SQL Manager is installed has network access to the server connection.
Save:
Saves the new server connection.
Abort:
Closes the creation form.
In MySQL and MariaDB, registration of federated servers (FEDERATED SERVER) includes configuring the local server to Connecting to a remote server and defining federated tables (FEDERATED TABLE) that represent tables on the remote server. Registering a federated server allows data from the remote server to be accessed as if it were a local table.
The FEDERATED storage engine should be enabled on both the local and remote servers. The FEDERATED storage engine may not be enabled by default. Network connectivity, permissions, and appropriate configuration settings must exist on both the local and remote servers.
Some limitations apply to federated tables: for example, transactions, foreign keys and some table types are not supported.
