Skip to content

Handle Network Fluctuations in MySQL Master-Slave Mode

The high availability guarantee in MySQL master-slave mode is independent of the cluster, which can lead to misjudgments. For example, consider the following cluster:

Suppose the master's network experiences a brief disconnection (lasting longer than the failover tolerance time set by orch). Orch will perform a failover, promoting one of the slaves to master. However, if the master's network recovers shortly after the switch, this failover operation would be redundant.

To handle such scenarios, we can disable orch's automatic switch capability for the MySQL cluster.

Note

This is applicable in situations where the network status of the cluster is uncontrollable. The principle is to ignore the master when orch detects that the master's network is unreachable.

Steps

  1. For the common-mysql database, use Helm to update the operator:

    helm -n mcamel-system get values mysql-operator > values.yaml
    
  2. Retrieve the values set during the previous installation and upgrade the mysql-operator:

    helm upgrade \
      --install mysql-operator \
      --create-namespace \
      -n mcamel-system \
      --cleanup-on-fail mcamel-release/mysql-operator \
      --version 0.14.0-rc2 \
      -f values.yaml
      --set "orchestrator.config.RecoveryIgnoreHostnameFilters[0]=^mcamel-common"  # (1)!
    
    1. This is a regular expression that will match with the MySQL pod names.

Note

Ensure that the operator restarts after execution is complete. Ensure that the mysql-operator-orc configmap includes the content set by --set after execution is complete.

Verification Procedure

  1. Create a 3-node master-slave cluster (with -0 as the master), ensuring the name matches the regular expression set above:

  2. Disconnect the master's network:

  3. Observe that no master switch occurs:

  4. Observe that the cluster has returned to normal, with -0 still as the master:

Note

Additionally, verify that for clusters whose names do not match the regular expression set above, the same steps result in a normal switch.

Comments