public-cloud-roadmap icon indicating copy to clipboard operation
public-cloud-roadmap copied to clipboard

Published 20 hours ago • verified publisher icon ovh

Managed database read replica from another region

Open matmicro opened this issue 2 years ago • 4 comments

As a managed Database user, i would like to be able to create a read replica of my database on another region (eg. GRA). Eg. My master node (RW) is in GRA, but i need a readonly replica in DE.

This functionality is already available from Aiven cloud.

matmicro avatar Jul 17 '22 07:07 matmicro

A quick update on this topic as we are discussing it internally and we are curious to what you are trying to achieve with this feature.

Here are a few benefits that come to mind:

  • Scalability: reduce the load on the primary service
  • Data at edge: optimize query response times across different regions
  • Disaster recovery: manually promote a replica to primary in case of disaster

Is there one use case especially appealing to you ? Is it a mix ? Is it something else entirely ?

thild42 avatar Jan 23 '24 15:01 thild42

Main purpose is the Disaster Recovery (eg replication between GRA and RBX).

2nd use case is reducing response time.

3rd use case is being under investigation, would be to help synchronizing data between DC in France and DC in Australia.

matmicro avatar Jan 23 '24 16:01 matmicro

Thanks for the feedback. Be sure to thumb up #283 for the 3rd point.

thild42 avatar Jan 24 '24 07:01 thild42

Disaster recovery. Clients demand that there is a live copy of the database in another region.

Thank you.

vergeetsok avatar Jan 28 '24 12:01 vergeetsok