5 ms·
Salesforce has successfully deployed multitenancy SaaS at a huge scale, and they have all tenants sharing the same tables. Every row in every table has an Organ
by memracom 10y ago
Salesforce has successfully deployed multitenancy SaaS at a huge scale, and they have all tenants sharing the same tables. Every row in every table has an Organization-ID column and all queries include the Org Id to keep the data separated. They built their SaaS on top of Oracle RDBMS but are now using PostgreSQL in some not yet publicized way.
Google for Salesforce multitenant architecture
and you will find several presentations/videos where they explain much of this architecture. IMHO this is required reading for anyone designing any sort of multitenant SaaS because you are less likely to make disastrous mistakes when you can compare your solution to a known successful solution, and explain where your solution differs and why.
- ngrilly 10y ago> They built their SaaS on top of Oracle RDBMS but are now using PostgreSQL in some not yet publicized way. How do you know that?
- dragonwriter 10y agoThere have been published reports that they are trying to move to PostgreSQL specifically, and off of Oracle more generally. This is an example (with links to some others): http://fortune.com/2016/05/11/salesforce-two-software-worlds/ http://fortune.com/2016/05/11/salesforce-two-software-worlds...
- ngrilly 10y agoThanks for the link.
- collyw 10y agoInteresting, but I am surprised by the quote: "A source with knowledge of the effort said a database change could give Salesforce flexible technology that could be more easily used across many data centers." I though Oracle did pretty much everything, but cost a fortune.
- manigandham 10y agoGood video describing their shared multi-tenant architecture: https://www.youtube.com/watch?v=jrKA3cJmoms https://www.youtube.com/watch?v=jrKA3cJmoms (Salesforce Multitenant Architecture: How We Do the Magic We Do)