Mysql management

[bakardi]

hi
i am designing a software that would keep track of Mysql database health and notify any critical events ...

i have two options at the very high level! -
whether to start the agent <information provider> when the Mysql database is started or
to keep the agent independent of Mysql.ie. start it at our preference!

what are the manageable informations that could be obtained from the Mysql when it is started.

plz letme know something about it.

 

[williamu]

Hi,

If you want to be notified of critical events then you should start your monitor at the same time as the server. There are lots of things you could monitor, but some of it might depend on what you use to monitor the DB.

Have you given your project any further thought as to how this will be done? I.E. Shell scripts, PHP, C etc.


William
Software Engineer
ICQ No. 56047340

 

[bakardi]

ya
i have to create the agent using c.

 

[williamu]

Well then the world is open to you. You can monitor the entire system using the C API, Tables, Indicies, Logs, etc. I guess it's down to what you wish to include.



William
Software Engineer
ICQ No. 56047340

 

[bakardi]

thanx william,
but is there anything particular that can be obtained right at the moment when the database is started.