One of the key benefits of tenant virtualization in Nile’s Postgres is that you can decide on placement strategies for individual tenants instead of an entire database. While tenants are placed differently, you would want the clients to work seamlessly and route correctly. Placements are of two types
  1. Regional placement. You may want to place individual tenants (customers) in different regions in the world for compliance or latency reasons.
  2. Infrastructure placement. You may want to place tenants in a multitenant or dedicated infrastructure. The decision for this will depend on the customer needs, cost and level of isolation needed. Nile plans to support both types of placements. This feature is in progress and we would love to hear from you on our Github discussion forum or Discord community.
The documentation here is subjected to change based on user feedback but the capability to have fine grained control over tenants will be supported in Nile’s Postgres.

​
Regional placement

We wanted to make global placements really easy while abstracting all the hard parts to manage them. We would support the ability to locate a tenant in any location globally while creating the tenant. We hope to also support the ability to move tenants from one location to another with a simple update statement to the region of the tenant. This will probably come after we support placement during creation. The Nile SDK will seamlessly route to where the tenant is located. The shared tables (check ‘Sharing Tenants’ section) will be accessible across all the tenants irrespective of where the tenant is located. 
insert into tenants (name, region)
values ('customer 1', 'aws-us-east1');

insert into tenants (name, region)
values ('customer 2', 'aws-eu-west1');

​
Infrastructure placement

A very common pattern with SaaS is to control what infrastructure are specific customers placed. There are many reasons to do this. A customer might explicitly want their data to be placed in an isolated database for security reasons, the tenant could be a critical customer for the business or your isolation strategy could be to simple place every tenant in a dedicated database. Placing a tenant on a dedicated mode. The default instance would be used in this case. 
insert into tenants (name, region, deployment_mode)
values ('customer 2', 'aws-us-east1', 'dedicated');
Given dedicated may not be instantly provisioned in all cases, the status field would indicate if the tenant is ready to be used. 
select * from tenants;
idnameregiondeployment_modestatuscreatedupdateddeleted
018ac98e-b37a-731b-b03a-6617e8fd5266customer1aws-us-east1dedicatedprovisioning2023-09-24 23:38:07.0976332023-09-24 23:38:07.097633
The tenant would be ready after a few seconds or minutes. 
select * from tenants;
idnameregiondeployment_modestatuscreatedupdateddeleted
018ac98e-b37a-731b-b03a-6617e8fd5266customer1aws-us-east1dedicatedready2023-09-24 23:38:07.0976332023-09-24 23:38:07.097633
There would also be a way to specify specific instance type for a tenant in dedicated mode. This is still very early in development and we would love your thoughts or your use case on our Github discussion forum or our Discord developer community.