…. Does this mean Galera does not write anything like the binary log? Since they have global transaction id’s, a disconnected slave… certain id. Of course, xtrabackup incremental backup is actually doing the same thing, just from innodb log… For performance penalty, it is… the proper comparison is single node with both innodb_flush_log_at_trx_commit=1 and sync_binlog=1, and two…
Comment: Feature preview: Compact backups in Percona XtraBackup
February 19, 2013 By 11 Comments
@ Marc castrovinci 40 min for 150GB, it seems to me you’re doing a full backup. I thought incremental backup would be backing up the binary logs?
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5…_data_length: 0 Index_length: 9047113728 Data_free: 6291456 Auto_increment: NULL Create_time: 2012-12-31 16:24:54 Update…
Post: Replication of the NOW() function (also, time travel)
November 28, 2012 By 6 Comments
… special events in the binary log which set the TIMESTAMP and INSERT_ID (which is used for AUTO_INCREMENT replication) to the correct…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… other problems spotted and in the meanwhile we go over binary logs for the last month to see how frequently this functionality… instances, and only one of them into table with AUTO_INCREMENT column (and so affected by this bug). It was easy…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… works well when all you want is to remove auto_increment or change ENUM values. When it comes to changes that… logical replication if tables on master and replica are different. binary log should be a good place to look for these. OK…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…passwordoption, innobackupex would log that password in plain text in the log. With … (including –help) erroneously mentioned an –ibbackup-binary command line option when the …: #859546 (Lachlan Mulcahy) When the –incremental and –incremental-lsn options were specified together, innobackupexwould…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…and –incremental-basedir is ignored. (Vadim Tkachenko) Added option –incremental-dir to innobackupex. This option is passed directly to the xtrabackup binary. (Vadim…version string in innobackupex. (Baron Schwartz) Bug #672384 – When no log files can be found in the backup directory while executing…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…_actor_last_name` (`last_name`) ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8; /*!40101 SET character_set_… grep -r “PENELOPEGUINESS” pages-1345220873/FIL_PAGE_INDEX/ Binary file pages-1345220873/FIL_PAGE_INDEX/0… In that case we can scan the redo log: # ./s_tables /var/lib/mysql/ib_logfile1…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…auto increment values needed or if we get behavior change by having potential “holes” when auto increment …if not we should test them and make binaries with them available. With current MySQL 5….performance such as multiple purge threads or parallel log recovery features, which he however needs to …
