This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In the previous list of articles, I have demonstrated FEDERATED storage engine to perform cross server queries between MySQL Servers.
In this post, I am showing to create the Connection Server and use that Server detail with multiple FEDERATED Table of MySQL.
Without a Connection server, we need to write the connection string in each and every FEDERATED table so when we have a multiple FEDERATED table which are using same remote connection information then I suggest you to create Connection Server once and use with all tables.
Below is a small demonstration.
First Create Server:
CREATE SERVER FederatedConnectionServer
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'UserName',password 'Password', HOST 'localhost', PORT 3306, DATABASE 'TestDB');
CREATE TABLE tbl_RemoteTable