When it comes to managing multi-tenancy, there are a number of architectural routes you can take. A couple of the most popular are:
- Create a database per tenant.
- Use a single database but with tenant IDs to separate out data.
Both of these options have pros and cons, but getting into that is not the intention of this blog. Today we'll be exploring what option 1 may look like on a single CockroachDB cluster.