… 2.1 version of the tool does NOT have any features to disable the binary log; my experience has been that this is… binary logging at all. Are you using the 2.0 version of this tool? It was completely rewritten in version 2.1. Q: qw() as use of () is deprecated That sounds like you‘re using an old version of the tool. Q…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
…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…of are too simplistic. For example, doing replication through the InnoDB transaction log …state so that it could be used for read queries. This can be …
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
…). So what are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You can understand Vadim’s excitement when he announced this feature a few months ago. If you are using multiple storage… to up to date), or hope that it’s not often that you need to restore! Eventually this problem should be…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile*) are on the same logical volume, if not, you could potentially…for every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs after restoring the snapshot, …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… if you have any long running queries. If you‘re using only Innodb tables and do not need to synchronize binary log position with backup you can… query logs and error log while taking backup. You also can skip most of binary logs – however if some of your slaves are far behind you might…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
Backing up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After… mysqlbinlog utility is up and running. By default if you do not supply the binary log file, mysqlbinlog deletes and overwrites them all that… they are the same or not. For this purpose you can use rsync in “dry-run” mode. Please note MySQL 5.6 is not yet…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… actually says this, but not in the clearest way. It just says If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE … SELECT or INSERT … SELECT statements. If you use mysqladmin debug, you‘ll…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…. 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… reachable even with binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit… have been no degradation when replication is enabled. I have not checked in details why this could be the case but…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup…. You may not use sub-queries or any non-deterministic functions like NOW() or RAND(). HAVING clauses, ORDER BY clauses, etc, are not supported. You can…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… with Innodb even if you do not use transactions, but which are not existent with MyISAM. QA … MyISAM kills Innodb, such as copying binary tables between the servers. It is …not switch table to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging…
