multitenant approach- single aware IM code with perclientdbs

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

multitenant approach- single aware IM code with perclientdbs

Post by swiftinitpvtltd »

Option 3 - Exactly the same as option 2, except you have 1 database for each and every client, completely isolating them from other clients, and theoretically providing a bit more protection that if 1 client's tables were hacked or otherwise damaged, it wouldn't affect anyone else. The biggest downside is that when deploying a new client, an entire database, user and password need setting up, etc. Could this possibly also cause a fair amount of overhead, or would it be pretty much the same as if you had everyone in one database?

https://stackoverflow.com/questions/484 ... tenant-sql
Option 3 is the most scalable. While at first it may seem more complicated, it can be completely automated and will save you headaches on the future. You can also scale more efficiently by having client databases on multiple servers for increased performance.


Can this be done technically in aware IM(aware IM way and not external db way because external db has limitations in aware IM) where sample project management app(single business space) remains the same for all clients but each client login will have separate db(single Business space pointing to 10 db's if app has 10 clients).
Post Reply