Questions tagged [multi-tenant]
A database architecture where multiple tenants share a single database or server. Also known as multi-client.
1
vote
3answers
37 views
Multiple instance in one server
Could you please help to explain why one might need multiple instances of SQL Server on the same server? What is a good point to use separate instances? Why wouldn't one use two databases in one ...
2
votes
2answers
49 views
What is better - having 10 databases for 10 organisations or 1 table for 10 organisation with org_id? [duplicate]
I am making a web service (using Laravel in case that is relevant) that will have many separate organisations generated by the service.
Considerations
I can manage all organisation data in one ...
1
vote
1answer
85 views
How to Prevent heavy queries on one database, affecting the performance of other databases on same server?
I have a linux server running just Postgres with PostGIS Extension. There are several databases on this instance of the Postrges Server.
One of the databases has some computationally intensive ...
0
votes
1answer
53 views
Reference a schema from public table column
I have a multi-tenant Postgresql database with each schema belonging one of our customers (tenants). Each tenant has a table called Messages. So CustomerX.Messages contains all of the messages that ...
0
votes
1answer
87 views
Isolating access to tenant data in a multi-tenant database
We have a single SQL Server database for all tenants of a web-application. How can we ensure when a support engineer queries the DB directly via SSMS, they only touch data belonging to one tenant?
...
1
vote
0answers
38 views
Multi tenant .NET Core application
We are designing a new multi tenant .NET Core 2.1 application progra, where we are using one database per tenant.
We can give each tenant a different subdomain so that we can base the tenant lookup ...
1
vote
1answer
312 views
How to do per-tenant backups for multi-tenant databases?
Are there any best practices, experiences or guidelines when it comes to do per-tenant backups/restores in a microservice multi-tenant application?
In my case I have multiple Postgres servers which ...
1
vote
1answer
51 views
Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?
I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of sp_set_session_context to make sure that any query only touches records relevant to the current tenant.
I ...
2
votes
1answer
289 views
What are the downsides of using PARTITION for multi-tenant access?
We have an RDS Postgres database which keeps individual store data in a common schema with a field called store_id to distinguish between stores. Let's say we have 1MB per store and 10k stores so we'...
1
vote
1answer
43 views
MongoDB as a log storage. Choosing shard key
I'm designing a log storage system based on MongoDB.
I want to shard a log collection to increase ingestion and capacity (distribute writes to several machines) while allow fast search.
I should be ...
1
vote
1answer
94 views
How to build the database for subdomain multisite? [closed]
I'm building a kind of "multi site application" based on wildcard subdomain. And every site will of course have the same files but also the same database structure. But it's not necessary for each and ...
0
votes
1answer
45 views
Any DBMS with table structures and data defined separately?
I'm working on an application which is being used in multi-tenant mode, and have created a MySQL database instance, where each tenant has its own schema. The problem I'm facing is, because the ...
0
votes
2answers
95 views
Multiple databases or tables with prefix?
I was creating an Accounting ERP for a multibrach company.Normally i would keep different databases for different branches, Can anyone tell me which is the standard way?
1) create databases respective ...
0
votes
0answers
45 views
Multi Tenancy Report Solution
I have a separate database per a client although data structure is same for all databases. Only difference is all clients have their own data on their on databases. Now problem is when I need a report ...
2
votes
2answers
2k views
Multi-schema, multi-tenant databases - data isolation through composite primary keys
We are designing a multi-schema, multi-tenant database for SQL Server 2016 that will service a basic CRUD application which will see small to medium transactional throughput and comprise of 15-20 ...
0
votes
1answer
296 views
How can I be specific about which CDB I want to connect to wrapping a PDB?
I'm quite new to Oracle. I created a CDB like cdb1 and then a PDB within like pdb1. Now I can connect to my PDB using something like:
sqlplus user/password@server:port/pdb1
But can't I have two PDBs ...
0
votes
1answer
310 views
CREATE PLUGGABLE DATABASE REFRESH MODE MANUAL from remote fails with ORA-00922
I'm doing some test with remote PDB cloning. Both local and remote instance are
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
"...
1
vote
2answers
125 views
MySQL - Design + Optimization Question [closed]
I feel like I may of made a mistake with my database design.
At the moment I have 73182 tables, 4 days ago I had 72236, and just 2 months ago we only had about 20k tables - so our growth spiked.
...
0
votes
1answer
162 views
SQL Azure large multi-tenant table / lock escalation issue / partitioning / full text index
Our app organizes its data in "projects" that are saved in an SQL Azure database. A project can contain 100s or 100'000s of rows (spread over 35 tables). Since we have 1000s of projects, using a ...
0
votes
1answer
379 views
Multi-Tenant shared Users Tables: Need an advice
Am writing multiple Multi-Tenant applications with separate database per each application (I've decided to go with shared database different schema approach). Each application have Staffs Table for ...
4
votes
1answer
1k views
Recommendations on Partitioning Multi-Tenant Data in SQL-Server
I would appreciate input on design considerations for partitioning (or not) a multi-tenant business application. All data tables use a composite key that looks something like:
CREATE TABLE SomeTable(...
1
vote
1answer
127 views
How calculate per tenant disk usage in a multitenant database with tenant_id columns in postgresql
I am using Django and postgres for a multi-tenant webapp. We have around 100 tables and each table has a tenant_id column, identifying the tenant of that particular row. I need a solution that would ...
5
votes
3answers
2k views
SQL Server: Clustered index, sorting and pagination
In my application, several times I have to show results that are paginated and sorted by some field.
For example a simple user list sorted by last name. Because of that and because I also have ...
0
votes
2answers
71 views
Common term for tenant-based keys [closed]
Assume the following schema:
ID | TENANT | TENANT_CUSTOM_ID
346 | 101 | 1
347 | 102 | 1
348 | 101 | 2
349 | 101 | 3
350 | 101 | 4
351 | 102 | 2
352 | 103 | 1
What ...
1
vote
3answers
152 views
Best way to store different types of data in a single column, which should be query friendly - MySql
I'm working on a project in which user can create their own web services from UI by simply selecting number of fields (Max 200) and defining datatype for each field.
I'm considering following table ...
1
vote
2answers
657 views
Performance tuning for multi-tenant database
The database, MS SQL 2014 Standard Edition, is becoming a bottleneck in our multi-tenant web application. Aware that most performance issues can be solved by making code more efficient, however ...
0
votes
2answers
97 views
Modelling users and groups - but with multiple types of groups
I'm modelling a user management system in PostgreSQL that is fairly typical in that it consists of users, groups and permissions (and the relationships between them).
However, its seems I'm dealing ...
0
votes
1answer
604 views
Multi-Tenant Design with Single DB & Single Schema approach using Sql Server
How would you design the tables which should isolate the data using TenantId in a single table? I came up with two approaches, written down the has pros and cons with my little experience, but I would ...
0
votes
1answer
377 views
Multi Tenancy and shared customers
I am developing multi-tenancy application and I have no problem with the architecture itself. I find difficult on how to make customers table shareable among tenants. This is because same customer can ...
8
votes
2answers
1k views
Is having relationships between separate databases bad practice?
I am working with a client that has multiple databases. There are several master level databases that have relationships back to them from instance level databases (application specific DBs). The ...
5
votes
1answer
3k views
ARCHIVELOG in Oracle 12c multitenant PDB
In a Oracle 12c multitenant DB instance with multiple PDBs, is it possible to enable ARCHIVELOG mode on a single PDB?
1
vote
1answer
205 views
How to isolate client data on the same application using MySQL
I have made an application which has a companies table at the moment. It would work fine for a few clients (~100 companies, according to my scaling calculations). The application is a simple CRUD app ...
1
vote
0answers
48 views
Resource cost of database per tenant
I've read that one big disadvantage of the database per tenant model in multi-tenant applications is the extra resource cost of having many (potentially thousands or tens of thousands) databases ...
12
votes
3answers
6k views
Should a multi tenant system with SQL Server 2016, Shard or have Tenant isolation via separate database per tenant?
Given the use case:
Tenant data should not cross talk, one tenant does not need another
tenant's data.
Each tenant could potentially have large historical data volume.
SQL Server is hosted in AWS ...
1
vote
1answer
2k views
Multiple MongoDB databases (1 per client) and sharding - are they compatible?
Currently I'm working with one MongoDB database per client, on a single replica set. We would like to keep one database per client because of security concerns.
Each client has the same 15 ...
2
votes
1answer
1k views
Multi-tenant database
We are building a database for a SaaS web application. We have been told to use a multi-tenant approach and to expect over 100,000 tenants to be using the system over the next 5 years, so we're ...
3
votes
1answer
4k views
Mysql & multi-tenant db: the best way to organize? [closed]
I've never completed any multi-tenant project before...
What is the best way to organize multi-tenant db using mysql? and to seperate access between different companies?
sure it can be done in a ...
3
votes
2answers
2k views
Can I use a single stored procedure to operate on different schemas based on the executing user
I have thousands of schemas with same set of tables, Each user has a default schema. But I dont want to create copies of a single stored procedure in every schema. Can a single stored procedure access ...
2
votes
0answers
349 views
Postgres role security for multi-tenant database
I have a multi-tenant application where the Postgres DB schemas are set up as follows:
_admin (tables that are invisible in the UI to standard users but need to be read-accessible, common across all ...
-1
votes
1answer
559 views
Does SQL Server 2014 have a feature like Oracle Multitenant databases?
In Oracle 12c, a feature called Multitenant databases is available. This way you can have two seemingly separate databases installed on one system, yet be able to manage Backups and Resource ...
1
vote
1answer
81 views
Multitenant application: several tables or several IDs?
We are designing a common product to serve several companies. The most convenient way to do this, technically speaking, is to deliver a database to each customer.
But we predict that, depending on ...
0
votes
2answers
793 views
Plug a PDB in a new CDB without XML manifest
In oracle 12c the ALTER PLUGGABLE DATABASE "PDB1" UNPLUG INTO 'PDB1.XML' statement create the XML manifest.
Is it possible to plug a PDB in a new CDB if it isn't correctly unplugged first and the ...
3
votes
1answer
123 views
Multiple Databases for one web solution
I am working on a new project and I am in the process of designing the Microsoft SQL Server database behind the system.
The system will contain an infinite amount of customers and each customer has ...
1
vote
0answers
880 views
Generate tables from entities with hibernate
I'm using postgresql with a spring/hibernate to create a multi-tenant application where every company will have its own seperate schema and tables in the database.
So when the super administrator ...
3
votes
1answer
969 views
SQL Server Multi Tenancy Setup
What is the best way to use Multi Tenant Database Architecture when all of the "Tenants" will be from the same company?
We are going to be using AWS and SQL Server for our backend system. We ...
3
votes
1answer
632 views
Multi-tenant database constraints
I have a multi-tenant app in PostgreSQL that has a repeated tenant_id column in each table to help isolate the tenants from each other.
My question is, is there any sort of way that I can use ...
13
votes
1answer
3k views
Composite Primary Key in multi-tenant SQL Server database
I'm building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure database. This app will be used by 1000-5000 customers. All the tables will ...
8
votes
1answer
4k views
Pros and cons of using many schemas in PostgreSQL as opposed to just one?
For a large SAAS application (backed by PostgreSql 9.4), with over 300,000 accounts (and growing), what are the pros and cons of using a schema per account to partition the data vs putting all the ...
1
vote
0answers
310 views
How calculate per tenant disk usage in a multitenant database with tenant_id columns?
I would like to provide forum hosting as a service, for forum software I'm developing. The data is stored in a PostgreSQL database, in tables with a forum_id column. That is, all forums share the same ...
6
votes
1answer
2k views
What are the Oracle Dataguard Implications of Migrating to a PDB?
If I have an OLTP database with two physical standby instances (one remote) what are the implications of migrating the primary DB to being an Oracle 12c PDB? i.e. Does the process of migrating to ...
