…. When snapshot is being read if the block is being remapped it is read from the undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is needed while…. Now back to our question of space requirements for MySQL Backups using LVM. As you can see from the description above in…
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 … for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or could have anyone… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN…
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… The performance without LVM snapshot was 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the… this run I got approximately 200 ios/sec without LVM snapshot enabled while with snapshot I got: 33.20 Requests/sec executed 46…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to create atomic snapshot of the volume, which can be later mounted same as original file system Why snapshot based MySQL backups are… be able to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there…’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, which…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax… helpful in other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and… stall if this lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn… unverifiable speculation, that Amazon RDS’s version of MySQL is probably closer to stock MySQL than it is to Percona Server. I… the technical level. These include EBS volume snapshots, for example. They work much better than LVM snapshots, in terms of impact to the…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as… a DRBD LVM snapshot. Works on a Secondary node too. I’m not sure Florian understood what was meant here. With MySQL Master… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed to process request; So you can do following instead: mysql> rename table rep to rep_maint; Query OK, 0 rows… large amount of data it is much better to use LVM snapshots or similar techniques – these are much faster.
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
Today I was cloning the master using LVM Snapshot and found it was taking quite a while to catch … based on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could… to mysqlsla which I remembered parses all kinds of MySQL Logs. Too bad MySQL Binary log is the only one which it…
