Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies…: /root/backup-tools/tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql directory at 15000000 bytes…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… answer I would give for most cases is “check your backups for corruption instead of your live server.” You need to… (at least periodically) that your backups are recoverable. The usual procedure goes like this: copy your backup somewhere, start a server instance… people refresh their dev/staging environment every day with last night‘s backup, which is a great way to make failures obvious…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… back. We wrote about it, other people from MySQL Community too. The situation did not get better, …(and during rebuild stage), what overhead LVM takes for backup etc. It may be performance drop is not …would be much better with scheduled learning during the night or weekend, where it can be done on …
Comment: Using LVM for MySQL Backup and Replication Setup
August 15, 2008 By 53 Comments
… by SHOW MASTER STATUS. Why does this matter? If your nightly backup doesn’t capture master status, that shouldn’t prevent you… Binlog_Ignore_DB mysql-bin.000156 956920476 -rw-rw—- 1 mysql mysql 956920476 Aug 16 00:23 mysql-bin.000156 /data/dev/mysql# mysql < FLUSH TABLES... Binlog_Ignore_DB mysql-bin.000156 957115478 -rw-rw—- 1 mysql mysql 957115478 Aug 16 00:23 mysql-bin.000156 /data/dev/mysql# mysql < FLUSH TABLES…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
Last night a customer had an emergency in selected machines on a … machines. Same thing — write-through, battery charging. And the battery backup unit was set to run through auto-learn cycles periodically…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… typical LVM is not configurable properly to be usable for MySQL Backups. Quite frequently I find LVM installed on the system but… modifications. Now back to our question of space requirements for MySQL Backups using LVM. As you can see from the description above… the time of backup you will need 10GB of undo space. Second, limit batch activities – Backups are often done at night when server…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… get our hands dirty and Alexey had series of sleepless nights digging into Innodb page and row structure. When few more… their data, and we helped to implement proper backup strategy for some. Sometimes backups stop working in others they are never setup… helped by having the slave MySQL server – so do not think about your Slave as your backup. Hard Drive failure is also…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
… money lost. Then I received an e-mail, saying “Backup failed: MySQL has gone away” or something to that effect. Eventually I… of MySQL, this only caused the client to exit, and left the query running in the background for hours. That night, the backup… to InnoDB for everything, and use mysqldump –single-transaction for backups. Hopefully more people will start using InnoDB now that Oracle…
Comment: Using netcat to copy MySQL Database
June 5, 2009 By 25 Comments
… HA as MySQL gets anyway) for international users and systems, not just a little PHP site in Dubuque. The “night-time trough” is no longer a luxury for a lot of the client base of MySQL. 2. LVM… for their storage hardware to support a method of database backup used solely because a working solution isn’t available from…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… implementation (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with MMM or… waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of…work which needs to be done at night hours. Remote work however also needs …
