7.29 Replication Replica Configuration Metrics

Lists the Replication Replica configuration metrics and provides a brief description of each.

Table 7.29 Replication Replica Configuration Metrics

Name	Description
Allow Batching Enabled	Whether or not batched updates are enabled on replication replicas.
Auto Position Enabled	The set of global transaction IDs for all received transactions subsequently executed on this replica. Empty if GTIDs are not in use.
Checkpoint Group	Sets the maximum number of transactions that can be processed by a multi-threaded replica before a checkpoint operation is called to update its status as shown by SHOW REPLICA STATUS. Setting this option has no effect on replicas for which multi-threading is not enabled.
Checkpoint Period	Sets the maximum time (in milliseconds) that is allowed to pass before a checkpoint operation is called to update the status of a multi-threaded replica as shown by SHOW REPLICA STATUS. Setting this variable has no effect on replicas for which multi-threading is not enabled.
Compressed Protocol Enabled	Whether to use compression for the replica/source protocol if both the replica and the source support it.
Connect Retry	The number of seconds between connect retries to the source.
Exec Mode	Controls whether IDEMPOTENT or STRICT mode is used in replication conflict resolution and error checking.
Gtid Mode	Shows whether GTIDs are enabled.
Init Replica	A string to be executed by a replica server each time the SQL thread starts. The format of the string is the same as for the init_connect variable.
Load Tmpdir	The name of the directory where the replica creates temporary files for replicating LOAD DATA INFILE statements.
Log Replica Updates Enabled	Whether the replica logs the updates performed by its SQL thread to its own binary log.
Source Bind Address	When a replication replica has multiple network interfaces, determines which of the replica's network interfaces is chosen for connecting to the source.
Source Host	The source host that the replica is connected to.
Source Inet Address	The internet address as determined by the collecting agent, so as to mimic the DNS lookup as close as possible to what the mysql server would have done.
Source Info File	The name and location of the source.info file.
Source Port	The port used to connect to the source.
Source Retry Count	The number of times that the replica tries to connect to the source before giving up. Reconnects are attempted at intervals set by the SOURCE_CONNECT_RETRY option of the CHANGE SOURCE TO statement (default 60).
Source Server Id	The server_id variable value from the source.
Source Server Inv Uuid	The uuid from the source mysql.inventory table, generated by MySQL Enterprise Monitor.
Source Server Repl Uuid	The source servers server_uuid variable.
Source Ssl Allowed Enabled	Whether replica's the source server allows SSL connections.
Source Ssl Ca File	The path to a file that contains a list of trusted SSL CAs for use when connecting to the replica's source.
Source Ssl Ca Path	The path to a directory that contains trusted SSL CA certificates in PEM format for use when connecting to the replica's source.
Source Ssl Cert	The name of the SSL certificate file to use for establishing a secure connection to the replica's source.
Source Ssl Cipher	A list of permissible ciphers to use for SSL encryption when connecting to the replica's source.
Source Ssl Crl	The name of the file containing a Certificate Revocation List.
Source Ssl Crl Path	The path to a directory that contains Certificate Revocation List files.
Source Ssl Key	The name of the SSL key file to use for establishing a secure connection to the replica's source.
Source Ssl Verify Server Cert Enabled	Whether the replica verifies the Common Name value in the certificate that the source sends to it against the host name that the replica uses for connecting to the source. The connection is rejected if there is a mismatch.
Source User	The user name of the account used to connect to the source.
Max Allowed Packet	Sets the maximum packet size for the replica SQL and I/O threads, so that large updates using row-based replication do not cause replication to fail because an update exceeded max_allowed_packet.
Max Relay Log Size	The size at which the server rotates relay log files automatically.
Net Timeout	The number of seconds to wait for more data from a source/replica connection before aborting the read.
Parallel Type	Normally, transactions are applied in parallel only if they do not make any changes in the same database. Beginning with MySQL 5.7.2, it is possible to enable parallel execution on the replica of all uncommitted threads already in the prepare phase, without violating consistency, using this variable.
Parallel Workers	Sets the number of replica worker threads for executing replication events (transactions) in parallel. Setting this variable to 0 (the default) disables parallel execution.
Pending Jobs Size Max	For multi-Threaded replicas, this variable sets the maximum amount of memory (in bytes) available to replica worker queues holding events not yet applied.
Preserve Commit Order	For multi-threaded replicas, enabling this variable ensures that transactions are externalized on the replica in the same order as they appear in the replica's relay log. Setting this variable has no effect on replicas for which multi-threading is not enabled.
Read Only Enabled	When this property is enabled, the server permits no updates except from users that have the SUPER privilege.
Relay Log	The name of the relay log file.
Relay Log Basename	Holds the name and complete path to the relay log file.
Relay Log Index	The name to use for the replica relay log index file.
Relay Log Info File	The name to use for the file in which the replica records information about the relay logs.
Relay Log Info Repository	Determines whether the replica's position in the relay logs is written to a FILE (relay-log.info) or to a TABLE (mysql.replica_relay_log_info).
Relay Log Purge Enabled	Disables or enables automatic purging of relay log files as soon as they are not needed any more.
Relay Log Recovery Enabled	Enables automatic relay log recovery immediately following server startup, which means that the replication replica discards all unprocessed relay logs and retrieves them from the replication source.
Relay Log Space Limit	The maximum amount of space to use for all relay logs.
Replicate Do DB	Whether the replica SQL thread restricts replication to statements where the default database (the one selected by USE) is one of those listed.
Replicate Do Table	Whether the replica SQL thread restricts replication to the specified table(s).
Replicate Ignore DB	Whether the replica SQL thread does not replicate any statement where the default database (the one selected by USE) is one of those listed.
Replicate Ignore Server Ids	Whether the replica ignores events from 0 or more sources using the IGNORE_SERVER_IDS option in a CHANGE SOURCE TO statement.
Replicate Ignore Table	Whether the replica SQL thread does not replicate any statement that updates the specified table(s), even if any other tables might be updated by the same statement.
Replicate Wild Do Table	Whether the replica thread restricts replication to statements where any of the updated tables match the specified database and table name patterns.
Replicate Wild Ignore Table	Whether the replica thread does not replicate a statement where any table matches the given wildcard pattern.
Report Host	The host name or IP address of the replica to be reported to the source during replica registration.
Report Password	The account password of the replica to be reported to the source during replica registration.
Report Port	The TCP/IP port number for connecting to the replica, to be reported to the source during replica registration.
Report User	The account user name of the replica to be reported to the source during replica registration.
Rows Search Algorithms	When preparing batches of rows for row-based logging and replication using replica_allow_batching, this option controls how the rows are searched for matches - that is, whether or not hashing is used for searches using a primary or unique key, some other key, or no key at all.
Semi Sync Replica Enabled	Whether semi-synchronous replication is enabled on the replica.
Semi Sync Replica Trace Level	The semi-synchronous replication debug trace level on the replica.
Server Id	The server ID, used in replication to give each source and replica a unique identity.
Skip Counter	The number of events from the source that a replica server skips.
Skip Errors	Tells the replica SQL thread to continue replication when a statement returns any of the errors listed in the variable value.
SQL Delay	The length of time the replica SQL thread delays applying events from the relay logs when using time delayed replication.
SQL Verify Checksum Enabled	When preparing batches of rows for row-based logging and replication using replica_allow_batching, this option controls how the rows are searched for matches - that is, whether or not hashing is used for searches using a primary or unique key, some other key, or no key at all.
Sync Source Info	If the value of this variable is greater than 0, a replication replica synchronizes its source.info file to disk (using fdatasync()) after every sync_source_info events.
Sync Relay Log	If the value of this variable is greater than 0, the MySQL server synchronizes its relay log to disk (using fdatasync()) after every sync_relay_log writes to the relay log.
Sync Relay Log Info	If the value of this variable is greater than 0, a replication replica synchronizes its relay-log.info file to disk (using fdatasync()) after every sync_relay_log_info transactions.
Transaction Retries	How many times the replica SQL thread retries a transaction because of an InnoDB deadlock or because the transaction's execution time exceeded InnoDB's innodb_lock_wait_timeout.
Type Conversions	Controls the type conversion mode in effect on the replica when using row-based replication.
Until Condition	Whether the replica was started with a START REPLICA UNTIL condition.
Until Log File	The source or relay log file that the replica will stop executing at, if started with a START REPLICA UNTIL condition.
Until Log Pos	The source or relay log position that the replica will stop executing at, if started with a START REPLICA UNTIL condition.