Data Backup and Recovery

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

mshearer
4,209 Views

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

...

4 REPLIES 4

mshearer
4,209 Views

So digging around some more, I looked in the agent logs and see this error:

[Thu Jan 31 18:02:45 2013] DEBUG: Connection to stl_lab successfully established

[Thu Jan 31 18:02:45 2013] DEBUG: Executing sql command 'flush tables with read lock' for database stl_lab

[Thu Jan 31 18:02:45 2013] ERROR: [agt-00013] send: Cannot determine peer address at /</usr/local/scAgent3.6.0c/snapcreator>Net/MySQL.pm line 293

My speculation at this point is that the agent establishes a connection with the database and maintains that connection and when it tries to do the second database it just bombs out?

sivar
4,209 Views

Were you able to resolve this?

Try supplying PORTS=3306 alone

Also, please ensure that your OS version and MYSQL version are supported per NetApp IMT.

cferbrache
4,209 Views

I think you may have responded to the wrong person for this issue. I have an Informix issue not SQL.

Thanks,

Cary Ferbrache, Sr. Systems Engineer

(904) 296-4562| AVN 810-4562

6600 Corporate Center Parkway, Jacksonville, FL 32216

cferbrache@acosta.com<mailto:cferbrache@acosta.com>

Please consider the environment before printing this email.

mshearer
4,209 Views

Not sure I really figured this out as it is not an elegant solution, but if I start the client agent multiple times on different ports and point each database at a different agent it works just fine.

Public