performance - One or many databases for application for many clients in PHP -


i writing php application in zf. customers use sell products final customers. customers host application on server or use own. of them host application on server.

i design 1 database customers @ once, every customer use same database, of course products etc. assigned particular customer. trivial.

i use separate database every customer, database structure simpler. use separate subdomains , maybe file location, detail.

which solution have better performance , how big difference? 1 choose?

i use separate database each customer. makes backup , scaling easier. if ever large customer needs custom changes schema, can easily.

if 1 customer needs restore data, single database trivial. on shared db, harder.

and if large customer ever gets lot of traffic, can put them on server minimal changes.

if 1 site gets compromised, don't have of teh data in 1 place, damage mitigated site hacked.

i'd recommend going 1 db per customer if possible.


Comments

Popular posts from this blog

Add email recipient to all new Trac tickets -

400 Bad Request on Apache/PHP AddHandler wrapper -

php - Change action and image src url's with jQuery -