Re: Making metadata storage SQL-driven

[Alexander Larsson <alexl redhat com>]

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.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 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!