How to check if Federation is enabled

Question

I want to know what the command is that I can run in the shell to find out if Federation is enabled on a MySQL server or not?

Thanks.

score 2 · Answer 1 · answered Feb 18 '11 at 09:04

2

Login to mysql server and do SHOW ENGINES\G, this it what it says on one of my mysql servers:

*************************** 10. row ***************************
 Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine

answered Feb 18 '11 at 09:04

gnur

COMMAND TO ACTIVATE IT..PLEASE – MRQ Feb 18 '11 at 09:13
3

You cannot activate it with a simple command. You need to reinstall the mysql server and have a specific version that allows `federated` and please don't ever shout at me again. – gnur Feb 18 '11 at 09:30
apologies, wasn't shouting didn't realize my upper case was on – MRQ Feb 18 '11 at 09:51

score -1 · Answer 2 · answered Jul 15 '14 at 13:37

-1

Edit the file /etc/mysql/my.cn At the [mysqld] section add:

[mysqld] federated

Restart MySql Server and it's done!

answered Jul 15 '14 at 13:37

The question is how to check if it's enabled, not how to enable it. – nobody Jul 15 '14 at 13:38
1

the question is wrong formatted. if look at the first comment after the first answer you will see that the user asks for how to activated FEDERATED tables. – Maximiliano Carvalho Jul 15 '14 at 18:04
@user2766218 Followup questions asked in comments don't really count - comments should only clarify what the original question is asking, not add new questions. This answer doesn't answer or even help with the original question, so it's inappropriate. – Brilliand Aug 21 '14 at 18:48

2 Answers2