List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:February 10 2002 6:48pm
Subject:Re: Jailed MySQL for hosting customers
View as plain text  
Hi!

>>>>> "Alexander" == Alexander Keremidarski <salle@stripped>
> writes:

<cut>

Alexander> Running mysqld for every user is not an option at all. For 3-5 users 
Alexander> maybe it is possible, maybe you can run up to 8 mysqld, but regular 
Alexander> hosting server can have hundreds of users.

It will not take notable more resources to run 100 different mysqld
servers than 100*X threads, where each users uses X connections.

<cut>

Alexander> With 'Complex Setups' - many DB, different DBA for every DB, several 
Alexander> Users per DB, Complex Privileges it would be better if Privileges can be 
Alexander> somehow moved to DB.

This is a problem, because:

- The user may access many DB's in the same query
- He may not be connect to a DB when he executes a command
 (for example executing 'show variables').
- Many of the current MySQL clients doesn't supply the database name
  when connecting to MySQL;  (We don't want to break old clients
  without a very good reason).

<cut>

Alexander> With many considerations like "If user has File_Priv - it is 'chrooted' 
Alexander> at some_dir like PHP open_basedir option

This could be done by adding a new option to the user table, which
would be the base root for the users 'LOAD DATA INFILE' files.

Alexander> And this can be done easily (I hope) if there is VIEWS support in MySQL.

Alexander> Sounds like total revising of current MySQL behaviour isn't it?

Alexander> Monty, remember in other thread:
Alexander> To say it different mysql.* is Admin space not User space
Monty> In practice there isn't really a big difference.

Alexander> Don't you think cases like this become more and more common?
Alexander> MySQL used as Webserver back-end on Hosting server.

Because MySQL allow queries across databases, things are not that easy.

What we could also do would be to add some shared memory segment for
global big caches used by MySQL.

This would make the overhead much smaller between running one MySQL
server with many users and one MySQL server per user....

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <monty@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com
Thread
Jailed MySQL for hosting customersDavid Phillips5 Feb
  • Re: Jailed MySQL for hosting customersSasha Pachev5 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips5 Feb
    • Re: Jailed MySQL for hosting customersSasha Pachev5 Feb
  • Re: Jailed MySQL for hosting customersAlexander Keremidarski5 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips5 Feb
    • Re: Jailed MySQL for hosting customersPaul DuBois5 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb
  • Re: Jailed MySQL for hosting customersJeremy Zawodny6 Feb
  • Re: Jailed MySQL for hosting customersDavid Phillips6 Feb
    • Re: Jailed MySQL for hosting customersJeremy Zawodny6 Feb
    • Re: Jailed MySQL for hosting customersMichael Widenius10 Feb