I am currently working on a multi tenant system for SaaS, but due to my lack of experience before, I have some doubts about having more tenants.
- Currently, a single database is used to distinguish the data of each tenant based on their ID, Nowadays, with a large amount of data, efficiency is very low. We have considered having one library for each tenant, but the product is not mature enough and we often modify data tables, which undoubtedly increases the workload.
- The database uses MySQL, and now tenants have different queries for data, covering almost all fields. How to optimize or implement it through other technical solutions.
- In terms of field management, different tenants have different needs and propose customization at the field level. Customization should be implemented for whether each unit is enabled, field aliases, field permissions, list display, import and export. I hope you can provide some experience or insights. If there are any cases, it would be great. Thank you
We have considered having one library for each tenant, but the product is not mature enough and we often modify data tables, which undoubtedly increases the workload.