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… need to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the proper backup…via SSH it can be recovered as any generic Linux server. When you restart the system RAID5 volume … 0 So we have RAID volume back but LVM shows this volume as NOT available and so …
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…IO performance in this case – it is not something MySQL related. I tested things on RHEL5, RAID10 volume …know O_DIRECT often executes quite special path in Linux kernel so I did couple of other runs. …is added. The question I had is how could LVM backups work for so many users ? The reality is – for…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux… me information about LVM devices, volume groups, and…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… as monitoring, alerting, backups, caching, reverse proxies, …
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…. 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
… popular pattern used by many companies using MySQL for scale out. Most of the …Currently it is implemented based on Linux IP management tools and LVM for snapshot creation but we…to create a backup with number of methods supported including compressed backup or incremental backups with rdiff….
Comment: Using LVM for MySQL Backup and Replication Setup
May 19, 2010 By 53 Comments
[...] 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: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… people running 32bit Linux on 64bit capable boxes with plenty of memory. Do not do this. If using Linux setup LVM for database directory to get more efficient backup. EXT3 file system works OK in… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to … directory with couple of files. In recent Linux Kernels deadline or cfq IO schedulers should …slave you 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 13 Comments
… –raid-devices=2 /dev/md0 /dev/md1 And also in Linux you can create tricky RAID10,f2 (you can read what…-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small problem with backup over EBS… may be tricky. But in this case you may consider LVM snapshots or XtraBackup
