… backups of the binary log files which could still lead to data loss depending on the interval you back them up. Recently in MySQL… to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog-backup.html ). This can be used as a foundation of our live binary log backups. The…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… a consistent backup of your MySQL databases – but did you know that you can now restore directly from a snapshot (and binary logs for… position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql> select…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… so-called “binary log” of events that modify data in the server. The binary log is a real limitation in MySQL. The binary log is necessary not only for replication, but for point-in-time recovery, too. Given a backup and the corresponding binary log…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… record binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need to point your MySQL Slaves…/backup 6) Copy data to backup. Normally you can skip slow query logs and error log while taking backup. You also can skip most of binary logs…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… setup a new slave with a 24-hour old backup, and apply the binary logs continuously until it catches up, you will be… using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You can understand Vadim’s excitement… restore! Eventually this problem should be lessened by a MySQL Server feature – parallel execution on slaves. Lets hope that…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… backup. I was testing high volume replication today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql… of contention issues in MySQL 5.0 rather than any NAS issues. This number was reachable even with binary log stored on NFS…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as… be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which could…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5… Master too. I’d take the final backup before upgrading and make sure to keep binary logs for some time, in case you…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… while recovering from backup. There are however some cases when you really do not need events in binary log – even for backup recovery, for… in advanced cases allowing replication to control what will be logged to binary log and so replicated. On the Slave you have more…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify…-master with slaves or if you want to backup one master, you need log_slave_updates[3] to be enabled. This is… in the binary-log of mysql 4 and the master position is increased… Step 6: the slave position on the active master (mysql 1…
