1
Projects and Discussion / Re: Multi-tenant db versus single-tenant db
« on: December 15, 2015, 05:53:47 am »
It's almost impossible to answer your question, sadly, because alot of critical information is lacking. The multiple vs single tenant question relies on several factors. We have no idea of the architecture of your system, how many clients, etc.
Do you have any numbers ? #clients, #connections, data? To put it super simply, skimming both the fiscal cost and time investments I'd usually say: Single (it's quicker and easier), if you are within the constrains of a single database server (and staying there), and NEED the added value of advanced data mining structures you can consider multiple. I have basic experience with multiple tenant sass applications and I stumbled upon a shit paper, but it describes mult. tenants ok:
https://sdqweb.ipd.kit.edu/publications/pdfs/KrMoKo2012-closer-multitenant-sass.pdf
To reiterate: Gather more info, dont listen to us. Look at the demands of the application and the chances you guys have for investment. Multiple tenant solution has a higher chance of yielding better returns, but it requires substantial effort to accomplish.
I'd highly recommend against a hybrid solution unless it's a research project. For once the silly buzzwords are viable; think of scalability (important as FCK if you're growing fast), availability, and MAINTAINABILITY. If you're keeping the application alive for years to come, being able to rely on the work of other people becomes increasingly important and maintainability is a huge factor.
Do you have any numbers ? #clients, #connections, data? To put it super simply, skimming both the fiscal cost and time investments I'd usually say: Single (it's quicker and easier), if you are within the constrains of a single database server (and staying there), and NEED the added value of advanced data mining structures you can consider multiple. I have basic experience with multiple tenant sass applications and I stumbled upon a shit paper, but it describes mult. tenants ok:
https://sdqweb.ipd.kit.edu/publications/pdfs/KrMoKo2012-closer-multitenant-sass.pdf
To reiterate: Gather more info, dont listen to us. Look at the demands of the application and the chances you guys have for investment. Multiple tenant solution has a higher chance of yielding better returns, but it requires substantial effort to accomplish.
I'd highly recommend against a hybrid solution unless it's a research project. For once the silly buzzwords are viable; think of scalability (important as FCK if you're growing fast), availability, and MAINTAINABILITY. If you're keeping the application alive for years to come, being able to rely on the work of other people becomes increasingly important and maintainability is a huge factor.