[RESOLVED] How to check if slave servers are up

[richie]

Hello,

I have some slave servers setup, and are working fine as they should. I'm running mysql on linux.

I need to know that the slave servers are up at all times. To find out, I have to login to mysql (# mysql -u db_user -p) and issue the command:

SHOW SLAVE STATUS \G

Unfortunately, I can only do the above manually from the commandline.

Is there a way to automate it in PHP?

My plan is to receive an email if the output of "SHOW SLAVE STATUS \G" contains certain keywords.

Thx.

[dagon]

you can issue SHOW SLAVE STATUS command via php the same way you issue any mysql command

[richie]

Thanks, that worked.

[bradgrafelman]

Don't forget to mark this thread resolved.