5 ms·

Is there a mechanism for replicating shared/system data across tenants? Can I deploy into a specific AWS or GCP region?

• infra_dev 3y ago
  Currently, we support only AWS but do want to support other cloud providers. Technically, you can even have one DB that spans across cloud providers with your tenants, but we have not yet seen many use cases for multi-cloud. W.r.t replicating data across tenants, could you give an example use case for it?
  • rsweeney21 3y ago
    Let's say I'm building a CRM and I want to have an "industry" or "cities" table that is the same across all tenants. I want a copy of cities in each tenant for referential integrity, but I also need to update it periodically across all tenants.
    • infra_dev 3y ago
      Great question. Nile supports shared tables for this purpose. Shared tables are regular tables that can be shared across all the tenants in another table. We have example use cases and how this works in Nile here https://www.thenile.dev/docs/tenant-sharing https://www.thenile.dev/docs/tenant-sharing. Let me know if this works for you.
      • rsweeney21 3y ago
        That sounds like exactly what I was looking for. Impressive!