NetBackup For MySQL安装配置介绍

SymantecNetBackup™ForMySQL1NetBackupForMySQLAgendaNetBackupForMySQL2MYSQL

BackupSolutionOverview1NetBackupForMySQL2KnownIssues3MySQLBackupSolutionOverview3NetBackupForMySQLmysqldumpNetBackupForMySQL4mysqldump是采用SQL级别的备份机制，它将数据表导成SQL脚本文件，在不同的MySQL版本之间升级时相对比较合适，这也是最常用的备份方法。mysqldump在备份时根据数据库引擎类型会有不同的处理方式：默认是锁定全部表如果是MyISAM表则可以选择只锁定当前导出的数据表如果是InnoDB表则可以结合binlog只在最开始时进行一个锁表的操作，随后业务可以继续进行下去

LVMSnapShotNetBackupForMySQL5LVMSnapShot并不能保证数据的一致性，会存在块断裂的问题需要类似OracleBeginbackup的命令（原理不同），把内存中的数据都刷新到磁盘中，同时锁定数据表，以保证拷贝过程中不会有新的数据写入：FLUSHTABLESWITHREADLOCK;针对InnoDB引擎，还需要考虑日志文件，即ib_logfile*文件是否包括在快照中MySQLEnterpriseBackupNetBackupForMySQL6

支持多种备份方式：全量备份，增量备份，部分备份及InnoDB在线备份支持MySQL5.0及以上版本在MySQLEnterpriseBackup3.6及以上版本开始，支持影像备份MySQL数据库

至MMS（MediaManagementSoftware)产品中，也意味着可以备份至Netbackup中（使用OracleMMSlibrary）NetBackupForMySQL7NetbackupForMySQLZmandaRecoveryManagerNetBackupForMySQL8

ZRM是独立的备份软件，支持调用MySQL的备份工具备份至ZRM（如mysqldump,mysqlhotcopy,LVMsnapshot,VxFSsnapshot等）ZRM对于中国客户来说涉及备份软件采购问题，国内当前很难找到代理商

Symantec本身并不支持MySQL，仅提供接口给ZRM，与ZRM结合备份MySQL，需要完善的功能其实只需要ZRM即可MySQLEnterpriseBackupnotSupportbySymantecNetBackupForMySQL9OracletestbackupMysqltoNetbackup7.xWellNetBackupForMySQL10HowtodownloadMySQLEnterpriseBackupNetBackupForMySQL11Metalink:SearchforMYSQL

OraclesoftwareDeliveryCloudInstallMySQLEnterpriseBackupNetBackupForMySQL12InstallMySQLEnterpriseBackuprpm#rpm-ivhmeb-3.8.1-rhel5.x86_64.rpmPreparing...###########################################[100%]

1:meb###########################################[100%]#pwd/opt/mysql/meb-3.8/bin#lsibbackupinnobackupmysqlbackupUncompressMySQLEnterpriseBackupgzfile#tar–xzvfmeb-3.8.1-rhel5-x86-64bit.tar.gz#pwd/meb-3.8.1-rhel5-x86-64bit/binConfigureMySQLBackupPolicyNetBackupForMySQL13PrepareforMySQLEnterpriseBackupNetBackupForMySQL14

