Documentation Home
MySQL 8.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
Man Pages (TGZ) - 266.5Kb
Man Pages (Zip) - 371.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.2 Reference Manual  /  ...  /  Startup Options and Replication Channels Startup Options and Replication Channels

This section describes startup options which are impacted by the addition of replication channels.

The master_info_repository and relay_log_info_repository system variables are deprecated, and thus subject to removal in a future version of MySQL; for this reason, these variables should not be used. (If these are set to FILE, attempting to add additional sources to a replica fails with ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY.)

The following startup options now affect all channels in a replication topology.

The values set for the following startup options apply on each channel; since these are mysqld startup options, they are applied on every channel.

  • --max-relay-log-size=size

    Maximum size of the individual relay log file for each channel; after reaching this limit, the file is rotated.

  • --relay-log-space-limit=size

    Upper limit for the total size of all relay logs combined, for each individual channel. For N channels, the combined size of these logs is limited to relay_log_space_limit * N.

  • --replica-parallel-workers=value

    Number of replication applier threads per channel.

  • replica_checkpoint_group

    Waiting time by an receiver thread for each source.

  • --relay-log-index=filename

    Base name for each channel's relay log index file. See Section, “Replication Channel Naming Conventions”.

  • --relay-log=filename

    Denotes the base name of each channel's relay log file. See Section, “Replication Channel Naming Conventions”.

  • --replica-net-timeout=N

    This value is set per channel, so that each channel waits for N seconds to check for a broken connection.

  • --replica-skip-counter=N

    This value is set per channel, so that each channel skips N events from its source.