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