SymantecNetBackup?ForMySQL1NetBackupForMySQLAgendaNetBackupForMySQL2MYSQL

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

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

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

至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確認數(shù)據(jù)庫備份賬戶有足夠的權限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引擎才不會鎖表，進行真正的在線備份，其他數(shù)據(jù)庫表都會鎖表，限制訪問

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

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