Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Configuration Metrics  /  Replication Slave Configuration Metrics

7.28 Replication Slave Configuration Metrics

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

Table 7.28 Replication Slave Configuration Metrics

NameDescription
Allow Batching EnabledWhether or not batched updates are enabled on replication slaves.
Auto Position EnabledThe set of global transaction IDs for all received transactions subsequently executed on this slave. Empty if GTIDs are not in use.
Checkpoint GroupSets the maximum number of transactions that can be processed by a multi-threaded slave before a checkpoint operation is called to update its status as shown by SHOW SLAVE STATUS. Setting this option has no effect on slaves for which multi-threading is not enabled.
Checkpoint PeriodSets the maximum time (in milliseconds) that is allowed to pass before a checkpoint operation is called to update the status of a multi-threaded slave as shown by SHOW SLAVE STATUS. Setting this variable has no effect on slaves for which multi-threading is not enabled.
Compressed Protocol EnabledWhether to use compression for the slave/master protocol if both the slave and the master support it.
Connect RetryThe number of seconds between connect retries to the master.
Exec ModeControls whether IDEMPOTENT or STRICT mode is used in replication conflict resolution and error checking.
Gtid ModeShows whether GTIDs are enabled.
Init SlaveA string to be executed by a slave server each time the SQL thread starts. The format of the string is the same as for the init_connect variable.
Load TmpdirThe name of the directory where the slave creates temporary files for replicating LOAD DATA INFILE statements.
Log Slave Updates EnabledWhether the slave logs the updates performed by its SQL thread to its own binary log.
Master Bind AddressWhen a replication slave has multiple network interfaces, determines which of the slave's network interfaces is chosen for connecting to the master.
Master HostThe master host that the slave is connected to.
Master Inet AddressThe 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.
Master Info FileThe name and location of the master.info file.
Master PortThe port used to connect to the master.
Master Retry CountThe number of times that the slave tries to connect to the master before giving up. Reconnects are attempted at intervals set by the MASTER_CONNECT_RETRY option of the CHANGE MASTER TO statement (default 60).
Master Server IdThe server_id variable value from the master.
Master Server Inv UuidThe uuid from the master mysql.inventory table, generated by MySQL Enterprise Monitor.
Master Server Repl UuidThe master servers server_uuid variable.
Master Ssl Allowed EnabledWhether slave's the master server allows SSL connections.
Master Ssl Ca FileThe path to a file that contains a list of trusted SSL CAs for use when connecting to the slave's master.
Master Ssl Ca PathThe path to a directory that contains trusted SSL CA certificates in PEM format for use when connecting to the slave's master.
Master Ssl CertThe name of the SSL certificate file to use for establishing a secure connection to the slave's master.
Master Ssl CipherA list of permissible ciphers to use for SSL encryption when connecting to the slave's master.
Master Ssl CrlThe name of the file containing a Certificate Revocation List.
Master Ssl Crl PathThe path to a directory that contains Certificate Revocation List files.
Master Ssl KeyThe name of the SSL key file to use for establishing a secure connection to the slave's master.
Master Ssl Verify Server Cert EnabledWhether the slave verifies the Common Name value in the certificate that the master sends to it against the host name that the slave uses for connecting to the master. The connection is rejected if there is a mismatch.
Master UserThe user name of the account used to connect to the master.
Max Allowed PacketSets the maximum packet size for the slave 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 SizeThe size at which the server rotates relay log files automatically.
Net TimeoutThe number of seconds to wait for more data from a master/slave connection before aborting the read.
Parallel TypeNormally, 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 slave of all uncommitted threads already in the prepare phase, without violating consistency, using this variable.
Parallel WorkersSets the number of slave worker threads for executing replication events (transactions) in parallel. Setting this variable to 0 (the default) disables parallel execution.
Pending Jobs Size MaxFor multi-Threaded slaves, this variable sets the maximum amount of memory (in bytes) available to slave worker queues holding events not yet applied.
Preserve Commit OrderFor multi-threaded slaves, enabling this variable ensures that transactions are externalized on the slave in the same order as they appear in the slave's relay log. Setting this variable has no effect on slaves for which multi-threading is not enabled.
Read Only EnabledWhen this property is enabled, the server permits no updates except from users that have the SUPER privilege.
Relay LogThe name of the relay log file.
Relay Log BasenameHolds the name and complete path to the relay log file.
Relay Log IndexThe name to use for the slave relay log index file.
Relay Log Info FileThe name to use for the file in which the slave records information about the relay logs.
Relay Log Info RepositoryDetermines whether the slave's position in the relay logs is written to a FILE (relay-log.info) or to a TABLE (mysql.slave_relay_log_info).
Relay Log Purge EnabledDisables or enables automatic purging of relay log files as soon as they are not needed any more.
Relay Log Recovery EnabledEnables automatic relay log recovery immediately following server startup, which means that the replication slave discards all unprocessed relay logs and retrieves them from the replication master.
Relay Log Space LimitThe maximum amount of space to use for all relay logs.
Replicate Do DBWhether the slave SQL thread restricts replication to statements where the default database (the one selected by USE) is one of those listed.
Replicate Do TableWhether the slave SQL thread restricts replication to the specified table(s).
Replicate Ignore DBWhether the slave SQL thread does not replicate any statement where the default database (the one selected by USE) is one of those listed.
Replicate Ignore Server IdsWhether the slave ignores events from 0 or more masters using the IGNORE_SERVER_IDS option in a CHANGE MASTER TO statement.
Replicate Ignore TableWhether the slave 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 TableWhether the slave thread restricts replication to statements where any of the updated tables match the specified database and table name patterns.
Replicate Wild Ignore TableWhether the slave thread does not replicate a statement where any table matches the given wildcard pattern.
Report HostThe host name or IP address of the slave to be reported to the master during slave registration.
Report PasswordThe account password of the slave to be reported to the master during slave registration.
Report PortThe TCP/IP port number for connecting to the slave, to be reported to the master during slave registration.
Report UserThe account user name of the slave to be reported to the master during slave registration.
Rows Search AlgorithmsWhen preparing batches of rows for row-based logging and replication using slave_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 Slave EnabledWhether semi-synchronous replication is enabled on the slave.
Semi Sync Slave Trace LevelThe semi-synchronous replication debug trace level on the slave.
Server IdThe server ID, used in replication to give each master and slave a unique identity.
Skip CounterThe number of events from the master that a slave server skips.
Skip ErrorsTells the slave SQL thread to continue replication when a statement returns any of the errors listed in the variable value.
SQL DelayThe length of time the slave SQL thread delays applying events from the relay logs when using time delayed replication.
SQL Verify Checksum EnabledWhen preparing batches of rows for row-based logging and replication using slave_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 Master InfoIf the value of this variable is greater than 0, a replication slave synchronizes its master.info file to disk (using fdatasync()) after every sync_master_info events.
Sync Relay LogIf 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 InfoIf the value of this variable is greater than 0, a replication slave synchronizes its relay-log.info file to disk (using fdatasync()) after every sync_relay_log_info transactions.
Transaction RetriesHow many times the slave 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 ConversionsControls the type conversion mode in effect on the slave when using row-based replication.
Until ConditionWhether the slave was started with a START SLAVE UNTIL condition.
Until Log FileThe master or relay log file that the slave will stop executing at, if started with a START SLAVE UNTIL condition.
Until Log PosThe master or relay log position that the slave will stop executing at, if started with a START SLAVE UNTIL condition.