… of having binary logs which are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering… you add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log filters are…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the redo-logs to ensure that all transactions are also captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace and voila, you have a consistent binary backup at a…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… can now restore directly from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me… every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs after restoring the snapshot, I… and skipping the DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
…. The binary log is necessary not only for replication, but for point-in-time recovery, too. Given a backup and the corresponding binary log position, you can replay the binary log and roll forward the…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After… addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman… and running. By default if you do not supply the binary log file, mysqlbinlog deletes and overwrites them all that is undesired…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… such setup. There are good reasons to have binary logs on NFS volume – binary logs is exactly the thing you want to survive the server crash – using them you can do point in time recovery from… reachable even with binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… recovery. Timing recovery is also important. Especially for write intensive environments it may take many days to catchup from weekly backups by binary logs… as shortcut) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… your recovery speed will depend on number of Innodb tables you have, as well as many other operations, so beware. Binary log corruption – Binary log… planning on using binary log for point in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log, but at performance…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… first log file name in binary log index file” error message Looking at the Master for this slave I could see its binary log files going only to about 2000, so the binary log file mentioned did not ever exist… which restores this information and uses it on slave crash recovery.
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted… also can’t use classical method of recovery from backup – because you would need relay logs to roll forward, and they are…
