MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?

mshearer — Thu, 05 Jun 2025 06:11:10 GMT

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

...

topic Re: MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue? in Data Protection

MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?

Re: MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?

Re: MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?

Re: MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?

Re: MySQL - Quiescing Multiple Databases Using Separate Configs for Each - Issue?