MySQL Shell 9.0  /  MySQL InnoDB ReplicaSet  /  Asynchronous Replication Channel Options

9.4 Asynchronous Replication Channel Options

The following options can be set with replicaSet.addInstance() and replicaSet.setInstanceOption():

  • replicationConnectRetry: corresponds to the replication option SOURCE_CONNECT_RETRY. Specifies the interval in seconds between the reconnection attempts that the replica makes after the connection to the source times out.

  • replicationRetryCount: corresponds to the replication option SOURCE_RETRY_COUNT. Sets the maximum number of reconnection attempts that the replica makes after the connection to the source times out. D

  • replicationHeartbeatPeriod: corresponds to the replication option SOURCE_HEARTBEAT_PERIOD. Controls the heartbeat interval, which stops the connection timeout occurring in the absence of data if the connection is still good.

  • replicationCompressionAlgorithms: corresponds to the replication option SOURCE_COMPRESSION_ALGORITHMS. String that specifies the permitted compression algorithms for connections to the replication source.

    Note

    Compatible with MySQL Server 8.0.18 or higher, only. Using on an earlier version results in an error.

  • replicationZstdCompressionLevel: corresponds to the replication option SOURCE_ZSTD_COMPRESSION_LEVEL. Specifies the compression level to use for connections to the replication source server that use the zstd compression algorithm.

    Note

    Compatible with MySQL Server 8.0.18 or higher, only. Using on an earlier version results in an error.

  • replicationBind: corresponds to the replication option SOURCE_BIND. Determines which of the replica's network interfaces is chosen for connecting to the source, for use on replicas that have multiple network interfaces.

  • replicationNetworkNamespace: corresponds to the replication option NETWORK_NAMESPACE. specifies the network namespace to use for TCP/IP connections to the replication source server or, if the MySQL communication stack is in use, for Group Replication’s group communication connections.

    Note

    Compatible with MySQL Server 8.0.22 or higher, only. Using on an earlier version results in an error.

For information on default values, see CHANGE REPLICATION SOURCE TO Statement.

Replication channel options are set in the metadata and do not take effect until the channel is started or restarted, using replicaSet.rejoinInstance() for example. These options can also be set when the instance is OFFLINE.

If an option is set with a NULL value, the default value is used.