Skip to main content

SingleStoreDB v8.1

Disaster Recovery

Disaster Recovery (DR), which is based on REPLICATE DATABASE, can be enabled when running SingleStoreDB 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:

  • SingleStoreDB 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.

In this section: