How to add read replica tenants? #512
Description
I want to test using read replicas in supabase self-hosted docker compose stack.
Currently it uses this file to bootstrap a tenant with a db. I would like to modify the docker compose stack to add another db that will be a read replica and I would like to know how to proceed about registering it in Supavisor. Also I would like to know if the supabase api requests from other services like postgrest, auth, storage will be split into read/write to load balance into the tenants according to the type of tenant. Is this something that is handled by Supavisor?