…: has_journal ext_attr resize_inode dir_index filetype needs_recovery extent 64bit flex_bg spars e_super large_file huge_file uninit… filesystem data structures which may be affects one file will take out whole file system. I do not think these concerns are valid… very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… volume, which can be later mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons… benefits. First no extra handling is needed for journaling file sytems – you can simply do journal recovery on snapshot. With read-only snapshot…
Post: Small things are better
October 8, 2006 By 15 Comments
… had “journal failed” message in kernel log and filesystem needed to be checked and repaired even though it is journaling file system which should… page writes but still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… the right choice. You’ve has a review by a MySQL consultant. I’m assuming the review was professional. But you… a Unix-like OS? If so, what file system are you using? Unjournalled, like ext2, or journaled, like ext3, xfs? If you’re running Windows, do you useFAT32 of NTFS? I suspect you’re using journaled file systems, although…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…. Moreover these operation could cause (depending on file system and configuration) more synchronous IO operations – MySQL binary logs are not preallocated as Innodb… synced to avoid data loss. Though in case of “data journaling” this can be done with single log write with actual…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and… sync-binlog=1 We tried running data=writeback and data=journal just to make sure but results were basically the same… the most common file system for Linux. It is also worth to investigate if something can be done on MySQL side – may be…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…compare MySQL Replication to DRBD in this case – in both cases due to some reasons you can have systems …. But fsck? These days this amounts to running a journal replay. Takes under a second in most circumstance …O_DIRECT with Innodb which makes it to bypass file cache. If you have it DRBD slave will …
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 files….) The problem was that the filesystem was ext2, with no journaling and no consistency guarantees. A snapshot on the SAN is… doing this include things like ordered writes and meta-data journaling. But ext2 does not know how to do that. The…
Comment: Opening Tables scalability
March 20, 2007 By 27 Comments
…have many php and system tweaks but this problem seems to be hard to resolve without MySQL source code … unstable within such load and brokes it’s journal itself very often, and reiserfs is not visible… cause worse performance problems – like hosting >10 000 000 files in one directory (3 files per…
