Multiple mySql Databases

[jbengard]

Hello,

I have a question that might be easy, but Im not quite the php guru (yet).

What I need to accomplish:
I would like to have clients authenticate with one database, and from that database, get vars on which database, host, username, password their information is stored on to be used throughout their session.

In case it matters. Every client has the same database structure, just the data is different.

Thanks

[Anon]

That would be easy enough to accomplish, but why exactly do you want each user having their own database? that would really overload the server if many people used it...

Dave

[jbengard]

Dave, thank you for a quick response.

We run a managed service for streaming media. Each customer (company) has their own set of servers that manage their set of streaming stations, each including a mySql server. Although the database structure is exactly the same in each of the mySql servers, the data differs to company specific information.

For QoS purposes each customer does not share each others equipment.

Any design ideas or thoughts you might have would be grateful, but the only thing is the server design can't change. I would still be interested in how to solve this problem for short term for now though.

Other thoughts I have..

Run each of the databases on the website, and run updates of each of the databases to each of the servers at fixed intervals

Create a mySql slave database that replicates each of the customer databases and run everything against that single server.

Thank you