docker-images icon indicating copy to clipboard operation
docker-images copied to clipboard

Published 20 hours ago • verified publisher icon oracle

Oracle Sharded Database Disaster Recovery across data centre in Kubernetes

Open viju2008 opened this issue 3 years ago • 6 comments

Hello,

Is it possible to implement replication of Oracle Sharded Database in Kubernetes for cluster to cluster replication of Oracle Databases on Kubernetes

Scenario:

If we have a Sharded Database in Cluster-1 in Data Centre 1 and if we have to set up a Disaster Recovery of the Sharded Database in Cluster-2 in Data Centre 2 and then replicate the Shards in Data Centre1 using Oracle Data Guard or Oracle Active DataGuard.

All the shards in PR will be replicated to DR. At present we plan to have 1 shard per microservice and all these shards will be replicated to DR. All writes will go to one data centre only. All shards will have 2 replica in PR and a mirror replica in DR . If shard 1 fails in PR, it will failover to replica of the shard in the same data centre. When we switchover to DR we shall work on the Shard Replica in DR. So there will be 3 copies of the data at any point of time (2 in PR and one in DR)

Please inform us if the same is possible using Kubernetes. Please provide the YAML. In case it is not possible , please inform what approaches of switchover from PR to DR are possible in Shard Database for Kubernetes.

Whenever we switch over to DR, the applications in Data Centre 2 will access the DataCentre 2 DB which would have all the data as it is being synced by Oracle DataGuard.

viju2008 avatar Apr 06 '22 06:04 viju2008

Please check with @psaini79

yunus-qureshi avatar Apr 06 '22 07:04 yunus-qureshi

@viju2008

This is possible and we need to make sure all the pods between the 2 DCs are reachable. Can you create Oracle SR and connect with us? we can discuss the design and requirement in detail

psaini79 avatar Apr 07 '22 00:04 psaini79

We do not want the kubernetes cluster to span across datacentre. They will be two indepenedent cluster. Connectivity between the DCs is available

viju2008 avatar Apr 07 '22 03:04 viju2008

Sure. Do you have access to Oracle SR? If yes, can we connect? In general, we should be able to reach the pods using service. However, it requires some more testing and we can discuss it in details once we see your network diagram.

psaini79 avatar Apr 07 '22 03:04 psaini79

SR 3-29175456701

viju2008 avatar Apr 07 '22 12:04 viju2008

Is it possible for someone in European time zone or singpore time zone or indian time zone to assist us so that we can work together

viju2008 avatar Apr 08 '22 01:04 viju2008