[...] 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 [...]
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….
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the proper backup or…, for example you might get point in time recovery while backup setup only takes you to the point where last binary… ahead sectors 0 So we have RAID volume back but LVM shows this volume as NOT available and so it can…
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: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… we’re up for a lot of surprises. Backup Cross storage engine backup is a pain because they are so different. Some… 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: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has much…. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax… in other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… 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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…are for giving me information about LVM devices, volume groups, and logical volumes….mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability…
Comment: Living with backups
November 6, 2008 By 28 Comments
@themattreid, This method can be done by using LVM and taking a file system snapshot while mysql is running, and then copy/tar from the snapshot. You can find some more info on this blog post: http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/
