[OpenAFS] mysql data from openafs

Neulinger, Nathan nneul@umr.edu
Fri, 23 Jul 2004 14:35:32 -0500


MySQL can be configured to close tables automatically every so often.
It's one of the config file parms. Even still seems like a scary idea to
me.=20

-- Nathan

------------------------------------------------------------
Nathan Neulinger                       EMail:  nneul@umr.edu
University of Missouri - Rolla         Phone: (573) 341-6679
UMR Information Technology             Fax: (573) 341-4216
=20

> -----Original Message-----
> From: openafs-info-admin@openafs.org=20
> [mailto:openafs-info-admin@openafs.org] On Behalf Of Derrick=20
> J Brashear
> Sent: Friday, July 23, 2004 8:53 AM
> To: openafs-info@openafs.org
> Subject: Re: [OpenAFS] mysql data from openafs
>=20
> On Fri, 23 Jul 2004, Temp wrote:
>=20
> > I see.
> > Now i must rethink my design :-)
>=20
> I think umich is running mysql out of AFS, I wonder if they=20
> have patches=20
> to force (fsync or close/open)?
>=20
> >
> > On Friday 23 of July 2004 11:54, Sven Oehme wrote:
> >> yes ,
> >>
> >> afs will not really save the file to the Fileserver ,=20
> unless you close the
> >> file . in a mysql database case it will never save it to=20
> the server . this
> >> is a very good feature , because it gives you always a=20
> consistent file .
> >> but if you mysql system itself , or the afs client on that=20
> system crashes
> >> , you will loose all changes since the last close to the=20
> file and mysql
> >> will not close any files of a active db .
> _______________________________________________
> OpenAFS-info mailing list
> OpenAFS-info@openafs.org
> https://lists.openafs.org/mailman/listinfo/openafs-info
>=20
>=20