Disaster Recovery

Disaster Recovery (DR), which is based on REPLICATE DATABASE, can be enabled when running SingleStore on Kubernetes.

Users may declare a replicationSpec section to enable replication and DR. This is an optional section that can be added to the sdb-cluster.yaml file of the primary and secondary clusters to enable replication and DR between them, and to specify which connection model should be used.

replicationSpec:
  enable: true
  connectivity: viaHost

To support replication and DR, either of the two following requirements must be met by the underlying infrastructure:

• Kubernetes hosts in primary and secondary clusters can reach each other via host IPs across clusters

• Kubernetes pods in primary and secondary clusters can reach each other via pod IPs across clusters

In addition, the following requirements must be met:

• SingleStore 7.1.3 or later must be deployed on both the primary and secondary clusters

• The primary and secondary clusters’ DDL endpoints are stable

Valid values for the fields in replicationSpec are:

• For the enable field: true, false

• For the connectivity field: viaHost, viaPod

  • Use viaHost when Kubernetes hosts in primary and secondary clusters can reach each other via host IPs across clusters

  • Use viaPod when Kubernetes pods in primary and secondary clusters can reach each other via pod IPs across clusters

Refer to REPLICATE DATABASE for more information.