MySQL Shell 9.0
The following options can be set with
replicaSet.addInstance()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.
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.
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.
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()
If an option is set with a NULL value, the default value is used.