Join the MemSQL 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.