• Registered: 2015-11-16
  • Posts: 158

Topic: Multiple Separate Organisations on one MySQL Database

Hello,
I am thinking about developing an application that hopefully would be used by multiple separate companies. I could have a MySQL database and the various customers all use this single database. All customer data would need to be isolated from other customers. The advantage is that I could update the software and change the database structure and all users would benefit. Alternatively, I could create a new MySQL database for each customer to be accessed only by that customer. That would be more difficult to administer to keep all of them the same.
Has anybody done this sort of thing and/or does anybody have any ideas on the best way forward?
Is there any sample project demonstrating how this could be done?
Thanks in advance,
David

  • Registered: 2014-06-25
  • Posts: 863

Re: Multiple Separate Organisations on one MySQL Database

If you want to use a single database, you will have to manage permissions within Mysql but it is manageable using groups and roles as it is done on major systems across different organizations. You have to keep in mind the internal policies of each company about data collection/accessibility/sharing and service level agreements. It all depends on the application itself actually. Think also about the uplinks speed/quality from your customers.