Veritas NetBackup™ for MySQL Administrator's Guide

Last Published:
Product(s): NetBackup (9.0.0.1, 9.0)

The nbmysql configuration file

The configuration file (nbmysql.conf) contains the parameters for the respective operations. It contains predefined settings and is located on the client. You can configure the parameters in the nbmysql.conf file or provide them on the command line, where the command line parameters take precedence. The nbmysql.conf file keeps you from providing the parameters every time you run operations. When parameters are not configured in the nbmysql.conf file, then the default parameter value takes precedence.

The nbmysql.conf file is located in the following locations:

  • (Windows) install_path\NBMySQLAgent_version number_AMD64\nbmysql.conf .

  • (Linux (RHEL) install_path/NBMySQLAgent_version number_linuxR_x86/nbmysql.conf.

  • (Linux SUSE) install_path/NBMySQLAgent_version number_linuxS_x86/nbmysql.conf.

Table: The nbmysql.conf parameters lists the nbmysql.conf parameters.

Table: The nbmysql.conf parameters

Parameters

Description

Required parameter for

Default value

DB_USER

Configures the MySQL database user name.

Backup and restore operations.

When you do not set the database user name, it defaults to root.

DB_PORT

Configures the MySQL database server port number on which the backup or the restore has to be performed.

Restore operations

When you do not set the database server port, it defaults to 3306.

DB_HOST

Configures the MySQL database hostname.

Non-LVM restore operations

No default value for this parameter. This parameter must be specified.

MYSQL_LIB_INSTALL_PATH

Configures the libmysql.dll//libmysqlclient.so binary path. On Windows, the library directory is at MySQL server installed path.

On Linux, run the libmysqlclient command to locate the library path.

Backup operations

No default value for this parameter.

MASTER_SERVER

Specifies the NetBackup master server to run backups and restores.

Backup operations

No default value for this parameter.

POLICY_NAME

Specifies the NetBackup DataStore policy name.

Backup operations

No default value for this parameter.

SCHEDULE_NAME

Identifies the backup schedule that you configured while creating the DataStore policy.

Backup operations

No default value for this parameter.

CLIENT_NAME

Defines the NetBackup MySQL client name.

Redirected restores and query backups.

When you do not set the NetBackup client, it defaults to the NetBackup master server.

SNAPSHOT_SIZE

(Linux) Specifies the snapshot size in kilobytes, megabytes, or gigabytes as K, M, or G respectively.

LVM backups

When you do not set the snapshot size, it defaults to MB.

COPY_ID

Represents the backup image name. You can use this value to query, restore, or delete a specific backup.

To query, restore, or delete a backup using its backup image name.

No default value for this parameter.

MYSQL_TARGET_DIRECTORY

Specifies the destination directory where you want to restore the backups.

Restore backups.

No default value for this parameter.

NBMYSQL_LOG_LEVEL

The NBMYSQL_LOG_LEVEL lets you set the logging level for the NetBackup MySQL logs. The default value is 1. For a particular logging level, all details at that level or lower are logged.

The MySQL debug logs includes the following verbose levels:

  • 1 - ERROR: Conditions that should be corrected, such as configuration errors.

  • 2 - WARN: Conditions that are not errors, but that might require special handling.

  • 3 - INFO: Informational messages

  • 4 - DEBUG: Debugging the messages that is used for troubleshooting.

The log levels help to control the amount of information that you want to access, when troubleshooting errors.

When you do not set nbmysql log level, it defaults to level 1.

NBMYSQL_LOG_SIZE

Configures the nbmysql.conf log size in MB. When the log reaches the specified size, it overwrites the log information.

You can specify the value according to the events that you want to write into the logs.

When you do not specify the nbmysqllog size, the default is 10MB.

BACKUP_TYPE

Available options:

  • auto: Default option. Performs an auto discovery backup.

  • lvm: Agent forces to do a lvm snapshot.

  • nonlvm: Agent forces to do a nonlvm way backup by using mysqldump.

Backup operations

auto