… need for undo. LVM Snapshot works kind of like Multi Versioning in Innodb – when you write the new data the new version for… undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is needed while… allow full database size for undo space without thinking). If such hard drive dies you will only use snapshot but not your data…
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… that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…happen – query which crunches large amount of data set wipes data from your normal working set from OS… meaning if you have query which is doing full table scan (sequential reads) its requests will …may use database version from the backup or LVM snapshot of current database with same results. In some…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…data trashed you may need to recover full database on all slaves which is best done in binary mode for large data… master you need to recover slaves to matching snapshot – either it has to be same state (which …), have LVM setup if you want to avoid shutting off slave or master to clone the data and …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… Here is simple example – assume you’re inserting the data at the same time as running reporting queries …with a database that you run off a DRBD LVM snapshot. Works on a Secondary node too. I’m not…no OpenSource solution out where which would offer you full redundancy use of both nodes at least for …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. The last three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this point, unless… compare it against the server’s variables or whatever other data I need, and write something instructional to the client about… MySQL’s workload and data After I’m done with that, I’ll grab a few snapshots of SHOW FULL PROCESSLIST, and look…
Comment: An argument for not using mysqldump
November 16, 2010 By 24 Comments
Use LVM for your filesystems and place MySQL on an LVM partition. You can then lock all tables and snapshot the partition – only a few seconds of lock time. Then copy the snapshot to another partition or device. You now have a full copy of the raw data – so restore is…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental… backups at all ? Why not just take the full backups daily. The answer is space – if you …it should be in the data file) stored in the page. Using this data it should be easy to …
