…MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables…MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
…down file system or broken down RAID. We can undelete Innodb… as recover dropped Innodb tables. We also can… corrupted binary log and dig into MyISAM tables….much more seriously after they had …server being compromised or staff mistakes. Many of these would not be helped by having the slave MySQL server…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…MySQL Server crashes or power goes down. In case crash happens without this option is enabled in most cases table corruption will be mild, especially on low loaded servers. Many users do not even know you need to check MyISAM tables after…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… innodb_flush_logs_at_trx_commit=1 and only using Innodb tables…should be able to continue after Master is back online. …MySQL. Yet another way is using DRBD to get a standby MySQL server…tables corrupted you can reload them. One option is to reload them on the master (and they will be replicated down…