检查配置文件ps-ef|grep-imysqldgl_uspad854577750Aug02?00:39:09/usr/sbin/mysqld--defaults-file=/etc/myconf/gl_fCheck/etc/myconf/gl_f#cat/etc/myconf/gl_f[mysqld]port=61010socket=/etc/mysock/gl_uspad.sockdatadir=/local/gl_uspad确认数据库备份账户有足够的权限BackupMySQLdatabasetoNetbackupNetBackupForMySQL15#./mysqlbackup--port=61010--protocol=tcp--no-connect--backup-image=sbt:bkpsbtNB--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64--sbt-environment="NB_ORA_SERV=SUSE07,NB_ORA_CLIENT=SUSE07,NB_ORA_POLICY=mysql_test"--datadir=/local/gl_uspad--backup-dir=/local/nbumysqlbackup-to-imagemysqlbackup:INFO:sbt-environment:'NB_ORA_SERV=SUSE07,NB_ORA_CLIENT=SUSE07,NB_ORA_POLICY=mysql_test'IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully.Attheendofasuccessful'backup-to-image'runmysqlbackupprints"mysqlbackupcompletedOK!".BackupImagePath=bkpsbtNBmysqlbackup:INFO:Uniquegeneratedbackupidforthisis13772493266295905BackupJobNetBackupForMySQL16RestorebackupimagefromNetbackuptobackupdirNetBackupForMySQL17先要将image恢复至backupdir#./mysqlbackup--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64--backup-dir=/local/nbumysql--backup-image=sbt:bkpsbtNBimage-to-backup-dirMySQLEnterpriseBackupversion3.8.1[2013/01/28]Copyright(c)2003,2012,Oracleand/oritsaffiliates.AllRightsReserved.mysqlbackup:INFO:Startingwithfollowingcommandline..../mysqlbackup--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64--backup-dir=/local/nbumysql--backup-image=sbt:bkpsbtNBimage-to-backup-dirIMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully.Attheendofasuccessful'image-to-backup-dir'runmysqlbackupprints"mysqlbackupcompletedOK!".RestoreJobNetBackupForMySQL18ApplylogtodatafileNetBackupForMySQL19#mysqlbackup--backup-dir=/local/nbumysql/apply-logmysqlbackup:INFO:Startingwithfollowingcommandline...mysqlbackup--backup-dir=/local/nbumysql/apply-logmysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization.mysqlbackup:INFO:Creating14bufferseachofsize65536.13082317:03:28mysqlbackup:INFO:Apply-logoperationstartswithfollowingthreads1read-threads1process-threads13082317:03:28mysqlbackup:INFO:ibbackup_logfile'screationparameters:startlsn142986015744,endlsn142986019145,startcheckpoint142986016019.Stopdatabase&restoredatabaseNetBackupForMySQL20#mysqladmin-uroot-pshutdown#mysqlbackup--defaults-file=/etc/myconf/gl_f--no-connect--backup-dir=/local/nbumysqlcopy-backmysqlbackup:INFO:Usesposix_fadvise()forperformanceoptimization.mysqlbackup:INFO:Creating14bufferseachofsize16777216.13082317:06:18mysqlbackup:INFO:Copy-backoperationstartswithfollowingthreads1read-threads1write-threads13082317:06:18mysqlbackup:INFO:Copying/local/nbumysql/datadir/ibdata1.13082317:11:25mysqlbackup:INFO:Copyingthelogfile'ib_logfile0'mysqlbackup:ProgressinMB:1560013082317:11:25mysqlbackup:INFO:Copyingthelogfile'ib_logfile1'mysqlbackup:ProgressinMB:1580013082317:11:26mysqlbackup:INFO:Copy-backoperationcompletedsuccessfully.13082317:11:26mysqlbackup:INFO:Finishedcopyingbackupfilesto'/local/gl_uspad'NetBackupForMySQL21KnownIssuesMySQLEnterpriseBackup缺陷NetBackupForMySQL22Eneterprisebackup只有针对InnoDB引擎才不会锁表，进行真正的在线备份，其他数据库表都会锁表，限制访问

Eneterprisebackup可以支持没有binlog的情况下对InnoDB进行备份，但是需要注意InnoDB是没有archivelog的，所以一旦日志覆盖，则备份会提示所需的日志被覆盖，随后备份会Hang住。因此需要合理规划InnoDB的redologsize。但是如果有binlog，则Eneterprisebackup会将需要的binlog备份，则不会有此风险MySQLEnterpriseBackup与Netbackup结合缺陷NetBackupForMySQL23

只支持image备份。增量备份，日志备份，单个表及表空间备份无法与image备份结合，必须先备份到backup--dir以后采用文件备份方式到Netbackup中backupdir在备份完成后会残留文件，必须将文件删除后才能重复在备份命令中指定相同的backupdir，所以备份脚本需要注意添加这部分操作backupset名字通过备份命令中image=sbt:bkpsbtNB指定