… the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL… can easily run a server with hundreds of snapshots. With LVM, your IO performance drops to 33% after the first snapshot… solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and the backups are…
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 11 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: 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: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to… as LVM backup may not work in all cases. We also get into synchronization aspects making backup which prevents from having hot backup in…). Finally backup can be done in truly hot way without nasty “FLUSH TABLE WITH READLOCK” and hoping nobody is touching “mysql” database…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN backup, intensive activity on… which just a bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL replication lag.
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: 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: 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…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…is popular pattern used by many companies using MySQL for scale out. Most of the companies…server for administrator to decide. One command LVM based sync is also implemented so restoring… to create a backup with number of methods supported including compressed backup or incremental backups with rdiff….
