… while recovering from backup. There are however some cases when you really do not need events in binary log – even for backup recovery, for… manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege… in advanced cases allowing replication to control what will be logged to binary log and so replicated. On the Slave you have more…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… mean binary logs, slow query log, general query log etc, if they get any serious traffic. You can use other techniques to get consistent binary logs in the backup and you do not want query log and general logs anyway. However DO place Innodb Log Files on…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… statements from that transaction are written to the binary log. They are called binary log events. A binary log event contains the server-id where it…-master with slaves or if you want to backup one master, you need log_slave_updates[3] to be enabled. This is…-id on the binary log, and the slaves (included the other master) will replicate them… and write them in their binary log… and then…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially a… the backup may be ‘out of date’ since changes to the database may have happened since the backup was taken. Replaying the binary logs… changes that have happened in the database, instead of replaying binary logs directly. Selecting a refresh method The refresh method you select…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… top level on MySQL side, such as .frm files and binary log files has to be synchronized with storage engine transactions which… we’re up for a lot of surprises. Backup Cross storage engine backup is a pain because they are so different. Some… pain in replication. To start we have to write second binary log file when all transaction engines have their own ! Quality Assurance…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… and a bit. We had to recover data using query log, corrupted binary log and dig into MyISAM tables. You would ask who… backup strategy for some. Sometimes backups stop working in others they are never setup, yet another nice case is weekly backups with no binary log enabled when managed hosting support would happily point to the backups but they are too…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… more than one fsync() for the log because it internally implements XA to synchronize with binary log and also if you’re looking for maximal data consistency (as SAN users often are) you better have binary log flushed… with low overhead allowing to take a backups conveniently. Also if you keep last uncompressed backup on SAN (or last snapshot) you…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… really wrong with one of them, there would be a backup on the other. The worst-case scenario happened, and a… usual process of matching up binary log filenames and byte offsets. We had to look in A’s binary logs, find some distinctive pattern of updates, and look in C’s binary logs to find the same…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output: The latest check point (for incremental): ’1319:813219999′ >> log scanned…/docs/wiki/percona-xtrabackup:spec:incremental You can download current binaries RPM for RHEL4 and RHEL5 (compatible with CentOS also), DEB…
Post: Recovering from a bad UPDATE statement
October 19, 2012 By 5 Comments
… you were using the Binary Logging format of ROW: # at 665 #121019 16:12:34 server id 1 end_log_pos 733 Query… we examine the binary log (still in binlog_format=ROW): # at 854 #121019 16:13:38 server id 1 end_log_pos 922… think. Take a database backup if you can. Identify which binary log has the offending UPDATE statement. Parse the binary log using mysqlbinlog -vv and…
