….schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema... the same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with… from a remote server. This can allow for more targeted restores, easier comparison, and allow remote users to compare on a…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… server which is flipped into service if the active master server has an issue. At Groupon, our standard MySQL database configuration follows this… from our production systems. We restored a production database backup to our test database so that our test database was consistent before applying the…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the… to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During the copy back stage (restore) it…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… and testing questions, we have customers backing up and restoring MySQL 5.6 databases in standard configuration successfully with the current version. The…’s additions and optimizations. MySQL 5.6 rolls many improvements which previously existed only in Percona Server into MySQL 5.6 mainline which…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… too high. But if you later restore enforcement, MySQL does not immediately scan all your data… mysql> INSERT INTO Bar (ID,X,Y) VALUES (21,333,444); mysql> SET FOREIGN_KEY_CHECKS=0; mysql> INSERT INTO …track our database design manually, so we can use the same SQL queries for quality control: mysql>…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… conditions. Percona XtraBackup for MySQL for binary backups. Strong Points: It can restore an entire server … the available bandwidth and should be factored into your restore time. Problems: You can’t rely…: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours mysqldump in parallel, 7 databases at a time : 3.5 hours I have performed 3 full restorations…Dump and Parallel Restore sugin SELECT INTO and LOAD DATA …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…or absence of values. You can put these into the database in a little meta-table. Then your… up, and restore. And the partitioning functionality is not done yet and not fully integrated into the server, so…that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…systems. Instead of looking just at data restore process you better look at the … example – a master with 1TB of database size replicating to 50 servers in … of soft crash. Unless you got into one of these rare cases slave …(or running out of sync) due to MySQL bugs or wrong use. Interesting enough …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…upon restoration the backup may be ‘out of date’ since changes to the database may…db.schema … AS SELECT” and/or “INSERT INTO db.schema … AS SELECT” statements from …155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ;…
