How do I use MySQL Federated?

2

I need to use the FEDERATED Engine in my MySQL database but by default it is disabled, in some forums it says that in order to enable it, go to the configuration file my.ini and add the federated line below [mysqld ], I did such a procedure but without success.

There is more than one place I can change to enable such a function.

Using MySQL Server 5.6 Windows 8.1 Pro 64 bit.

I did the above procedure but without success, I have the print of how it is returned to me in the Workbench when searching using show engines.

asked by anonymous 03.09.2014 / 06:02

2 answers

2

I solved the problem differently.

First stop the database service through Startup / Shutdown

ThengotoOptionsFile

In the Options File screen on the General tab we have the second federated option disabled.

EnablecheckboxandenterONvalueinforwardfield.

After this click apply and then apply again in the new window

Go back to the Startup / Shutdown function and start the server again.

Andconfirmatthecommandpromptbyperformingashowengineshavingtoreturnthesameimagebelow.

    
03.09.2014 / 20:34
2

According to this SOen response the changed file should be the folder my.ini: C:\ProgramData\MySQL\MySQL Server 5.6 , to enable the federated engine

  • Stop the mysql service.
  • Open my.ini and add a new line with the content federated logo below the [mysqld] section.
  • Start the service again and run the query: show engines . The result should look something like the image.

    
03.09.2014 / 13:37