MySQL: Configured and Enable FEDERATED engine (Part 2/4)

In the previous post, we have discussed basic theory of the FEDERATED Table Engine.

As earlier I discussed that, FEDERATED Engine is not by default enabled so In this post, I am giving basic commands to enable and configure FEDERATED Table Engine.

The First Check FEDERATED engine is available or not:

MySQL Show Engines

Using above command we can get all available engines. In this result image you can not find a FEDERATED engine so we need to install it.

Command to enable federated engine.

Now check all engines details:

MySQL Federated Engine

In the above result, we can find new entry of FEDERATED engine, but still it is OFF.

To enable this, we need to add one federated line into my.cnf file

Command to open my.cnf file:

Write federated into this file:

Restart Mysqld:

Now check all engines details and find FEDERATED engine is ON:

MySQL Federated Engine ON

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

Be the First to Comment!

Notify of