MySQL: Create FEDERATED Table using CREATE SERVER

In the previous list of articles, I have demonstrated FEDERATED storage engine to perform cross server queries between MySQL Servers.

You can visit this article for creating FEDERATED table using a direct connection string.

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:

Now use this server information to create Remote FEDERATED Table:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz