4 Replies Latest reply: Feb 11, 2013 1:29 PM by mshearer RSS

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

mshearer NetApp Employee CertifiedPlus Novice
Currently Being Moderated

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

...

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points