search

ovh / public-cloud-roadmap

Agile roadmap for OVHcloud Public Cloud services. Discover the features our product teams are working on, comment and influence our backlog.
https://www.ovhcloud.com/en/public-cloud/
185 stars 5 forks source link

PostgreSQL Synchronous replication #513

Open matmicro opened 1 year ago

matmicro commented 1 year ago

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.

thild42 commented 1 year ago

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 ?

matmicro commented 1 year ago

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) ?

matmicro commented 1 year ago

Did you get feedback from Aiven ? Any ETA to have this synchronous replication available ?

Regards

thild42 commented 11 months ago

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.

matmicro commented 7 months ago

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).

matmicro commented 5 months ago

Can we get progress on that please ? ETA to be able to see the value of config "synchronous_replication" ?

matmicro commented 3 months ago

Any update to expose this config parameter please ?