The MASTER_LOG_POS value of the START SLAVE UNTIL condition. The MASTER_LOG_FILE value of the START SLAVE UNTIL condition. Total size of all relay log files combined. Can be used to start a new replica from a current replica with the CHANGE MASTER TO. Position up to which the SQL thread has processed in the current master binary log file. Number of events that a replica skips from the master, as recorded in the sql_slave_skip_counter system variable. Tables specified for ignoring with the replicate_wild_ignore_table option. Tables specified for replicating with the replicate_wild_do_table option. Tables specified for ignoring with the replicate_ignore_table option. Tables specified for replicating with the replicate_do_table option. Whether or not the SQL thread is running.ĭatabases specified for replicating with the replicate_do_db option.ĭatabases specified for ignoring with the replicate_ignore_db option. Whether the replica I/O thread is running and connected ( Yes), running but not connected to a primary ( Connecting) or not running ( No). Name of the primary binary log file that contains the most recent event executed by the SQL thread. Position up to which the SQL thread has finished processing in the current relay log file. Name of the relay log file that the SQL thread is currently processing. Position up to which the I/O thread has read in the current primary binary log file. Name of the primary binary log file that the I/O thread is currently reading from. The master-retry-count option determines the maximum number of reconnection attempts. The CHANGE MASTER TO statement can set this. Time in seconds between retries to connect. The port being used to connect to the primary. Master host that the replica is connected to.Īccount user name being used to connect to the primary. Returned with SHOW ALL SLAVES STATUS (or SHOW ALL REPLICAS STATUS from MariaDB 10.5.1) only.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |