… entirely missing from the backup if you use this technique ? The problem comes from the fact how MySQL‘s Transactions work with… you get some empty tables in your mysqldump –single-transaction backups you will know the potential cause for it. What are… duration of operation. You can also use Percona Xtrabackup, LVM or other database backup approach which does not relay on transaction visibility.
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with… 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: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
We know MySQL Backups using LVM are pretty cool (check out mylvmbackup) or MMM though it is quite typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the system… modifications. Now back to our question of space requirements for MySQL Backups using LVM. As you can see from the description above in…
Post: LVM Configuration mistake to Avoid
July 9, 2008 By 10 Comments
One of our customers was setting up box for MySQL LVM backups. The box had 2 RAID volumes (internal drives and enclosure) … would make sense to have LVM undo space located on the internal drives so LVM and backup has less backup on the running system… took backup anyway just to be on the safe side) P.S That would be interested to benchmark one day how LVM…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…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…down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity on…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important… data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all… as well because this makes it very easy to use LVM for backups while assuming you have BBU on the raid volume…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… general IO performance in this case – it is not something MySQL related. I tested things on RHEL5, RAID10 volume with 6…. Because of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a… copying is added. The question I had is how could LVM backups work for so many users ? The reality is – for many…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a…. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for now). We gathered basic ideas…
Comment: Using LVM for MySQL Backup and Replication Setup
August 31, 2007 By 53 Comments
[...] google LVM if it’s new to you, then check out the following: MySQL Performance Blog – Using LVM for MySQL Backup and Replication setup Mike Krukenberg’s blog – MySQL Backups using LVM Snapshots nixcraft – Consistent backup with [...]
