… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only…
Comment: How would you compress your MySQL Backup
June 7, 2008 By 29 Comments
Right. If you backup from the slave cold backup is probably the most failsafe. Backup from slave is good if you can ensure you… without noticing for a long while and backup in such case is dangerous. Though putting backup load on the master is often…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… Backups – we mainly use LVM (or other snapshot) based backup which is the most typical solution. The second most common one is cold backup…
Comment: How would you compress your MySQL Backup
June 8, 2008 By 29 Comments
Got a question about snapshot type backup: If I snapshot a myisam file system that is in … hot backups, but I can’t figure out how to do it w/o either A) shutting down the database (cold backup), or…
Comment: My "hot" list for next InnoDB features
October 11, 2009 By 18 Comments
It’s a table cold backup and restory without shut down of InnoDB Restoring a single .ibd file http://www.innodb.com/doc/hot_backup/manual.html#partial.restoring.single
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… and need it to catch up or when restoring from backup, the loaded replication capacity matters during normal operation. So we… take during backup recovery trials when you’re doing this activity anyway. Using this way you can also measure “cold” vs “hot… production (especially if you have slave which is used for backups/reporting etc) is to stop the replication for some time…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
… logs etc are other type of this data. Besides separating “cold” data from “hot” it often makes sense to separate data… index entries having all hot data in separate table from cold data is much more efficient for caching than having table… plenty of operating benefits – small database takes less time to backup and restore it is easier to do ALTER TABLE and…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… but I would not be basing my failure handling scenarios. Cold Start – If you restart MySQL server its caches (key_buffer… per database host). This one is pretty much part of cold start problems but I wanted to point out it separately… may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about…
Comment: MySQL Replication vs DRBD Battles
April 29, 2008 By 12 Comments
… up all pros and cons. I would add another point: Backup from slave / secondary. With DRBD this is hard / impossible in… lag, 100% sure all transactions are there, no need to backup this database). The main database is configured in Master-Master… (26G buffer pool). So it would not even be a cold stand-by but a frozen one. 
So all the pros…
Comment: Living with backups
November 6, 2008 By 28 Comments
… impression that cold binary backups have to be done with MySQL off in order to get useable data for a backup. I don…
