You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

Disaster Recovery

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:

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