Hi!
On Dec 18, 2008, at 5:04 PM, Tim Soderstrom wrote:
We were pondering this at work and I think it might be pretty neat.
Consider the case where multiple users might live on a server (say a
shared hosting environment). Being able to assign a db to each user
and allow them to make their own schema under that db would be
pretty neat! (Each DB would probably be associated with a website in
this example).
What you are describing is exactly what I had imagined when we were
working on the auth system. I've been thinking we would see a number
of deployments where users were assigned schemas that they controlled
(aka could create tables in), but could not join to tables beyond
their current schema. We will need to work this out with I_S... but it
is very doable.
The step I have been thinking about beyond this is to allow different
Innodb instances per schema/catalog. This way you can say "user A gets
2 gigs, while user B gets 4, and user C has access only to the shared
Innodb pool". I want more controls for multiple tenancy usage.
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
