On 1/25/2011 09:00, Robinson, Eric wrote:
> ...
>
> I'm starting to worry that you may be right. I know FLUSH TABLES WITH
> READ LOCK does not work as expected with InnoDB, but is there really no
> way to put InnoDB into a state where all changes have been flushed to
> disk and it is safe to rsync the directory? Is stopping the service
> really the only way? (And even if I stop the service, is rsync totally
> safe with InnoDB?)
>
You need to quiesce the InnoDb background threads. One technique is
mentioned here:
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
Look for the section talking about "clean" backups.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
