Read-only replicas enable you to perform read-only queries against the replica and reduce the load on the primary server. It is also a good way to optimize query response times across different geographical locations, because the replica can be placed in different regions or even different cloud providers.
Before you begin, make sure you have:
- Created a service in your Managed Service for TimescaleDB account.
- Installed Aiven Client.
In the Aiven client, connect to your Managed Service for TimescaleDB service.
Switch to the project that contains the TimescaleDB service you want to create a read-only replica for:avn project switch <PROJECT>
List the services in the project, and make a note of the service that you want to create a read-only replica for. It is listed under the
SERVICE_NAMEcolumn in the output:avn service list
Get the details of the service that you want to fork:avn service get <SERVICE_NAME>
Create a read-only replica:avn service create <NAME_OF_REPLICA> --project <PROJECT_ID>\-t pg --plan <PLAN_TYPE> --cloud timescale-aws-us-east-1\-c pg_read_replica=true\-c service_to_fork_from=<NAME_OF_SERVICE_TO_FORK>\-c pg_version=11 -c variant=timescale
To create a fork named
replica-fork for a service named
avn service create replica-fork --project fork-project\-t pg --plan timescale-basic-100-compute-optimized\--cloud timescale-aws-us-east-1 -c pg_read_replica=true\-c service_to_fork_from=timescaledb -c\pg_version=11 -c variant=timescale
You can switch to
project-fork and view the newly created
avn service list
Found an issue on this page?Report an issue!