How do I use Mysql Federated?

Asked

Viewed 915 times

2

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

Is there anywhere else I can change to enable such a function.

Mysql Server Usage 5.6 Windows 8.1 64-bit Pro.

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.

my.ini

show engines pesquisa

mysql engine

  • Which was the changed file path?

  • you need to enable on my.cnf as well

  • Otto my.cnf this on which way?

  • Have you tried searching ?

2 answers

2

According to that reply from Soen the changed file must be my.ini from the folder: C:\ProgramData\MySQL\MySQL Server 5.6, to activate the Federated engine

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

inserir a descrição da imagem aqui

  • The line I should add Federated is below the [mysqld], or at the end of all the instructions you have below?

  • Below [mysqld]

  • as follows in the print I posted above?

  • That’s right, just see if it’s my.ini do c:\programdata

  • The file is called my-default.ini and is in C: Program Files Mysql Mysql Server 5.6 my-default.ini dai I did the procedure that passed but without success.

  • On the past path in the answer there is my.ini?

  • I really could not, activate the FEDERATED Engine by changing my.ini file. Could be some Mysql version issue that doesn’t have Engine support.

  • I tested here with Win8 32bits and mysql 5.6

  • @Claytonquintilian, it worked? What was the problem?

  • The above task has healed my problem. Thank you

  • 1

    Next I made the above change but it did not have any effect, today I’m testing on a micro with Windows 8.1 only that 32 bits and presented the same problem as Windows 64 bits. Looking for another Options File function in Workbench maintenance and there has a field in the General Guide with the name Federated without being linked. When ticking the option released an option to inform a value, at random I informed ON. And at the initial the server again enabled the FEDERATED function. Now I will test on the 64-bit machine.

  • @Claytonquintiliano, since it worked post this procedure as an answer, I did not know this way to enable the federated engine by Workbench.

Show 7 more comments

2


I solved the problem differently.

First stop the database service through Startup/Shutdown

inserir a descrição da imagem aqui

Then go to Options File option

inserir a descrição da imagem aqui

On the Options File screen in the General tab we have the second Federated option disabled.

inserir a descrição da imagem aqui

Enable the check box and enter the ON value in the field ahead.

inserir a descrição da imagem aqui

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

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

inserir a descrição da imagem aqui

And confirm at the command prompt by performing a show Engines having to return equal to the image below.

inserir a descrição da imagem aqui

Browser other questions tagged mysql engine

You are not signed in. Login or sign up in order to post.