… relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… have, as well as many other operations, so beware. Binary log corruption – Binary log may become corrupted and out of sync with database content. This will… so your Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… a standby MySQL server or at least synchronously replicated master binary logs. If you can’t loose any single transaction you’ve… may take many days to catchup from weekly backups by binary logs so make sure to time it properly. In the real… as shortcut) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and…
Comment: MySQL Crash Recovery
August 2, 2006 By 26 Comments
In “Binary log corruption“, you say “In MySQL 5.0 XA is taking care of this synchronization”. If you know any document or URL about synchronization between binary log and InnoDB log w/ innodb_support_xa, would you like to tell me? Does MySQL AB Document refer to this synchronization?
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum… in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, …, insert buffer merge or recovery from transactional logs all together. Though the lower recovery mode …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… your backup is consistent. Backing up database which was already corrupted is very nasty problem you want to avoid. Let’s… that you should probably record binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need… you can skip slow query logs and error log while taking backup. You also can skip most of binary logs – however if some of…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… experience Innodb tables become corrupted more seldom than MyISAM. Thanks to checksums and crashing in case of corruptions and a lot of… Innodb while secondary keys may have very complex structure. Compex corruptions are resolved by dump and restore from backup. I think… even week old backup and running roll forward recovery using binary log can be a lot faster.
Post: Small things are better
October 8, 2006 By 15 Comments
… bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table… need to reimport whole database – if corruption is happens to be in undo tablespace or log files. So do not forget to… restore, especially if you do point in time recovery using binary log to get to actual database state. The good practice to…
Post: Innodb crash recovery update
May 22, 2007 By 3 Comments
… a serious Innodb corruptions for a while, typically even if it happened it was some simple table related corruption which was easy… that we had backups and binary logs which means it was easier to recover from backup and replay binary logs. This time I have…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… more than one fsync() for the log because it internally implements XA to synchronize with binary log and also if you’re looking for maximal data consistency (as SAN users often are) you better have binary log flushed… the Firmware may have a glitch causing failure and data corruption (and this is not just a speculation, some clients really…
