…on: /mnt/data Filesystem UUID: f9f7a0c3-0350-46d5-9930-29c3ac1f4b32 Filesystem magic number: 0xEF53 Filesystem revision #: 1 (dynamic) Filesystem features: has_journal ext_attr …needed, same as you would every so often check MySQL tables for corruption. To change those options you can run tune2fs -…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… original file system Why snapshot based MySQL backups are great ? There are number of…journaling file sytems – you can simply do journal recovery on snapshot. With read-only snapshot you need to make sure filesystem…. Backing up database which was already corrupted is very nasty problem you want to…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…/failover MySQL system, and there was a failover that didn’t work; both the primary and fallback machine had identically corrupted data… without errors on the filesystem level. From InnoDB’s point of view, though, it was still completely corrupted. The “InnoDB file” contained… a little money.) The problem was that the filesystem was ext2, with no journaling and no consistency guarantees. A snapshot on the…
Post: Small things are better
October 8, 2006 By 15 Comments
…. We had “journal failed” message in kernel log and filesystem needed to be checked and repaired even though it is journaling file system… still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so…
Comment: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… best solution for most MySQL High Availability needs. The reasons are: – Bad memory or MySQL Bugs on Primary can corrupt storage… which will… for Innodb tables – on large system tuned for performance filesystem recovery from journal and Innodb recovery can take 20+ minutes. You can…
