Configuration Reference

These are the configuration options that are specific to the group replication plugin. Every configuration option is prefixed with the plugin name, i.e., “group_replication”.

group_replication_group_name

  • Description: The name of the group.
  • Type: String
  • Accepted Input: UUID formated string.
  • Default: NULL
  • Dynamic: Yes
  • Scope: Global

group_replication_start_on_boot

  • Description: Whether the server should start Group Replication or not during server start.
  • Type: Boolean
  • Accepted Input: ON,OFF
  • Default: OFF
  • Dynamic: Yes
  • Scope: Global

group_replication_local_address

  • Description: The local address in host:port formatted string.
  • Type: String
  • Accepted Input: a “host:port” formatted string.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_group_seeds

  • Description: The list of peer addresses, comma separated. E.g., host1:port1,host2:port2.
  • Type: String
  • Accepted Input: a comma separated list of “host:port” formatted values.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_force_members

  • Description: The list of peer addresses, comma separated. E.g., host1:port1,host2:port2. This option is used to force a new group membership, on which the excluded members will not receive a new view and will be blocked. The DBA will need to kill the excluded servers.
  • Type: String
  • Accepted Input: a comma separated list of “host:port” formatted values.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_bootstrap_group

  • Description: Specify if this member will bootstrap the group. This option must only be set in one server and only once starting the group for the first time or restarting the entire group. After the group has been bootstrapped, the user is advised to set this option to OFF. It should be set to OFF both dynamically and in the configuration files. Starting two servers or restarting one server with this option set while the group is running may lead to an artificial split brain situation, where two independent groups with the same name are bootstrapped.
  • Type: Boolean
  • Accepted Input: ON, OFF
  • Default: OFF
  • Dynamic: Yes
  • Scope: Global

group_replication_poll_spin_loops

  • Description: The number of times the group communication thread waits for the communication engine mutex to be released before the thread waits for more incoming network messages.
  • Type: Integer
  • Accepted Input: [0-2^32] or [0-2^64]
  • Default: 0
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_retry_count

  • Description: The number of times that the member that is joining tries to connect to the available donors before giving up.
  • Type: Integer
  • Accepted Input: 0-31536000
  • Default: 86400
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_reconnect_interval

  • Description: The sleep time, in seconds, between reconnection attempts when no donor was found in the group.
  • Type: Integer
  • Accepted Input: [0-3600L x 24L x 365L] = [seconds x hours x days]
  • Default: 60
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_use_ssl

  • Description: Whether Group Replication recovery connection should use SSL or not.
  • Type: Boolean
  • Accepted Input: ON, OFF
  • Default: OFF
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_ca

  • Description: The path to a file that contains a list of trusted SSL certificate authorities.
  • Type: String
  • Accepted Input: A valid file path.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_capath

  • Description: The path to a directory that contains trusted SSL certificate authority certificates.
  • Type: String
  • Accepted Input: A valid directory path.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_cert

  • Description: The name of the SSL certificate file to use for establishing a secure connection.
  • Type: String
  • Accepted Input: A valid certificate name.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_key

  • Description: The name of the SSL key file to use for establishing a secure connection.
  • Type: String
  • Accepted Input: A valid key name.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_crl

  • Description: The path to a directory that contains files containing certificate revocation lists.
  • Type: String
  • Accepted Input: A valid file path.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_crlpath

  • Description: The path to a directory that contains files containing certificate revocation lists.
  • Type: String
  • Accepted Input: A valid directory path.
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_ssl_verify_server_cert

  • Description: Make recovery check the server’s Common Name value in the donor sent certificate.
  • Type: Boolean
  • Accepted Input: ON, OFF
  • Default: “”
  • Dynamic: Yes
  • Scope: Global

group_replication_recovery_complete_at

  • Description: Recovery policies when handling cached transactions after state transfer. This option specifies whether a member is marked online after it has received all transactions that it missed before it joined the group (TRANSACTIONS_CERTIFIED) or after it has received and applied them (TRANSACTIONS_APPLIED).
  • Type: Enumeration
  • Accepted Input: TRANSACTIONS_CERTIFIED, TRANSACTION_APPLIED
  • Default: TRANSACTIONS_APPLIED
  • Dynamic: Yes
  • Scope: Global

group_replication_components_stop_timeout

  • Description: Timeout, in seconds, that the plugin waits for each of the components when shutting down.
  • Type: Integer
  • Accepted Input: [2-3600L x 24L x 365L]
  • Default: 3600L x 24L x 365L
  • Dynamic: Yes
  • Scope: Global

group_replication_allow_local_lower_version_join

  • Description: Allow the current server to join the group even if it has a lower plugin version than the group.
  • Type: Boolean
  • Accepted Input: ON,OFF
  • Default: OFF
  • Dynamic: Yes
  • Scope: Global

group_replication_allow_local_disjoint_gtids_join

  • Description: Allow the current server to join the group even if it has transactions not present in the group.
  • Type: Boolean
  • Accepted Input: ON,OFF
  • Default: OFF
  • Dynamic: Yes
  • Scope: Global

group_replication_auto_increment_increment

  • Description: The group replication auto_increment_increment determines interval between successive column values for transactions that execute on this server.
  • Type: Integer
  • Accepted Input: [1-65535]
  • Default: 7
  • Dynamic: Yes
  • Scope: Global

group_replication_compression_threshold

  • Description: The value in bytes above which (lz4) compression is enforced. When set to zero, deactivates compression.
  • Type: Integer
  • Accepted Input: [0-2^32]
  • Default: 0
  • Dynamic: Yes
  • Scope: Global

group_replication_gtid_assignment_block_size

  • Description: The number of consecutive GTIDs that are reserved to each member. Each member will consume its blocks and reserve more when needed.
  • Type: Integer
  • Accepted Input: [1-2^32] or [1-2^64]
  • Default: 1
  • Dynamic: Yes
  • Scope: Global

group_replication_ssl_mode

  • Description: Specifies the security state of the connection between Group Replication members.
  • Type: Enumeration
  • Accepted Input: DISABLED, REQUIRED, VERIFY_CA, VERIFY_IDENTITY
  • Default: DISABLED
  • Dynamic: Yes
  • Scope: Global

group_replication_single_primary_mode

  • Description: Instructs the group to automatically pick a single server to be the one that handles read/write workload. This server is the PRIMARY all others are SECONDARIES.
  • Type: Boolean
  • Accepted Input: TRUE, FALSE
  • Default: TRUE
  • Dynamic: Yes
  • Scope: Global

group_replication_enforce_update_everywhere_checks

  • Description: Enable/Disable strict consistency checks for multi-master update everywhere.
  • Type: Boolean
  • Accepted Input: TRUE, FALSE
  • Default: FALSE
  • Dynamic: Yes
  • Scope: Global

group_replication_flow_control_mode

  • Description: Specifies the mode used on flow control. Currently there is only QUOTA or no flow control.
  • Type: Enumeration
  • Accepted Input: DISABLED, QUOTA
  • Default: QUOTA
  • Dynamic: Yes
  • Scope: Global

group_replication_flow_control_certifier_threshold

  • Description: Specifies the number of waiting transactions in the certifier queue that will trigger flow control.
  • Type: Integer
  • Accepted Input: [0 - 2147483648]
  • Default: 25000
  • Dynamic: Yes
  • Scope: Global

group_replication_flow_control_applier_threshold

  • Description: Specifies the number of waiting transactions in the applier queue that will trigger flow control.
  • Type: Integer
  • Accepted Input: [0 - 2147483648]
  • Default: 25000
  • Dynamic: Yes
  • Scope: Global