White Label Ecommerce app. Shared or Individual dbs

Posted by MetaDan on Stack Overflow See other posts from Stack Overflow or by MetaDan
Published on 2010-06-11T12:35:38Z Indexed on 2010/06/11 12:52 UTC
Read the original article Hit count: 241

Filed under:
|
|

Currently I'm working with an in house white label cms that we resell to multiple clients and it all runs from the same box/db.

I'm just looking at converting this to have an ecommerce version that we'll run alongside it.

I'm wondering whether there will be an issue keeping all the products/categories/orders in one db or whether it would be advisory to separate each instance of the site into its own db for this.

These white label instances will only be sold to smaller companies that probably wont have masses of traffic/products and are looking for a simple ecommerce site. Anything larger will definitely get its own hosting and db.

But for smaller scale stuff do you think a single db will be ok?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about scalability