Oracle Enterprise Manager for MySQL Database
Lists the Replication Slave configuration metrics and provides a brief description of each.
Table 7.28 Replication Slave Configuration Metrics
| Name | Description |
|---|---|
| Allow Batching Enabled | Whether or not batched updates are enabled on replication slaves. |
| Auto Position Enabled | The set of global transaction IDs for all received transactions subsequently executed on this slave. Empty if GTIDs are not in use. |
| Checkpoint Group | Sets 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 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 slave as shown by SHOW SLAVE STATUS. Setting this variable has no effect on slaves for which multi-threading is not enabled. |
| Compressed Protocol Enabled | Whether to use compression for the slave/master protocol if both the slave and the master support it. |
| Connect Retry | The number of seconds between connect retries to the master. |
| 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 Slave | A 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 Tmpdir | The name of the directory where the slave creates temporary files for replicating LOAD DATA INFILE statements. |
| Log Slave Updates Enabled | Whether the slave logs the updates performed by its SQL thread to its own binary log. |
| Master Bind Address | When a replication slave has multiple network interfaces, determines which of the slave's network interfaces is chosen for connecting to the master. |
| Master Host | The master host that the slave is connected to. |
| Master 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. |
| Master Info File | The name and location of the master.info file. |
| Master Port | The port used to connect to the master. |
| Master Retry Count | The 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 Id | The server_id variable value from the master. |
| Master Server Inv Uuid | The uuid from the master mysql.inventory table, generated by MySQL Enterprise Monitor. |
| Master Server Repl Uuid | The master servers server_uuid variable. |
| Master Ssl Allowed Enabled | Whether slave's the master server allows SSL connections. |
| Master Ssl Ca File | The path to a file that contains a list of trusted SSL CAs for use when connecting to the slave's master. |
| Master Ssl Ca Path | The path to a directory that contains trusted SSL CA certificates in PEM format for use when connecting to the slave's master. |
| Master Ssl Cert | The name of the SSL certificate file to use for establishing a secure connection to the slave's master. |
| Master Ssl Cipher | A list of permissible ciphers to use for SSL encryption when connecting to the slave's master. |
| Master Ssl Crl | The name of the file containing a Certificate Revocation List. |
| Master Ssl Crl Path | The path to a directory that contains Certificate Revocation List files. |
| Master Ssl Key | The name of the SSL key file to use for establishing a secure connection to the slave's master. |
| Master Ssl Verify Server Cert Enabled | Whether 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 User | The user name of the account used to connect to the master. |
| Max Allowed Packet | Sets 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 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 master/slave 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 slave of all uncommitted threads already in the prepare phase, without violating consistency, using this variable. |
| Parallel Workers | Sets 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 Max | For 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 Order | For 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 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 slave relay log index file. |
| Relay Log Info File | The name to use for the file in which the slave records information about the relay logs. |
| Relay Log Info Repository | Determines 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 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 slave discards all unprocessed relay logs and retrieves them from the replication master. |
| Relay Log Space Limit | The maximum amount of space to use for all relay logs. |
| Replicate Do DB | Whether the slave 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 slave SQL thread restricts replication to the specified table(s). |
| Replicate Ignore DB | Whether 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 Ids | Whether the slave ignores events from 0 or more masters using the IGNORE_SERVER_IDS option in a CHANGE MASTER TO statement. |
| Replicate Ignore Table | Whether 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 Table | Whether the slave 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 slave thread does not replicate a statement where any table matches the given wildcard pattern. |
| Report Host | The host name or IP address of the slave to be reported to the master during slave registration. |
| Report Password | The account password of the slave to be reported to the master during slave registration. |
| Report Port | The TCP/IP port number for connecting to the slave, to be reported to the master during slave registration. |
| Report User | The account user name of the slave to be reported to the master during slave registration. |
| Rows Search Algorithms | When 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 Enabled | Whether semi-synchronous replication is enabled on the slave. |
| Semi Sync Slave Trace Level | The semi-synchronous replication debug trace level on the slave. |
| Server Id | The server ID, used in replication to give each master and slave a unique identity. |
| Skip Counter | The number of events from the master that a slave server skips. |
| Skip Errors | Tells the slave 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 slave 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 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 Info | If 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 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 slave synchronizes its relay-log.info file to disk (using fdatasync()) after every sync_relay_log_info transactions. |
| Transaction Retries | How 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 Conversions | Controls the type conversion mode in effect on the slave when using row-based replication. |
| Until Condition | Whether the slave was started with a START SLAVE UNTIL condition. |
| Until Log File | The master or relay log file that the slave will stop executing at, if started with a START SLAVE UNTIL condition. |
| Until Log Pos | The master or relay log position that the slave will stop executing at, if started with a START SLAVE UNTIL condition. |