News for hackers. Stuff that matters.

A comment on Multi-Tenant Architectures. Parent comment

Re:Multi-Tenant Architectures by yabai_yatsu on Sunday August 30, 2020 @03:46PM (#24325395)
Not really. Your queries don't have to contain tenant Id if as part of your tenant context they have a connection string to their tenant DB.
[ Parent | on HN ]
Re:Multi-Tenant Architectures by jawr on Sunday August 30, 2020 @05:47PM (#24326198)
Wouldn’t that mean you’re holding lots of non reusable connections?

I have recently been using row level security with a transaction middleware where I set the tenant ID.

Nice article regarding it - https://aws.amazon.com/blogs/database/multi-tenant-data-isol...

[ Parent | on HN ]
Re:Multi-Tenant Architectures by yabai_yatsu on Monday August 31, 2020 @03:55PM (#24335331)
We have about 6 physical DB servers, each client has their own db/schema on one of those boxes. Several thousand clients each with 10s of users per client. It brings in $15m ARR.

So, it works.

We're wanting to move off that architecture to something more future proof, but it's not our biggest pain point at this point in time.

[ Parent | on HN ]