NetBackup For MySQL安裝配置介紹

SymantecNetBackup?ForMySQL1NetBackupForMySQLAgendaNetBackupForMySQL2MYSQL

BackupSolutionOverview1NetBackupForMySQL2KnownIssues3MySQLBackupSolutionOverview3NetBackupForMySQLmysqldumpNetBackupForMySQL4mysqldump是采用SQL級(jí)別的備份機(jī)制，它將數(shù)據(jù)表導(dǎo)成SQL腳本文件，在不同的MySQL版本之間升級(jí)時(shí)相對(duì)比較合適，這也是最常用的備份方法。mysqldump在備份時(shí)根據(jù)數(shù)據(jù)庫(kù)引擎類型會(huì)有不同的處理方式：默認(rèn)是鎖定全部表如果是MyISAM表則可以選擇只鎖定當(dāng)前導(dǎo)出的數(shù)據(jù)表如果是InnoDB表則可以結(jié)合binlog只在最開始時(shí)進(jìn)行一個(gè)鎖表的操作，隨后業(yè)務(wù)可以繼續(xù)進(jìn)行下去

LVMSnapShotNetBackupForMySQL5LVMSnapShot并不能保證數(shù)據(jù)的一致性，會(huì)存在塊斷裂的問題需要類似OracleBeginbackup的命令（原理不同），把內(nèi)存中的數(shù)據(jù)都刷新到磁盤中，同時(shí)鎖定數(shù)據(jù)表，以保證拷貝過(guò)程中不會(huì)有新的數(shù)據(jù)寫入：FLUSHTABLESWITHREADLOCK;針對(duì)InnoDB引擎，還需要考慮日志文件，即ib_logfile*文件是否包括在快照中MySQLEnterpriseBackupNetBackupForMySQL6

支持多種備份方式：全量備份，增量備份，部分備份及InnoDB在線備份支持MySQL5.0及以上版本在MySQLEnterpriseBackup3.6及以上版本開始，支持影像備份MySQL數(shù)據(jù)庫(kù)

至MMS（MediaManagementSoftware)產(chǎn)品中，也意味著可以備份至Netbackup中（使用OracleMMSlibrary）NetBackupForMySQL7NetbackupForMySQLZmandaRecoveryManagerNetBackupForMySQL8

ZRM是獨(dú)立的備份軟件，支持調(diào)用MySQL的備份工具備份至ZRM（如mysqldump,mysqlhotcopy,LVMsnapshot,VxFSsnapshot等）ZRM對(duì)于中國(guó)客戶來(lái)說(shuō)涉及備份軟件采購(gòu)問題，國(guó)內(nèi)當(dāng)前很難找到代理商

Symantec本身并不支持MySQL，僅提供接口給ZRM，與ZRM結(jié)合備份MySQL，需要完善的功能其實(shí)只需要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確認(rèn)數(shù)據(jù)庫(kù)備份賬戶有足夠的權(quán)限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恢復(fù)至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只有針對(duì)InnoDB引擎才不會(huì)鎖表，進(jìn)行真正的在線備份，其他數(shù)據(jù)庫(kù)表都會(huì)鎖表，限制訪問

Eneterprisebackup可以支持沒有binlog的情況下對(duì)InnoDB進(jìn)行備份，但是需要注意InnoDB是沒有archivelog的，所以一旦日志覆蓋，則備份會(huì)提示所需的日志被覆蓋，隨后備份會(huì)Hang住。因此需要合理規(guī)劃InnoDB的redologsize。但是如果有binlog，則Eneterprisebackup會(huì)將需要的binlog備份，則不會(huì)有此風(fēng)險(xiǎn)MySQLEnterpriseBackup與Netbackup結(jié)合缺陷NetBackupForMySQL23

只支持image備份。增量備份，日志備份，單個(gè)表及表空間備份無(wú)法與image備份結(jié)合，必須先備份到backup--dir以后采用文件備份方式到Netbackup中backupdir在備份完成后會(huì)殘留文件，必須將文件刪除后才能重復(fù)在備份命令中指定相同的backupdir，所以備份腳本需要注意添加這部分操作backupset名字通過(guò)備份命令中image=sbt:bkpsbtNB指定