Multi-tenant database VS single-tenant databases under shared compute
We currently use a large multi-tenant database and are considering switching to tenant-specific databases. Beyond data separation, are there any performance differences between one large multi-tenant database on a single compute VS using isolated single-tenant databases on shared compute?
2 Replies
unwilling-turquoise•2y ago
The only practical difference I can think of is the requirement that you must use different connections to different databases, whereas a multi-tenant database can reuse connections to the same database. Depending on your compute size, you might run into connection limitations and need to close and open connections more often which can impose some increase in observable latencies
fair-rose•14mo ago
We published a video about multi-tenancy that you can check out https://discord.com/channels/1176467419317940276/1176467419938701375/1289308541638934578