…only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB…now avoids loading non-relevant tablespaces when partial backup is being taken which speeds up the backup… still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage…. now avoids loading non-relevant tablespaces when partial backup is being taken which speeds up the backup … would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…anything you find in standard async MySQL replication. It is my belief…should be taken for applications to avoid using Donor/Desynced nodes, particularly… “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE”, in which… other maintenance operation (like a backup) doesn’t inadvertently cause flow …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…Tricks: run with –kill-long-queries to avoid nasty problems with “FLUSH TABLES WITH READ LOCK” –compress, compresses tables per file …for MySQL backup systems for future posts Detailed strategies for different types of restores Strategies on retention dailies weeklies, long term backups …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup…avoid. Let’s now see what exactly you need to do to perform backup of MySQL…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he… backup system to avoid this global lock. There is no reason to take a lock at all for backing up only InnoDB data. Completely lock…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…’t really indicate problems. To avoid this problem as much as … finishing, sometimes due to the backup script failing before completion. Additionally, …. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists… or close tables can indicate LOCK_open contention. Replication is delayed …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… user. Now PBXT does acquire locks for 2 reasons: to support SELECT FOR UPDATE, and to avoid optimistic locking errors. This makes PBXT… does online backup work in PBXT, and is incremental backup possible? A recent version of PBXT (1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…-phase pass over the MySQL datadir with rsync (first without a write lock and then with the write lock), we dramatically reduce the… wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking place… the destination is not empty, avoiding potential data loss or a strang combination of a restored backup and previous data. Bug Fixed…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… only use one node at a time (to avoid rollbacks bcause of optimistic locking). If that node goes offline, we will start… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp… acting as backup nodes. If you are using HaProxy for MySQL you can break the privilege system’s host part, because MySQL will…
