Instance Status Monitoring

• To monitor the status of each guarded server instance, the MySQL Instance Manager attempts to connect to the instance at regular intervals.
  • It uses the MySQL_Instance_Manager@localhost user account with a password of check_connection.
  • One should not create this account for MySQL Server.

• Status monitoring for nonguarded instances is done only when the following command are invoked.
  • SHOW INSTANCES
  • SHOW INSTANCE STATUS

• Instance Manager knows if a server instance fails at startup because it receives a status from the attempt.
  • For an instance that starts but later crashes, Instance Manager receives a signal because it is the parent process of the instance.

What are the Instance Manager commands?

---

---

© 2007 John Michael Pierobon

Notes