I check mysql server status by ssh to the server.
$ mysql mysql> status
Beside this way, is there any other way that I can use ssh to remote check the status? Since there are many mysql servers, I don't want to ssh to each of them. Thanks.
Try mysqladmin, which can query the database for it's status.
On the localhost, you can store the password in a ~/.my.cnf file (make sure the permissions are strict). Here's an example from the MySQL 5.1 manual:
Then, you can automatically query the remote MySQL server like this:
You'll want to make sure that the firewall on the remote server allows these connections. You'll also want to check that the MySQL privileges allow this sort of access from a remote host. If you are concerned about packet sniffing on your LAN, then configure MySQL to use SSL.
You can avoid these hassles by running the command through ssh.
You can combine it into one command:
Beyond that, I would look at tools like puppet if you want further automation.