[...] and Replication By mehrdad, on May 19th, 2010 Using LVM for MySQL Backup and Replication Setup: http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ MySQL Linux Firewalls Using iptables [...]
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research… going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for now). We gathered basic ideas here…
Comment: Disaster: LVM Performance in Snapshot Mode
December 21, 2009 By 55 Comments
Wow, thanks for the thread folks, I’ve found it educational. As a Solaris guy running Veritas vxfs for the past decade and now ZFS, I have recently begun to find customers running mysql on linux, with and without LVM. It looks like LVM has a bit of catching up to do!
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to …for directory with couple of files. In recent Linux Kernels deadline or cfq IO schedulers should …may use database version from the backup or LVM snapshot of current database with same results. …
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… –raid-devices=2 /dev/md0 /dev/md1 And also in Linux you can create tricky RAID10,f2 (you can read what… get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small… may be tricky. But in this case you may consider LVM snapshots or XtraBackup
