Enterprise Manager
Lists the Replication Source configuration metrics and provides a brief description of each.
Table 7.28 Replication Source Configuration Metrics
Name | Description |
---|---|
Auto Increment Increment | Controls the interval between successive column values within all AUTO_INCREMENT columns within the MySQL server. |
Auto Increment Offset | Determines the starting point for the AUTO_INCREMENT column values within the MySQL server. |
Enforce Gtid Consistency Enabled | Allows execution of only those statements that can be logged in a transactionally safe manner. |
Gtid Executed | Contains a representation of the set of all transactions that are logged in the binary log. |
Gtid Executed Compression Period | Compress the mysql.gtid_executed table each time this many transactions have been processed. A setting of 0 means that this table is not compressed. Since no compression of the table occurs when using the binary log, setting the value of the variable has no effect unless binary logging is disabled. |
Gtid Mode | Shows whether GTIDs are enabled. |
Gtid Next | Specifies whether and how the next GTID is obtained. |
Gtid Owned | Holds a list of all GTIDs along with their owners. |
Gtid Purged | The set of all transactions that have been purged from the binary log. |
Info Repository | The setting of this variable determines whether the replica logs source status and connection information to a FILE (source.info), or to a TABLE (mysql.replica_source_info). |
Recovery Rank | The rank of a server when choosing which server should take over during recovery. |
Repl Uuid | The MySQL server's UUID. |
Semi Sync Source Enabled | Whether semi-synchronous replication is enabled on the source MySQL server. |
Semi Sync Source Timeout | How long the source waits on a commit (in milliseconds) for acknowledgment from a replica before timing out and reverting to asynchronous replication. |
Semi Sync Source Trace Level | The semi-synchronous replication debug trace level on the source. |
Semi Sync Source Wait No Replica Enabled | Whether the source waits for the timeout to expire before reverting to normal replication even if the replica count drops to zero during the timeout period. |
Server Id | The server ID, used in replication to give each source and replica a unique identity. |
Verify Checksum Enabled | Enabling this option causes the source to verify events from the binary log using checksums, and to stop with an error in the event of a mismatch. |