…: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for… based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while… to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers on…: take a backup from the master and store the value of gtid_executed restore the backup on the slave and set gtid_purged… of how to take a backup from the master and restore it on the slave to set up a new replication server…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… salaries table: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries DISCARD TABLESPACE; Copy the salaries.ibd files from the backup to the database data directory: # cp /tmp/2012-01-22_14-13-20/employees/salaries.ibd /var/lib/mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… is the more likely it is to run on wide set of MySQL versions. Safe Approach So what if you actually care… with different MySQL version, unless you have very detailed automated QA. So what you can do is get the backup of the… new MySQL version you want to promote it to the master and upgrade Master too. I’d take the final backup before…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e.g… of frustrating encounters with vendors who sell backup products with some kind of agent for MySQL backup. I am almost never able to… a good thing. In reality, a proprietary, secret backup black-box is unacceptable. MySQL backups are complex and difficult to get right. It…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and… downtime for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots that don’t…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1…, RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity on the other tenants sharing physical hardware with… which just a bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… the bug #711166 introduced a regression that caused individual partition backups to fail when used with –include option in innobackupex or… Kopytov). innobackupex didn’t add the file-per-table setting for table-independent backups. Fixed by making XtraBackup auto-enable innodb_file… for temporary files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error reporting for unrecognized server…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… (again as long as you use a 1-byte character set for CHAR). Here CHARs will be more flexible and can… Performance MySQL 3rd edition is a very good book. The online documentation is also a valuable resource. Q: Is any logical backup facility provided by Percona like mysqldump? No, on the backup side, we’re focusing on XtraBackup, which performs raw backups.
