… dirty and Alexey had series of sleepless nights digging into Innodb page and row structure. When few more companies followed, so… their data, and we helped to implement proper backup strategy for some. Sometimes backups stop working in others they are never setup… least replicated. Alexey also has a task to write more details about Innodb data recovery process and release code for our innodb recovery…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… envinronment works great for MyISAM but does not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also… as a backup may well work for MyISAM but will start taking way too much time to do restore for Innodb. On… balanced or replication of mixed table types which is quite complicated. I prefer to pick one storage engine (typically Innodb) and when…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… only Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication… cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… TABLES WITH READ LOCK and fail backup or kill long running SELECT queries to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables and… data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply pausing replication.
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
We’ve written about replication slaves lagging behind masters before, but one of the other … it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the purposes… are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…the various stuff that will be running (monitoring, backup, cron, syslog, etc). But the ratio of RAM…that table on a separate computer, maybe a replication slave. Can you make the reorganization run in… up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… Linux setup LVM for database directory to get more efficient backup. EXT3 file system works OK in most cases, though if… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… row level replication. There are bunch of other options you may want to tune but lets focus only on Innodb ones today…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database to… out of sync with database content. This will sometimes break replication but if you’re just planning on using binary log… experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… to compare results with different innodb_buffer_pool_size or innodb_flush_log_at_trx_commit but for innodb_thread_concurrency – you should… will change but may be not. In particular: innodb_support_xa=0, innodb_doublewrite=0 are not normally used in production and… installations of MySQL use replication or at least binary log to get point in time recovery from backup. Also Innodb log files of…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK in… in this case ? Your main options are using Backup or Slave with delayed replication (which you already could have set up with… on the master to which backup corresponds to. This becomes more complex if you have complex replication hierarchy as slave only knows…
