Outdated Version

You are viewing an older version of this section. View current production version.

Disaster Recovery

Info

Version 7.1.12 of SingleStore DB is not forward compatible with previous versions. For disaster recovery purposes, in the case that one cluster is already running this version, the other must be upgraded to 7.1.12 as well. With the exception of 7.1.12, all maintenance releases for a given version of SingleStore DB are forward compatible unless otherwise stated.

Users may declare a replicationSpec section to enable replication and Disaster Recovery (DR). This is an optional section that can be added to the memsql-cluster.yaml file to enable replication and DR between a primary cluster and a secondary cluster, and to specify which connection model should be used across the two clusters.

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