Timeline for Multi tenant in a micro-service
Current License: CC BY-SA 4.0
20 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 3, 2019 at 0:49 | vote | accept | HM107 | ||
| Oct 3, 2019 at 0:34 | answer | added | Berin Loritsch | timeline score: 6 | |
| Oct 3, 2019 at 0:25 | comment | added | Thomas Owens♦ | Again - that's not an either/or choice. You can have a database per tenant and a database for service. Or you can have a database per tenant that all services for that tenant sue. Or you can have a single database for everything. These are false choices. Make each choice separately. | |
| Oct 3, 2019 at 0:23 | comment | added | HM107 | so why should we go for a database for tenant instead of database for service as long as there is no requirement for having multi-tenancy such as different countries, regulations, etc. | |
| Oct 3, 2019 at 0:23 | comment | added | HM107 | @ThomasOwens I think I wrote that wrong .. what I'm trying to say in case of separate databases in the micro-services is that each service will have its own data, so if the we have service x and y and tenants a,b,c .. in case of microservices and no multi tenants .. the service x should contain all the data related to x of tenants a,b,c .. but in case of multi-tenant scenario .. each of tenant a,b and c has a separate database that includes x and y for each .. | |
| Oct 3, 2019 at 0:07 | comment | added | Thomas Owens♦ | Again - these are orthogonal concerns. The relationship between your servers and database instances or database schemas is separate from if you have multiple tenants in one database or separate application (software + database) instances per tenant. | |
| Oct 2, 2019 at 23:57 | comment | added | HM107 | @ThomasOwens cant agree more, here is the question that I"m trying to answer .. why should we not use multi-tenant if we are using micro-services with separated databases .. minding that there are no other differences than the name of the tenant? | |
| Oct 2, 2019 at 23:49 | comment | added | Thomas Owens♦ | Having a second database server for failover or disaster recovery is orthogonal to multi-tenancy. I sense a lot of confusion on some of these concepts. Maybe the problems and proposed or possible solutions for each one aren't well defined. | |
| Oct 2, 2019 at 23:47 | comment | added | HM107 | @ThomasOwens yes we considered the identifier to be in the names as well whether table in the scenario that you have provided or in the database naming itself, however multi-tenancy was raised that it would be separate databases specifically to make sure if a database fails, it wont pull the others with it. | |
| Oct 2, 2019 at 23:43 | comment | added | HM107 | @BerinLoritsch in that case it will make some sort of data layer, which combines the data in one place, not separating it as micro-services. | |
| Oct 2, 2019 at 23:38 | comment | added | Thomas Owens♦ | Multi-tenancy does not imply a database per tenant. A single database with a tenant identifier column is sufficient. There are other solutions, as well. The only thing that matters is that you can identify a particular record or entry with a tenant. | |
| Oct 2, 2019 at 23:35 | comment | added | Berin Loritsch | A multi-tenant database would be one Database Server with multiple databases on that server. | |
| Oct 2, 2019 at 23:34 | history | edited | Berin Loritsch | CC BY-SA 4.0 | added 18 characters in body |
| Oct 2, 2019 at 23:33 | comment | added | Berin Loritsch | No worries. Would this be a correct way to represent what you meant: Manageability in one database, or separate databases for each tenant? | |
| Oct 2, 2019 at 23:31 | comment | added | HM107 | apologies .. English is not my 1st language, what I mean by full flock is multiple databases .. one for each tenant .. can you shed more light on what is the difference between multi-tenancy for the SaaS system and multi-tenant database? | |
| Oct 2, 2019 at 23:27 | comment | added | Berin Loritsch | Also understand that having multi-tenancy for your SaaS system has a different meaning than having your database be multi-tenant, which I think may add some confusion. | |
| Oct 2, 2019 at 23:25 | comment | added | Berin Loritsch | Can you clarify what you mean by "per the full flock"? I tried to clean up the formatting and grammar a bit, but I don't know what you mean by that. | |
| Oct 2, 2019 at 23:24 | history | edited | Berin Loritsch | CC BY-SA 4.0 | grammar updates |
| Oct 2, 2019 at 22:50 | review | First posts | |||
| Oct 6, 2019 at 9:16 | |||||
| Oct 2, 2019 at 22:48 | history | asked | HM107 | CC BY-SA 4.0 |