Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 26 Mar 2008 09:09:30 -0400
From:      Bill Moran <wmoran@potentialtech.com>
To:        Da Rock <rock_on_the_web@comcen.com.au>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables
Message-ID:  <20080326090930.c8d318ee.wmoran@potentialtech.com>
In-Reply-To: <1206495548.6973.161.camel@laptop2.herveybayaustralia.com.au>
References:  <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au> <20080323191727.bd9c5237.wmoran@potentialtech.com> <1206315963.6973.84.camel@laptop2.herveybayaustralia.com.au> <34394a3a0803231701n3e125b15nfa866a9dfccfb331@mail.gmail.com> <1206495548.6973.161.camel@laptop2.herveybayaustralia.com.au>

next in thread | previous in thread | raw e-mail | index | archive | help
In response to Da Rock <rock_on_the_web@comcen.com.au>:

[massive snip]
> 
> I remember now exactly why I wanted MyISAM- you see the table locking is
> exactly what I need for the task. I just need to come up with a method
> to ensure what I send to the server does actually get written- or am I
> just being paranoid?
> 
> The task I require needs to offer direct sequential access with no
> undoing of written data. And given the legality of the task based on
> these strict requirements, you can understand my paranoia.

Sounds to me that you want something more like a logfile, where you can
write a line of data, then fsync the file to guarantee that it's been
committed to disk.  Of course, depending on how you'll need to access
this data later, this may not be the best approach.

I don't know the details of how MySQL does or does not guarantee that
your data is safely on disk, but I can say that PostgreSQL uses fsync
after each commit to ensure you're data can not be lost.  From there,
it's up to the hardware, so ensure you have quality disks that don't
lie about caching, and you'll probably want a battery-backed RAID
controller and some sort of disk redundancy (i.e. RAID-10)

-- 
Bill Moran
http://www.potentialtech.com



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080326090930.c8d318ee.wmoran>