[dmurfitt]

Our host plan has given us 1 MySQL database. I want to be able to use this database for our website to store test results, comments etc. We also develop some websites for our customers, is it a bad idea to store their data in our database too, even if it's not related to our data in any way at all? This would save upgrading to the next plan up or buying extra databases, but I don't want to have a mess of data at the same time. Thanks.

[GCDude]

Well you have to weigh up the cost of extra mysql databases, the organisation of diff websites tables and if you are having lots of traffic, the performance of the 1 db.

To start with i would run off the 1 db and organise your naming of tables such as-

OurWebsite_table1, OurWebsite_Table2............
customer1_table1, customer1_table2...........
customer2_table1, customer2_table2............

then if things start getting slow, youll then have the choice of buying more db's and moving customer tables, depending on load.

[dmurfitt]

That's what I've started to do, I just wasn't sure if it would be a good idea or not, don't want the whole thing to fall over. Thanks for the advice mate