… side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let… slave with a 24-hour old backup, and apply the binary logs continuously until it catches up, you will be waiting almost… are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You can understand Vadim’s…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not… couple of percents per day. The solution MySQL offers – using binary log works in theory but it is not overly useful in… will take over 24 hours to cover month worth of binary logs… and quite typically you would have much higher update traffic…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 1 Comment
… people to tell you you just should use auto_increment_increment and auto_increment_offset and you would not have any conflicts, I… of sync. So back of our topic of auto_increment_increment and auto_increment_offset – besides being able to avoid some problems they… at that time). Sure you can find same information in binary logs but having it in the database too allows to speed…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… not read_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto-increment increment 4, offset 2…, is read_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto-increment increment 4, offset 2…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… DO INSERT INTO t VALUES(YEAR(CURDATE())); Binary Logs: First the event gets logged to the Binary Log: CREATE DEFINER=`msandbox`@`localhost` event year ON… incremental value is logged as an extra event just before the statement. MySQL uses the INSERT_ID variable to store that value. Binary Log…,1); Binary Log: The value 4 is inserted with the INSERT statement and the INSERT_ID is the next auto incremental value: #111214…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… either created, or last refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after… the binary logs brings the database up-to-date by replaying the changes. An MV is also like a snapshot. The incremental refresh… changes that have happened in the database, instead of replaying binary logs directly. Selecting a refresh method The refresh method you select…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
…output: The latest check point (for incremental): ’1319:813219999′ >> log scanned up to (1319 813701532) Transaction log of lsn (1318 3034677302) to (1319… incremental you can read on our draft page http://www.percona.com/docs/wiki/percona-xtrabackup:spec:incremental You can download current binaries…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master_log_pos: 214652 If you select from … change log, delete rows and then insert some more of them: mysql> create table > test.demo ( > c1 int auto_increment …
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) ) ENGINE=InnoDB; Query OK, 1 row affected… in the binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64-output=decode-rows -v > decoded.log Examine the decoded binary log with…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… different combination. My couple cents: you may use innodb_flush_log_at_trx_commit=2/sync_binlog=0 in single node… of incremental changes apply it will become more important. As to ability to apply only lost transactions: in fact Galera uses binary log… point it should be possible to have support of XtraBackup incremental schema ( in this case we need to have relation between…
