MySQL Forums
Forum List  »  MySQL Administrator

mysql daemon list
Posted by: Ravi Thati
Date: May 16, 2013 12:20PM

I am trying to identify ways for doing the below task:
Find the list of MySQL servers on given list of hosts.
For each server, collect
1. cnf file path
2. Base Dir
3. DataDir
4. Socket/Port

my inputs are list of hosts and permissions to run commands as sudo user on those hosts.

As MySQL doesnot define any path OR user as standard, mysqld can be run with any user and it can be isntalled on any location. This is same with cnf file too.
I see only one way,i.e to find process list (Linux: ps -aef) and get mysqld. It would be command line arguments passed as start up arguments. At least we can figure cnf file for each mysqld running.

looking for better ideas from you.

Options: ReplyQuote

Written By
mysql daemon list
May 16, 2013 12:20PM
May 18, 2013 11:46PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.