… that you can now restore directly from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you… from the time of the snapshots until you discover the problem, so it is really important that you have your binary logs on… 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… 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 position, you can replay the binary log…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… have binary logs on NFS volume – binary logs is exactly the thing you want to survive the server crash – using them you can do point in time recovery… something which requires a network roundtrip when the binary log is written at the same time as slave-feeding thread is reading it…
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 restoring a… foundation of our live binary log backups. The wrapper script below will connect to the remote server specified in the config and ensure…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… sure the logs on the master go far back so you can restore from several of backup generations and do point in time recovery. Timing recovery is also important. Especially for write intensive environments it may take many days to catchup from weekly backups by binary logs…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… your recovery speed will depend on number of Innodb tables you have, as well as many other operations, so beware. Binary log corruption – Binary log…’re just planning on using binary log for point in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log, but at performance penalty…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… somewhat similar functionality works as expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0… your MyISAM system tables) and use this position to point to proper location on the master, or later use for point in time recovery using binary log.
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… replicate binary logs using DRBD so if master node fails you have not lost transactions – when you can use such logs to do point in time recovery or to catch up to last few not committed transactions on the slave. We should spend some time…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… of applying binary logs (for example point in time recovery from backup) replication capacity of 1 will mean you can reply 1 hour worth of binary logs within… up. Measuring times for each binary log separately should give you these numbers. The less intrusive process which can be done in production (especially…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… data on replicas (and after point-in-time recovery) when you do that. Unfortunately, the manual isn’t that helpful in this instance — it doesn… replication master—or on any MySQL server where binary logging is in use—ensures that the binary log does not get out of sync compared…
