… a backup or the backup restore process doesn’t work. How…With the data in our hands the last step is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data…binary backup. Just use constraint_parser without the -D option (deleted) and you will recover all the data…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… understanding of the MySQL binary log format or the slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be… others speak on topics from Handler Socket to Programmatic Queries. With 45 sessions not including the keynotes you are bound to…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… MySQL for binary backups. Strong Points: It can restore an entire server very fast. Often the limiter of how fast this can be restored…/tricks to restore data in a future blog post. Tips/Tricks: run with –kill-long-queries to avoid nasty problems with “FLUSH TABLES WITH READ…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…about the system and how data was lost: MySQL had a dedicated partition… data so no data was written to file system. Mind however that restoring… number 837492636 to it’s binary representation 0x31EB1F9C and ran “bgrep 31EB1F9C /…part of percona recovery toolset, with some additional converters so we…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially a ‘snapshot’ of the data at the time of the backup, upon restoration… id. Each view has an identifier which can be obtained with flexviews.get_id(‘schema’,'table’). The second parameter reflects the…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… TABLES WITH READ LOCK may take quite a while to complete on systems with long queries. Problems with data …MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… backup you will need to restore slaves as well and skip binary logs in your backup process….
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… syncing binary log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5… are other problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
…on each). The slave machine barely keeps up with the master (at 90% capacity during peak, …data files, it shouldn’t take much more than 30 minutes to restore 100GB (50MB/s), but to replay one day of binary… you need to restore! Eventually this problem should be lessened by a MySQL Server feature – …
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… with a certified MySQL consultant from Sun – he agreed with our cons and with how we had tuned our system. > As for restores, selective restoring from binary… what you need when maybe a critical table of data needs to be restored quickly and your ops is down at a… of possibility that we would have to restore a table from tape to deal with some kind of unknown situation. InnoDB was…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… removed in MySQL 5.0 during XA implementation though the code which prints the data back … with real position on the master anymore. I hope Innodb team will find a way to restore… during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file…
