MySQL: FEDERATED Table Engine – SELECT data from another Server (Part 1/4)

In this post, I am going to start a small series of articles which are divided into four different parts.

In this series of articles, I will provide basic theory and practical to perform cross platform or server queries. We can also say remote connection queries.

Some of the Database Professional already aware about Linked server object of Microsoft SQL Server, which is basically used for cross server queries.

Many times, we actually need to SELECT data from different database server and even, we require to fetch data from different RDBMS product as well.

MySQL also provides the FEDERATED Storage Engine to access data from a remote MySQL Database Server.

The FEDERATED Storage Engine is available beginning with MySQL 5.0.3.

Using FEDERATED Engine, we don’t require to implement any replication or clustering.

We don’t require to write any database level trigger to update real time data into the local FEDERATED table because it is fetching data remotely and even does not require to store that data physically on the hard disk.

We can query to the local FEDERATED table like any other normal table, but actually it is working as virtual table only.

The FEDERATED storage engine is not enabled by default in the running server.
You can visit the next article to configure and enable FEDERATED Engine.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

1 Comment on "MySQL: FEDERATED Table Engine – SELECT data from another Server (Part 1/4)"

Notify of

Sort by:   newest | oldest | most voted
8 months 13 days ago

Ur website is really awesome! I wanna say thank you for sharing the fantastic info with me.