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 dbrnd.com, 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.