… 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… kernel so I did couple of other runs. First run syncing after each request instead of O_DIRECT /tmp/sysbench –test…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… it is implemented based on Linux IP management tools and LVM for snapshot creation but we hope support for other operation systems… hold the server for administrator to decide. One command LVM based sync is also implemented so restoring broken replication safe way becomes… node in clean way (making sure replication is still in sync) – I see too often this switch happens “dirty” way potentially…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master… 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…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… to slow down and not sync up with the master . Now some of these slaves run on LVM‘s which have already… to pursue other avenues like lvm snapshot . So i can easily lock the mysql tables and take a lvm snapshot with lvcreate in a quick seconds and then release the mysql lock . Now that I have the snapshot of…
Comment: LVM Configuration mistake to Avoid
July 30, 2008 By 10 Comments
In my experience, lvm snapshots have a serious performance impact for writes to the parent LVM. Just for kicks I tested unpacking a… to: time tar xvfj linux.tar.bz2 ; time sync No snapshot: 17s Regular snapshot: 61s Snapshot with chunk size of 512k: 47s I unmount…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… some reasons you can have systems to run out of sync and have conflicting updates applied to them. With DRBD you… want with a database that you run off a DRBD LVM snapshot. Works on a Secondary node too. I’m not sure…’re looking to ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…recover master you need to recover slaves to matching snapshot – either it has to be same state (which … off 2 slaves and still operate normally), have LVM setup if you want to avoid shutting off … on master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… the master. In any case you need slave to be synced with Master. To discover the difference between Master and Slave… would like to later investigate why data got out of sync and may be do some manual touch ups after you… large amount of data it is much better to use LVM snapshots or similar techniques – these are much faster.
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log… forms. It can be you running backup through xtrabackup or LVM snapshot, RAID controller doing RAID validation, some centrally kicked of SAN…
