~mysqlatfacebook/mysqlatfacebook/5.1

Viewing all changes in revision 3415.

  • Committer: Mark Callaghan
  • Date: 2010-03-02 18:10:55 UTC
  • Revision ID: mdcallag@gmail.com-20100302181055-onkxsqhogdi42a6v
Provide fast and non-blocking alternative to FLUSH TABLES WITH READ LOCK for hot backup.
See mysqlha.blogspot.com/2009/10/be-careful-with-flush-tables-with-read.html for context.
This adds START TRANSACTION WITH CONSISTENT INNODB SNAPSHOT that starts an Innodb transaction
and returns the master binlog filename and offset. When this is used for backups, replication
should be restarted at those return values. The new START command returns 1 row with 2 columns
(File, Position) on success.

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: