… step-by-step guide on how to create a new GTID based…logs to the backup: # innobackupex –apply-log /destination/2013-05-07_08-33-33/ 3- Move the backup to…mysql‘s datadir. Follow the usual restore procedure, for example remember to change the permissions to mysql:mysql. 4- Start the new slave from…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log rotation events… We benchmarked with slow query logs captured from our production systems. We restored a production database backup to our test database so that our…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… with the MySQL versions and it’s easy to shoot yourself in the foot if you use it incorrectly. So how do you… the relay log files. This looks great, but does it ensure the replica is disconnected from its master? Let’s try: mysql> stop… restored, which makes disconnecting the replica impossible. And again, if you restart replication, it will read events from the first available binary log…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… of MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to create/restore a… the log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from…MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to create/restore…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…and how it works internally because there are many documents about that: http://dev.mysql….from a master using GTID. How to set up a new slave The first thing that we need to know is that now Binary Logs…How to restore a slave in a good and slow way The good way is mysqldump again. We take a dump from…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to restore a ibd tablespace: The ibd file must be from…/tmp/ Then apply the logs to get a consistent backup:…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
…restoring replication while maintaining data integrity can be a daunting task. This talk will show you how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many types of …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to restore…restores Strategies on retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…to restore data from backup which can be far from being enough to restore the whole system to…MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary logs…
