public-cloud-roadmap
public-cloud-roadmap copied to clipboard
ovh
Managed DB Postgres synchronous replication
As a Postgresql Managed Database, from Business plan, i need a synchronous replication from my master (read/write) node to my slave (read only replica) node.
From Enterpris offer (1 master + 2 replicas) also. Or can be optionally configurable for backup node (3rd node).
This settings might be configuratble from advanced configuration.
The current offer is asynchronous replication.
Current offer is indeed asynchronous by default.
There is an advanced parameter synchronous_replication to make the replication synchronous.
What you want is to have this option both for Business and Enterprise plan ?
Yes it should be available for both Business and Enterprise. But maybe for enterprise it should be also configurable for the 3rd node.
Any ETA to have this available ? (from API and/or UI) ?
Did you get feedback from Aiven ? Any ETA to have this synchronous replication available ?
Regards
After some testing the advanced parameter synchronous_replication could be made available on the Enterprise plan.
Currently, Essential and Business are not supported by Aiven.
Is this setting available from Manager UI ? Could we get confirmation that if we scale down from Enterprise plan to Business plan the synchronous_replication is disabled or not ? (to know if we must do the change ourself or not).
Can we get progress on that please ? ETA to be able to see the value of config "synchronous_replication" ?