MySQL备份与恢复

MySQLfi[e-mail]()(,)()MySQL&MySQLINNODBMySQLINNODBRecoveryPointObjective(RPO)RecoveryPointObjective(RPO)binlogINNODBINNODBlvmINNODBlvmLVMABCDABCDBLVMsnapshotFLUSHTABLESFLUSHTABLESWITHREADLOCKCreatethesnapshop(lvcreate-s)(SHOWMASTER/SLAVESTATUS)UNLOCKTABLESMountsnapshot,performbackupUnmountanddiscardthesnapshot(lvremove)mysqldumpmysqlhotcopyLVMsnapshots/ZFSsnapshotsInnoDBHotBackup/XtrabackupZRMforMySQLIdeasQuestionsSuggestions