What is multi tenant – Troubleinthepeace


The problem of multi-tenancy in practice is encountered a lot, but there are many developers who do not understand the concept and operation of systems designed in this direction. Through a period of research and development of systems, I have drawn some experiences that I want to share with everyone.

You are viewing: What is a multi tenant?

*

In fact, we encounter many systems using multi-tenacyvd:- The store management system allows multiple agents to access with independent accounts, independent data, but the same site system. .- Dispatch management system used in corporation and many subsidiaries, same site but independent data.- Jira project management system- Zoho CRM system, saleforce… Many systems use SQL server, Oracle … design a multi-tenancy system according to one of the following architectures. Option I. Share a database (database), share a table (table)All related tables have a foreign key, ShopId. The product data of each shop is stored in the same Product table, but is distinguished by the ShopId.Strength field.:– Simple storage design.- Easy for development.- No problem of table structure synchronization during development.Disadvantage:– Not independent of the database, so the fact that a shop can view the data of another shop if it has SQL access, is really a big problem.- The problem of backing up and restoring data for each shop is almost impossible. possible, can only backup for all.- The problem arises really complicated when the data swells, it is very difficult to backup, restore…- Difficult to scale the system.Advice: This option is only used for small systems with little data, generating small data.Option II.

See more: Top 30+ Good Offline Games For Phones

Same database, shared schemaThis design direction uses one database, each tenant corresponds to one schema. There is a common schema to manage common data, manage information about tenants. The structure of the tables in all tenants is the same. A standard schema is needed to create a new tenant during the process of adding a new tenant. Strengths:– Designed in this direction, it is possible to change separate structures, functions, and procedures between tenants.- Easier to decentralize than option 1.- Save costs when deploying (because the number of databases is only a small amount). very few)Disadvantage:– The option of independent backup for each tenant is a difficult problem, the programmer will have to manage the backup / restore for each tenant by code.- The synchronization of changes in the schema structure is a matter of concern. – The data in the database will swell quickly.- The number of schemas in a database is limited.- Difficulty in scaling the system.Option III.

See also: Download Game Nexo Knights, Lego® Nexo Knights™: Merlok 2

Each tenant a database. This option will do the following: the system will include a common database (specialized in managing parts such as tenant list, user, role …), a standard tenant database (containing standard data), and other tenants.Each tenant will be a database, the user will have access to the common database and that user’s database tenant.I will attach the sql server script to create databases for the above options, option 3 is like Option 2, but instead of using schema, switch to using database.

Category: FAQ

About Troubleinthepeace

Troubleinthepeace specializing in synthesizing information about daily life activities

View all posts by Troubleinthepeace →

Trả lời

Email của bạn sẽ không được hiển thị công khai.