Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [multi-tenant]

A database architecture where multiple tenants share a single database or server. Also known as multi-client.

A database architecture where multiple tenants share a single database or server. A tenant is a group of users who share a common access with specific privileges to the database and may be classified as groups of users or a customer. In most cases, each tenant is completely unaware that they are not the only tenant of the system.

102 questions
27
votes
1 answer

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 have TenantId (Guid / UNIQUEIDENTIFIER) field.…
Reynaldi
  • 371
  • 3
  • 5
15
votes
3 answers

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 EC2 instance. Each tenant is geographically…
D.S.
  • 365
  • 4
  • 10
9
votes
1 answer

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 data in one schema and using foreign keys to…
Harel
  • 303
  • 1
  • 3
  • 8
7
votes
1 answer

How to create an efficient, scalable, multi-tenant data layer using MongoDB?

I'm working on the architecture for my upcoming Project Mangement app (as an example) and I'm seeking clarity on how best to design the MongoDB data layer, with specific regard to multi-tenancy. The app will have multiple 'sub-apps' (e.g. Calendar,…
AJB
  • 395
  • 1
  • 3
  • 8
7
votes
2 answers

How to handle connection pooling for massive multi-tenancy/multi-schema environment

Here's a quick run down of the situation: We have 1 Schema per customer. We have 2000+ customers. We have 50+ Database servers (with the above schema's distributed unevenly amongst them). We are creating a true stateless app frontend (i.e.…
adewinter
  • 171
  • 1
  • 2
7
votes
2 answers

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 relationships from instance to master are integer…
DDiVita
  • 173
  • 4
6
votes
1 answer

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 being a PDB send a sensible EOR record via Dataguard…
teagles
  • 138
  • 7
6
votes
5 answers

SQL Server with multiple databases (one per client) - what is the best security practice in terms of logins/users/permissions?

We have multiple SQL Servers with each holding dozens of databases - one per client (a client in this case means a customer organization). These databases are accessed via an application, but the application is currently using a single Windows…
SQL_Guy
  • 685
  • 7
  • 19
6
votes
1 answer

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?
sgargel
  • 337
  • 1
  • 9
  • 22
6
votes
1 answer

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 database constraint to make sure the tenant_ids are…
cdmckay
  • 433
  • 1
  • 3
  • 12
5
votes
1 answer

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( TenantId SMALLINT NOT NULL, ID INT NOT…
cyriously
  • 53
  • 1
  • 3
5
votes
3 answers

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 logical deletion and it's a multi-tenancy application, I…
Diego Jancic
  • 451
  • 5
  • 15
5
votes
1 answer

Mysql & multi-tenant db: the best way to organize?

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 different ways: different database for each company …
PavelBY
  • 193
  • 2
  • 8
4
votes
1 answer

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 are regularly backed up as a whole. Each of them…
xcq1
  • 43
  • 5
4
votes
1 answer

What is the best practice for physical deployment of data marts?

We are just starting to get into business intelligence at our company. We have some architects who are designing our data warehouse and also our data marts. They are using star schema for both designs. The architects have stated that the design they…
Chris Aldrich
  • 4,916
  • 5
  • 34
  • 55
1
2 3 4 5 6 7