innodb在线备份的新方法

在google code的google-mysql-tools公布了一个innodb在线备份的新方法：在不关闭mysql服务器的情况下，可以禁止掉所有的innodb文件的写，但不阻塞读,这个时候可以利用操作系统的文件拷贝命令进行在线备份。要实现这个功能，需要打一个google的mysql开发团队弄出的一个patch.

下面是这个patch的详细介绍：

InnodbFreeze   
Freeze Innodb file system activity
Commands
set global innodb_disallow_writes=ON
set global innodb_disallow_writes=OFF
Purpose
Theseenable and disable all Innodb file system activity except for reads. Ifyou want to take a database backup without stopping the server and youdon't use LVM, ZFS or some other storage software that providessnapshots, then you can use this to halt all destructive file systemactivity from InnoDB and then backup the InnoDB data files. Note thatit is not sufficient to run FLUSH TABLES WITH READ LOCK as there arebackground IO threads used by InnoDB that may still do IO.

5.0.37 Patch

从一个网友的回复中，看到基本上可以达到相同效果的另外一种方法：

Any chance that you canaccomplish a similar mechanism by setting innodb_max_dirty_pages_pct tozero and then waiting for dirty buffers to equal zero... thenperforming the snapshot (of course with a READ LOCK) on all the tables.

I generally think this patch is a bit more elegant though.

Kevin Burton (spinn3r.com)

总的来说，mysql的备份与ORACLE的备份相比，还有许多需要去改进的地方。google自己的mysql开发团队一直都在努力改变着mysql的代码，可以根据自己的需求去定制mysql，什么时候我们也可以这样做呢？

--EOF--