Database Design
Posted by: Abdull Adi
Date: July 18, 2013 02:18AM

Hello,

We are really seeking your help guys to advise us.

We are developing our SaaS application and we came to a stage where we need your technical point of view.

This SaaS app has the same features and functions for all SaaS subscribers on PHP application layer. All subscribers MySQL database structures are identical since we are offering the same app to all of our subscribers.

As developers we came to the following options, which really needs your involvement to comment on it based on your experience;

1-Deploy one database for all SaaS subscribers.

2-Deploy a single database for each subscriber.

Here is the most important part...

The most important part is that all subscribers database will be queried by other users from the Internet when they visit our website. Those users are seeking some data from the subscribers databases, which will be published by the subscribers. The user will query all subscribers at the same time to get a result and then choose the preferred one.

We are wondering what would be the best option and what do you recommend and why in order to get in hands Scalability, Performance, and Security

Thank you so much and I appreciate your help

:)

Options: ReplyQuote


Subject
Written By
Posted
Database Design
July 18, 2013 02:18AM
July 20, 2013 10:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.