Shared Application On 1 Server Options

[dlebowski]

I need some advice on a question I have.  Currently, I have a PHP application that my customers can run via the internet.  As I add customers, I need to know what is the best way to handle multiple customers using different instances of the application.  For example, right now my site is www.mysite.com/dlebowski.  I have my own mysql database associated with it as well.  I was thinking that any new customer that I add would be setup with www.mysite.com/newcustomer1 where my application resides in a seperate directory "newcustomer1" and a new mysql database is created.  If I added another customer they would reside on www.mysite.com/newcustomer2 and also have their own mysql database.  Is this the best way to hand this?  All my clients will need their data in seperate mysql databases and I'm not sure of a better way to handle this.  ANY help would be appreicated.  Let me know if you have any other questions regarding my setup.

 

-Ryan

[trq]

Depends really on how much control you have oser your server and how exactly your application works. For instance... do you have the ability to setup vhosts, subdomains or ServerAliases?

 

I run a few client sites from one server and one framework base. the framework itself resides in /usr/share/php5 wiich is within my include_path. Then each clients site is within /var/www/client. All my clients however have there own domain names and I have setup there sites useing vhost configurations.

[tomfmason]

imho, adding another table called something like "customers", adding a customer_id column to the existing tables and referencing the customer_id when retrieving  the records would be the *correct* way to do it.