… a single file Restoring a single schema or rolling forward a single schema to a point in …mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “mysqlbinlog…, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available …
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… a backup and the corresponding binary log position, you can replay the binary log and roll forward the state of your server to a desired point in time. But enabling the binary log reduces MySQL‘s performance dramatically. It is not the logging itself that’s the problem — writing the log is usually…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be… this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message describes… method of recovery from backup – because you would need relay logs to roll forward, and they are corrupted. You can either re-clone…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… binary log on the Master which is not only helpful for replication needs but also if you ever need to do roll forward recovery while recovering from backup. There are however some cases when you really do not need events in binary log…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… a method for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A… includes this capability today. Because Flexviews can move database objects forward in time synchronously with each other to specific points in… read fully log based supports all DML supports all aggregate functions supports join supports NULL values supports simple projection only rolls forward in…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is not overly useful… take over 24 hours to cover month worth of binary logs… and quite typically you would have much higher update traffic… or if dealing with read-only compressed backup create the roll-forward recovery log, which also can be easily compressed. What tool would…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… could mean all sorts of different things: Versions later than MySQL 5.0.33 are not frequently used True many distributions… be so slow restoring even week old backup and running roll forward recovery using binary log can be a lot faster.
