CODEWITHSUNDEEP
mysqlfederated-storage-engine
MRQ
MRQ

Reputation: 41

How to check if Federation is enabled

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.

Upvotes: 2

Views: 3261

Answers (2)

Maximiliano Carvalho
Maximiliano Carvalho

Reputation: 21

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

[mysqld] federated

Restart MySql Server and it's done!

Upvotes: -1

gnur
gnur

Reputation: 4733

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

Upvotes: 2

Related Questions