…: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…-data-201202230157′ using a script* I put together to make sure I have a consistent snapshot of the MySQL data files. Restoring snapshot…` /* generated by server */ … Now, let’s restore our data from the snapshot, under the hood restore is really a “rollback” to the snapshot… table is restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.05 sec) Success! Your salaries data is…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…. New features include: Backup and restore of LRU dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give excellent performance without a lengthy “warm…=2′ will create 4 IO threads that will read the data and pipe it to 2 compression threads. New streaming format…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… copying, it was required to uncompress the entire backup to restore a single table). Percona XtraBackup now supports streaming incremental backups… done by the xtrabackup binary which calculated deltas by scanning data files. Which meant those two feature were mutually exclusive, i…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… recovery as on ability to restore data from backup which can be far from being enough to restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore process you better look at the whole process which is required to bring system to the working state, including data…
Post: Upcoming webinar on Data Recovery for MySQL
April 6, 2011 By 5 Comments
… will give you a walk through guide on how to restore your data after physical or logical failure, using practical examples to… for recovery (prerequisites) * Preparing your data * Identifying the structure and state of tables * Retrieving data * Restoring from recovered data During this Webinar the Percona…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… portion of your data recovered. While this is true if the goal is to restore a part of the data set, when it’s time to do a full data restore, more tables means longer restore times. Deciding to create a new table for a part of the data set is…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
…/docs/wiki/percona-xtradb:patch:innodb_lru_dump_restore (Yasufumi names it LRU dump/restore, because he thinks about buffer pool as… /*!XTRA_LRU_DUMP*/; and to restore select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_RESTORE*/; it will create/read file ib… buffer_pool, restarted mysqld, restored buffer_pool ( it took about 4 min to load 26GB worth of data), and run (xtradb warm…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… it will be quick to rearrange their database or even restore from backup. You need Patience simply because things are going…, Batch Jobs can take quite similar time. Binary Backup and restore will be faster but it can still take hours especially… as results you’ve gotten for small data set may not apply to large data set so you need to re-test…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… February 10, We will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent… like InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets, and how to… safely using Tungsten Replicator with parallel apply. Bring your big data questions to this live webcast as we tour the cutting…
