Re: Making metadata storage SQL-driven

Alexander Larsson wrote:
On Thu, 2005-09-01 at 13:00 +0100, Jamie McCracken wrote:

to quote:

"Allowing multiple MySQL servers to access a common data directory over NFS is a bad idea!"

yes but thats not the case here is it?

Firstly we are not dealing with a mysql server yet alone multiple ones and secondly only one instance (albeit with multiple threads) would ever access the data files in a user's home directory so im not sure this is an issue. The threads would mutex access so it should be a non-issue, yes?

I'm talking about shared NFS homedirs. In such systems its pretty common
to log in on two machines at the same time. (In fact we've spent quite
some time working on this with gconf, as many customers have such
setups.) In this case there are definitely multiple sql servers, all
writing to the same db over nfs. The fact that the db code is embedded
in some other code doesn't make the embedding process not a sql server
in this aspect.

In those instances then I expect other parts of Gnome to potententially fail (most notably evolution which uses Berkeley DB for its address books and calendars)

If we are going to have multiple sessions on dodgy NFS mapped home dirs then my DDS should also optionally allow use of the non-embedded mysql daemon for those cases (the admins will need to set up mysql user accounts for each user in that case).

Alexander Larsson Red Hat, Inc alexl redhat com alla lysator liu se He's a scarfaced ninja ex-con with a winning smile and a way with the ladies. She's an enchanted goth mercenary trying to make a difference in a man's world. They fight crime!

Mr Jamie McCracken

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]