… Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization overhead. I learned… write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe… solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and the…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql> select …server somehow blew up in flames, hardware problems or encounter and LVM bug, your snapshots are useless. Also, you cannot test …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…that caused downtime for our customers: Failed or full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, … if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on… snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there are different implementations but… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave… does this tool do and how it works ? Currently it is implemented based on Linux IP management tools and LVM for snapshot creation…. MMM will detect this situation and will hold the server for administrator to decide. One command LVM based sync is also implemented…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice. I… comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone for a while as these… DRBD LVM snapshot. Works on a Secondary node too. I’m not sure Florian understood what was meant here. With MySQL Master…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything is same as before and for… forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of… be the difference between slave never lags and slave never is able to catch up. MySQL or OS version changesMySQL version changes…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… last three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this point, unless I’ve…/mysql and it’s reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… it is quite typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the… trouble makers. Third,Use dedicated LVM volume for MySQL Instance. This is good idea for many reason and control over snapshot size is… of junk IO activity causing overhead and eating LVM undo space. For example MySQL on disk temporary files and tables can waste quite a…
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… looks like it is the time to dig further into LVM internals and well… may be I’m missing something here – I… lower performance requirements) So we’ll do some research around LVM and I hope to do more benchmarks – for example I’m…
