- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 4.6 MySQL Administrative and Utility Programs
- 4.6.1 innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2 myisam_ftdump — Display Full-Text Index information
- 4.6.3 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4 myisamlog — Display MyISAM Log File Contents
- 4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6 mysqlaccess — Client for Checking Access Privileges
- 4.6.7 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.8 mysqlhotcopy — A Database Backup Program
- 4.6.9 mysqlmanager — The MySQL Instance Manager
- 4.6.9.1 MySQL Instance Manager Command Options
- 4.6.9.2 MySQL Instance Manager Configuration Files
- 4.6.9.3 Starting the MySQL Server with MySQL Instance Manager
- 4.6.9.4 Instance Manager User and Password Management
- 4.6.9.5 MySQL Server Instance Status Monitoring
- 4.6.9.6 Connecting to MySQL Instance Manager
- 4.6.9.7 MySQL Instance Manager Commands
- 4.6.10 mysqlmanagerc — Internal Test-Suite Program
- 4.6.11 mysqlmanager-pwgen — Internal Test-Suite Program
- 4.6.12 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.13 mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 4.6.14 mysql_find_rows — Extract SQL Statements from Files
- 4.6.15 mysql_fix_extensions — Normalize Table Filename Extensions
- 4.6.16 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.17 mysql_tableinfo — Generate Database Metadata
- 4.6.18 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.19 mysql_zap — Kill Processes That Match a Pattern
[+/-]
- 4.6.9.1. MySQL Instance Manager Command Options
- 4.6.9.2. MySQL Instance Manager Configuration Files
- 4.6.9.3. Starting the MySQL Server with MySQL Instance Manager
- 4.6.9.4. Instance Manager User and Password Management
- 4.6.9.5. MySQL Server Instance Status Monitoring
- 4.6.9.6. Connecting to MySQL Instance Manager
- 4.6.9.7. MySQL Instance Manager Commands
mysqlmanager is the MySQL Instance Manager (IM). This program monitors and manages MySQL Database Server instances. MySQL Instance Manager is available for Unix-like operating systems, and also on Windows as of MySQL 5.0.13. It runs as a daemon that listens on a TCP/IP port. On Unix, it also listens on a Unix socket file.
MySQL Instance Manager is included in MySQL distributions from
version 5.0.3, and can be used in place of the
mysqld_safe script to start and stop one or
more instances of MySQL Server. Because Instance Manager can
manage multiple server instances, it can also be used in place
of the mysqld_multi script. Instance Manager
offers these capabilities:
Instance Manager can start and stop instances, and report on the status of instances.
-
Server instances can be treated as guarded or unguarded:
When Instance Manager starts, it starts each guarded instance. If the instance crashes, Instance Manager detects this and restarts it. When Instance Manager stops, it stops the instance.
A nonguarded instance is not started when Instance Manager starts or monitored by it. If the instance crashes after being started, Instance Manager does not restart it. When Instance Manager exits, it does not stop the instance if it is running.
Instances are guarded by default. An instance can be designated as nonguarded by including the
nonguardedoption in the configuration file. Instance Manager provides an interactive interface for configuring instances, so that the need to edit the configuration file manually is reduced or eliminated.
Instance Manager provides remote instance management. That is, it runs on the host where you want to control MySQL Server instances, but you can connect to it from a remote host to perform instance-management operations.
The following sections describe MySQL Instance Manager operation in more detail.
User Comments
Add your own comment.