MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with theCHANGE REPLICATION SOURCE TOstatement (from MySQL 8.0.23) orCHANGE MASTER TOstatement (before MySQL 8.0.23).
Thereplication_applier_configurationtable has these columns:
CHANNEL_NAMEThe replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. SeeReplication Channelsfor more information.
DESIRED_DELAYThe number of seconds that the replica must lag the source. (
CHANGE REPLICATION SOURCE TOoption:所以URCE_DELAY,CHANGE MASTER TOoption:MASTER_DELAY) SeeDelayed Replicationfor more information.PRIVILEGE_CHECKS_USERThe user account that provides the security context for the channel (
CHANGE REPLICATION SOURCE TOoption:PRIVILEGE_CHECKS_USER,CHANGE MASTER TOoption:PRIVILEGE_CHECKS_USER). This is escaped so that it can be copied into an SQL statement to execute individual transactions. SeeReplication Privilege Checksfor more information.REQUIRE_ROW_FORMATWhether the channel accepts only row-based events (
CHANGE REPLICATION SOURCE TOoption:REQUIRE_ROW_FORMAT,CHANGE MASTER TOoption:REQUIRE_ROW_FORMAT). SeeReplication Privilege Checksfor more information.REQUIRE_TABLE_PRIMARY_KEY_CHECKWhether the channel requires primary keys always, never, or according to the source's setting (
CHANGE REPLICATION SOURCE TOoption:REQUIRE_TABLE_PRIMARY_KEY_CHECK,CHANGE MASTER TOoption:REQUIRE_TABLE_PRIMARY_KEY_CHECK). SeeReplication Privilege Checksfor more information.ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPEWhether the channel assigns a GTID to replicated transactions that do not already have one (
CHANGE REPLICATION SOURCE TOoption:ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS,CHANGE MASTER TOoption:ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS).OFFmeans no GTIDs are assigned.LOCALmeans a GTID is assigned that includes the replica's own UUID (theserver_uuidsetting).MANUALmeans a GTID is assigned that includes a manually set UUID. SeeReplication From a Source Without GTIDs to a Replica With GTIDsfor more information.ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUEThe UUID that is used as part of the GTIDs assigned to anonymous transactions (
CHANGE REPLICATION SOURCE TOoption:ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS,CHANGE MASTER TOoption:ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS). SeeReplication From a Source Without GTIDs to a Replica With GTIDsfor more information.
Thereplication_applier_configurationtable has these indexes:
Primary key on (
CHANNEL_NAME)
TRUNCATE TABLEis not permitted for thereplication_applier_configurationtable.
The following table shows the correspondence betweenreplication_applier_configurationcolumns andSHOW REPLICA STATUScolumns.
replication_applier_configurationColumn |
SHOW REPLICA STATUSColumn |
|---|---|
DESIRED_DELAY |
SQL_Delay |