I am wanting to backup multiple MySQL databases on a single volume, I know you cannot quiesce multiple mysql dbs at once, but what I am trying to create a master config that just calls the quiesce and then unquiesce from other profiles that are set to a CONFIG_TYPE=PLUGIN so it all works out nicely. However it is not working, maybe I am missing some core concept, but wanted to see if I could get some feedback and help. The master config ran with just a single config runs fine with no errors... Thanks.
OS CentOS 6.2
Snap Creator 3.6.0
MySQL Version 5.1.61
Error:
########## APPLICATION QUIESCE COMMANDS ##########
[Thu Jan 31 16:45:54 2013] INFO: Running application quiesce command APP_QUIESCE_CMD01 ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce]
[Thu Jan 31 16:45:55 2013] WARN: Configuration file stl-linuxweb01_mysql.conf has a "-" character in name, it is not recommended to use this character as it can cause issues
[Thu Jan 31 16:45:55 2013] DEBUG: Loaded Config File C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/configs/Test/stl-linuxweb01_mysql.conf Successfully
[Thu Jan 31 16:45:55 2013] DEBUG: Executing command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce]
[Thu Jan 31 16:45:56 2013] TRACE: Command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce] finished with
exit code: [0]
stdout: []
stderr: []
[Thu Jan 31 16:45:56 2013] DEBUG: Command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce] finished successfully with message
[Thu Jan 31 16:45:56 2013] INFO: Running application quiesce command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce] finished successfully
[Thu Jan 31 16:45:56 2013] INFO: Running application quiesce command APP_QUIESCE_CMD02 ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce]
[Thu Jan 31 16:45:57 2013] WARN: Configuration file stl-linuxweb01_stl_lab.conf has a "-" character in name, it is not recommended to use this character as it can cause issues
[Thu Jan 31 16:45:57 2013] DEBUG: Loaded Config File C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/configs/Test/stl-linuxweb01_stl_lab.conf Successfully
[Thu Jan 31 16:45:56 2013] DEBUG: Executing command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce]
[Thu Jan 31 16:45:59 2013] TRACE: Command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce] finished with
exit code: [512]
stdout: []
stderr: []
[Thu Jan 31 16:45:59 2013] ERROR: Command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce] failed with return code [512] and message []
[Thu Jan 31 16:45:59 2013] ERROR: [scf-00103] Running application quiesce command ["C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce] failed with exit code [512] and message []
Master config,shortened, attached is full version:
#################################################
### Snap Creator Framework Configuration File ###
#################################################
…
########################
### Required Options ###
########################
CONFIG_TYPE=STANDARD
SNAME=mysql
SNAP_TIMESTAMP_ONLY=Y
VOLUMES=stl-a-na01a.lab.stl:prod_nfs_vm_sitea_001
NTAP_SNAPSHOT_RETENTIONS=hourly:4,daily:1
NTAP_USERS=stl-a-na01a.lab.stl:root/53616c7465645f5f32c8ad429259a12549dab181f1e7361da77d7d047e7f9da5
NTAP_PWD_PROTECTION=Y
TRANSPORT=HTTPS
PORT=443
NTAP_TIMEOUT=60
LOG_NUM=30
LOG_TRACE_ENABLE=Y
SC_TMP_DIR=
...
########################
### Snapshot Options ###
########################
NTAP_SNAPSHOT_RETENTION_AGE=
SNAPDRIVE=N
SNAPDRIVE_DISCOVERY=N
NTAP_SNAPSHOT_DISABLE=N
NTAP_SNAPSHOT_NODELETE=N
NTAP_CONSISTENCY_GROUP_SNAPSHOT=N
NTAP_CONSISTENCY_GROUP_TIMEOUT=medium
NTAP_CONSISTENCY_GROUP_WAFL_SYNC=N
NTAP_SNAPSHOT_DELETE_BY_AGE_ONLY=N
NTAP_SNAPSHOT_DEPENDENCY_IGNORE=N
NTAP_SNAPSHOT_RESTORE_AUTO_DETECT=N
NTAP_SNAPSHOT_CLEANUP=N
NTAP_USE_EXTERNAL_SNAPSHOT=N
NTAP_EXTERNAL_SNAPSHOT_REGEX=
...
###################################
### Operations Manager Settings ###
###################################
OM_HOST=stl-a-dfm01
OM_USER=lab\netapp
OM_PWD=53616c7465645f5ff4489bede541b929b62c7c0158f63f4611dbd45e0b04c590
OM_PORT=8088
OM_EVENT_GENERATE=N
...
###########################
### Event Configuration ###
###########################
NTAP_ASUP_ERROR_ENABLE=N
SENDTRAP=
SUCCESS_TRAP=
SUCCESS_MSG=INFO: Snap Creator finished successfully ( Action: %ACTION )
###################################
### Client/Server Configuration ###
###################################
…
SC_AGENT=
SC_AGENT_TIMEOUT=
SC_AGENT_UNQUIESCE_TIMEOUT=
SC_CLONE_TARGET=
SC_AGENT_WATCHDOG_ENABLE=Y
SC_AGENT_LOG_ENABLE=Y
...
APP_QUIESCE_CMD01="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action quiesce
APP_QUIESCE_CMD02="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action quiesce
APP_QUIESCE_CMD03="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_books" --action quiesce
APP_UNQUIESCE_CMD01="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action unquiesce
APP_UNQUIESCE_CMD02="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action unquiesce
APP_UNQUIESCE_CMD03="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_books" --action unquiesce
PRE_EXIT_CMD01="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_mysql" --action unquiesce
PRE_EXIT_CMD02="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_stl_lab" --action unquiesce
PRE_EXIT_CMD03="C:/Program Files/NetApp/NetApp_Snap_Creator_Framework/scServer3.6.0/snapcreator.exe" --profile "Test" --config "stl-linuxweb01_books" --action unquiesce
Called Profiles,shortened, attached are full versions:
#################################################
### Snap Creator Framework Configuration File ###
#################################################
...
########################
### Required Options ###
########################
CONFIG_TYPE=PLUGIN
SNAME=
SNAP_TIMESTAMP_ONLY=N
VOLUMES=
NTAP_SNAPSHOT_RETENTIONS=
NTAP_USERS=
NTAP_PWD_PROTECTION=Y
TRANSPORT=
PORT=
NTAP_TIMEOUT=60
LOG_NUM=30
LOG_TRACE_ENABLE=Y
SC_TMP_DIR=
...
###################################
### Client/Server Configuration ###
###################################
...
SC_AGENT=stl-linuxweb01.lab.stl:9090
SC_AGENT_TIMEOUT=60
SC_AGENT_UNQUIESCE_TIMEOUT=
SC_CLONE_TARGET=
SC_AGENT_WATCHDOG_ENABLE=Y
SC_AGENT_LOG_ENABLE=Y
#############################
### Plugin Module Options ###
#############################
...
#######################
### MYSQL Settings ###
#######################
#################################################################################################################
# MYSQL_DATABASES - List of database(s) and their username/password separated by a comma of which you #
# #
# MYSQL_DATABASES=db1:user1/password;db2:user2/password #
# #
# HOST - Name of Host where the database(s) are running, ie: localhost #
# PORTS - List of Database(s) and the ports they are listening on #
# #
# PORTS=db1:3307;db2:3308 #
# #
# MASTER_SLAVE - (Y|N)If the Database(s) are part of a MASTER or SLAVE Environment #
#################################################################################################################
MYSQL_DATABASES=mysql:root/53616c7465645f5f98c045e58f3fcec5f10b531d75942a840032d7e13b5ebbb0
HOST=localhost
PORTS=mysql:3306
MASTER_SLAVE=N
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#################################################
### Snap Creator Framework Configuration File ###
#################################################
...
########################
### Required Options ###
########################
CONFIG_TYPE=PLUGIN
SNAME=
SNAP_TIMESTAMP_ONLY=N
VOLUMES=
NTAP_SNAPSHOT_RETENTIONS=
NTAP_USERS=
NTAP_PWD_PROTECTION=Y
TRANSPORT=
PORT=
NTAP_TIMEOUT=60
LOG_NUM=30
LOG_TRACE_ENABLE=Y
SC_TMP_DIR=
...
###################################
### Client/Server Configuration ###
###################################
...
SC_AGENT=stl-linuxweb01.lab.stl:9090
SC_AGENT_TIMEOUT=60
SC_AGENT_UNQUIESCE_TIMEOUT=
SC_CLONE_TARGET=
SC_AGENT_WATCHDOG_ENABLE=Y
SC_AGENT_LOG_ENABLE=Y
#############################
### Plugin Module Options ###
#############################
...
#######################
### MYSQL Settings ###
#######################
#################################################################################################################
# MYSQL_DATABASES - List of database(s) and their username/password separated by a comma of which you #
# #
# MYSQL_DATABASES=db1:user1/password;db2:user2/password #
# #
# HOST - Name of Host where the database(s) are running, ie: localhost #
# PORTS - List of Database(s) and the ports they are listening on #
# #
# PORTS=db1:3307;db2:3308 #
# #
# MASTER_SLAVE - (Y|N)If the Database(s) are part of a MASTER or SLAVE Environment #
#################################################################################################################
MYSQL_DATABASES=stl_lab:root/53616c7465645f5f98c045e58f3fcec5f10b531d75942a840032d7e13b5ebbb0
HOST=localhost
PORTS=stl_lab:3306
MASTER_SLAVE=N
...
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
#################################################
### Snap Creator Framework Configuration File ###
#################################################
...
########################
### Required Options ###
########################
CONFIG_TYPE=PLUGIN
SNAME=
SNAP_TIMESTAMP_ONLY=N
VOLUMES=
NTAP_SNAPSHOT_RETENTIONS=
NTAP_USERS=
NTAP_PWD_PROTECTION=Y
TRANSPORT=
PORT=
NTAP_TIMEOUT=60
LOG_NUM=30
LOG_TRACE_ENABLE=Y
SC_TMP_DIR=
...
###################################
### Client/Server Configuration ###
###################################
...
SC_AGENT=stl-linuxweb01.lab.stl:9090
SC_AGENT_TIMEOUT=60
SC_AGENT_UNQUIESCE_TIMEOUT=
SC_CLONE_TARGET=
SC_AGENT_WATCHDOG_ENABLE=Y
SC_AGENT_LOG_ENABLE=Y
#############################
### Plugin Module Options ###
#############################
...
#######################
### MYSQL Settings ###
#######################
#################################################################################################################
# MYSQL_DATABASES - List of database(s) and their username/password separated by a comma of which you #
# #
# MYSQL_DATABASES=db1:user1/password;db2:user2/password #
# #
# HOST - Name of Host where the database(s) are running, ie: localhost #
# PORTS - List of Database(s) and the ports they are listening on #
# #
# PORTS=db1:3307;db2:3308 #
# #
# MASTER_SLAVE - (Y|N)If the Database(s) are part of a MASTER or SLAVE Environment #
#################################################################################################################
MYSQL_DATABASES=books:root/53616c7465645f5f98c045e58f3fcec5f10b531d75942a840032d7e13b5ebbb0
HOST=localhost
PORTS=books:3306
MASTER_SLAVE=N
...
