Re: Making metadata storage SQL-driven
- From: Jamie McCracken <jamiemcc blueyonder co uk>
- To: Alexander Larsson <alexl redhat com>
- Cc: Christian Neumair <chris gnome-de org>, nautilus-list gnome org
- Subject: Re: Making metadata storage SQL-driven
- Date: Thu, 01 Sep 2005 13:18:23 +0100
Alexander Larsson wrote:
On Thu, 2005-09-01 at 13:00 +0100, Jamie McCracken wrote:
"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
] [Thread Prev