NBU 5240备份centos环境下的mysql数据库

NBU服务端添加客户端的主机名 (hosts解析)

NBU 备份一体机5240进入shell界面编辑hosts文件

tail -1 /etc/hosts
客户端IP地址 客户端主机名 客户端主机名

客户端添加服务端的主机名 (hosts解析)

[root@centos ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.1.xx.xxx nbu-one nbu-one
10.1.xx.xxx nbu-two nbu-two

安装Linux NBU客户端

ll -h | grep NetBackup_8.1.2_CLIENTS2.tar.gz
-rw-r–r– 1 root root 3.4G 7月 27 18:29 NetBackup_8.1.2_CLIENTS2.tar.gz
tar -zxvf NetBackup_8.1.2_CLIENTS2.tar.gz
cd NetBackup_8.1.2_CLIENTS2
[root@centos NetBackup_8.1.2_CLIENTS2]# ls
Doc install LICENSE NBClients VSM_README
[root@centos NetBackup_8.1.2_CLIENTS2]# ./install
一路y 提示Master Server 名字 填写NBU master 主机名 回车 证书默认y

NBU客户端配置文件

cat /usr/openv/netbackup/bp.conf
SERVER = NBU master hosts
CLIENT_NAME = client
CONNECT_OPTIONS = localhost 0 0 2
DB_SCRIPT_PATH = /usr/NBMySQLAgent/mysql_backscript.sh ##mysql备份代理客户端备份脚本指定的路径不写该参数会报错(5449) The script is not approved for executionNBU 5449错误状态码 (5449) The script is not approved for execution.NBU 5449错误状态码

安装Linux NBU mysql备份代理客户端

ll -h | grep NBMySQLAgent_8.1.2.zip
unzip NBMySQLAgent_8.1.2
会得到三个目录
NBMySQLAgent_8.1.2_AMD64/ NBMySQLAgent_8.1.2_linuxR_x86/ NBMySQLAgent_8.1.2_linuxS_x86/
cd NBMySQLAgent_8.1.2_linuxR_x86/
cat README |grep NB
(Windows) NBMySQLAgent_8.1.2_AMD64/
(Linux RHEL) NBMySQLAgent_8.1.2_linuxR_x86/
(Linux SLES) NBMySQLAgent_8.1.2_linuxS_x86/
此环境是Redhat系列所以进到NBMySQLAgent_8.1.2_linuxR_x86/
ls
install LICENSE pkg.tar README
./install
一路y
cd /usr/NBMySQLAgent
ls
I18N_EN mysql_backscript.sh nbmysql nbmysql.conf nbmysql.log version.txt

NBUmysql备份代理客户端脚本

mysql_backscript.sh ###mysql备份代理客户端备份脚本win环境下cmd后缀
cat mysql_backscript.sh

#!/bin/sh

#bcpyrght
#***************************************************************************
#* $Copyright: Copyright (c) 2017 Veritas Technologies LLC. All rights reserved VT25-0977-2658-84-51-3 $ *
#***************************************************************************
#ecpyrght

#NOTE:This is sample script can be changed according to the environment

RETURN_STATUS=0

echo "Execute $CMD_LINE"
CMD_LINE="/usr/NBMySQLAgent/nbmysql -o backup"

echo "Execute $CMD_LINE"

su - root -c "$CMD_LINE"

RETURN_STATUS=$?

exit $RETURN_STATUS

NBUmysql备份代理配置文件

/usr/NBMySQLAgent/nbmysql.conf ###NBU mysql代理备份配置文件
cat nbmysql.conf | grep ^[A-Z]
DB_USER=root ###mysql数据库备份恢复权限用户
DB_PORT=3306 ###mysql数据库端口号
MYSQL_LIB_INSTALL_PATH=/usr/local/mysql/lib ###mysql安装的LIB路径
MASTER_SERVER_NAME=NBU master ###NBU master
POLICY_NAME=BK-DZPJ-DB-1day ###备份策略名称
SCHEDULE_NAME=BK-DZPJ-DB-1day ###备份计划表名称
CLIENT_NAME=client ###客户端主机名称
SNAPSHOT_SIZE=500MB ###快照大小
NBMYSQL_LOG_LEVEL=4 ###日志等级 1 – ERR, 2 – WARN, 3 – INFO, 4 – DEBUG
DB_SCRIPT_PATH =/usr/NBMySQLAgent/mysql_backscript.sh ###备份脚本
更改配置文件后重启服务
service netbackup stop
service netbackup start

NBU 创建备份任务