Re: Making metadata storage SQL-driven

[Jamie McCracken <jamiemcc blueyonder co uk>]

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
http://www.advogato.org/person/jamiemcc/