SHOW VARIABLES LIKE 'server_id'; Variable_name Value server_id 1 SHOW INSTANCES; instance_name status mysqld1 online mysqld2 offline -------------------------------------------------------------------- -- 1.1.2. -------------------------------------------------------------------- START INSTANCE mysqld2; Success: the process has been started. SHOW VARIABLES LIKE 'port'; Variable_name Value port IM_MYSQLD2_PORT -------------------------------------------------------------------- -- 1.1.3. -------------------------------------------------------------------- STOP INSTANCE mysqld2; Success: the process has been stopped. -------------------------------------------------------------------- -- 1.1.4. -------------------------------------------------------------------- START INSTANCE mysqld3; ERROR HY000: Bad instance name. Check that the instance with such a name exists START INSTANCE mysqld1; ERROR HY000: The instance is already started -------------------------------------------------------------------- -- 1.1.5. -------------------------------------------------------------------- STOP INSTANCE mysqld3; ERROR HY000: Bad instance name. Check that the instance with such a name exists -------------------------------------------------------------------- -- 1.1.6. -------------------------------------------------------------------- Killing the process... Waiting... Success: the process was restarted. SHOW INSTANCES; instance_name status mysqld1 online mysqld2 offline -------------------------------------------------------------------- -- 1.1.7. -------------------------------------------------------------------- START INSTANCE mysqld2; Success: the process has been started. Killing the process... Waiting... Success: the process was killed. -------------------------------------------------------------------- -- 1.1.8. -------------------------------------------------------------------- SHOW INSTANCE STATUS; ERROR 42000: You have an error in your command syntax. Check the manual that corresponds to your MySQL Instance Manager version for the right syntax to use -------------------------------------------------------------------- -- BUG#12813 -------------------------------------------------------------------- START INSTANCE mysqld1,mysqld2,mysqld3; ERROR 42000: You have an error in your command syntax. Check the manual that corresponds to your MySQL Instance Manager version for the right syntax to use STOP INSTANCE mysqld1,mysqld2,mysqld3; ERROR 42000: You have an error in your command syntax. Check the manual that corresponds to your MySQL Instance Manager version for the right syntax to use STOP INSTANCE mysqld2; ERROR HY000: Cannot stop instance. Perhaps the instance is not started, or was started manually, so IM cannot find the pidfile. End of 5.0 tests