…to restore data from backup which can be far from being enough to restore the whole system to…to MySQL bugs or wrong use. Interesting enough very few people have their data recovery practices ironed out so they can answer how…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup…backup you will need to restore slaves as well and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
…MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of these kind connected to… is powerful enough. This applies to large Innodb tables with not overly …to restore all 50 servers from backup… in parallel. Will you backup system will be able to restore…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…MySQL binary log file which often contains plenty of similar events, which could be the reason for so large…and 276MB/sec write speed to the hard drive – this means restoring from backup compressed with LZO will …. UPDATE: It looks like people are wondering how BZIP2 compares so I should check it …
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… metaphor for how the …to simulate the situation, Stewart suggested we use a transactional load against a large number of tables. We were able to…to use the following command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to…backup with –parallel=50 and then try to restore…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…how to handle it, or be able to learn it. It is also important to adjust processes as required to…backup may well work for MyISAM but will start taking way too much time to do restore for Innodb. On large…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… businesses and large web applications. In this webinar, we’ll teach you how to set up Percona Server, XtraBackup, and Tungsten to manage Terabyte… InnoDB buffer pool dump/restore and HandlerSocket, our favorite tricks for backup, restore, and provisioning of large data sets, and how to replicate scalably and safely…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…to details again. Two great things you’ve got to learn when working with large data things in MySQL…Backup and restore will be faster but it can still take hours especially if database is already loaded. So operating wit such large… you simply need to plan carefully how you’re going to alter your …
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
… MySQL Performance or about Performance at all, but I guess it should be interested to many MySQL DBAs and other people involved running MySQL… backups ready. If you care about your data backups are must whatever other HA methods you use. Large data sets take time Restoring 1.5TB volume is likely to take…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to do backup > and restore if you need only portion of your data recovered. While this is true if the goal is to restore… > Why MySQL Could be slow with Large Tables article. Deciding whether or not to …deciding when / how to create indexes. Foreign key references may add processing time to inserts,…
