MySQL备份和同步时使用LVM_MySQL

来源：动视网责编：小采时间：2020-11-09 17:47:03

MySQL备份和同步时使用LVM_MySQL

MySQL备份和同步时使用LVM_MySQL:If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would

推荐度：

点击下载本文 文档为doc格式

导读MySQL备份和同步时使用LVM_MySQL:If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would

　　If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would work as well.

　　如果有人问我关于MySQL备份的建议，我会先问操作系统是否安装了LVM或者其他相似功能的软件。Solaris下的Veritas文件系统也可以做到同样的功能。大多数SAN系统也可以。

　　What is really needed is ability to create atomic snapshot of the volume, which can be later mounted same as original file system

　　Why snapshot based MySQL backups are great ?

　　为什么基于MySQL快照的备份很好？

　　There are number of reasons:

　　原因如下几点：

　　Almost Hot backup In most cases you can perform this type of backup while your application is running. No need to shut down server, make it read only or anything like it.

　　几乎是热备在大多数情况下，可以在应用程序仍在运行的时候执行备份。无需关机，只需设置为只读或者类似只读的限制。

　　Support for all local disk based storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines.

　　支持所有基于本地磁盘的存储引擎它支持MyISAM, Innodb, BDB，还支持 Solid, PrimeXT 和 Falcon。

　　Fast Backup You simply do file copy in the binary form so it is hard to beat in speed.

　　快速备份只需拷贝二进制格式的文件，在速度方面无以匹敌。

　　Low Overhead It is simply file copy so overhead to the server is minimal.

　　低开销只是文件拷贝，因此对服务器的开销很细微。

　　Easy to Integrate Do you want to compress backup ? Backup it to tape, FTP or any network backup software - it is easy as you just need to copy files.

　　容易保持完整性想要压缩备份文件吗？把它们备份到磁带上，FTP或者网络备份软件 -- 十分简单，因为只需要拷贝文件即可。

　　Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on this later.

　　快速恢复恢复的时间和标准的MySQL崩溃恢复或数据拷贝回去那么快，甚至可能更快，将来会更快。

　　Free No extra commercial tools as Innodb Hot Backup are required to perform backup.

　　免费无需额外的商业软件，只需Innodb热备工具来执行备份。

　　Are there any downsides ?