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:
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.
install plugin federated soname 'ha_federated.so'
Now check all engines details:
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:
sudo nano /etc/my.cnf
Write federated into this file:
# Disabling symbolic-links is recommended to prevent assorted security risks
sudo service mysqld restart
Now check all engines details and find FEDERATED engine is 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 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.