Additional languages
« 6.4.5.1 The Slave Relay Log
6.4.6 How Servers Evaluate Replication Rules »
Section Navigation      [Toggle]

6.4.5.2. The Slave Status Files

A slave replication server creates two small files in the data directory. These status files are named master.info and relay-log.info by default. Their names can be changed by using the --master-info-file and --relay-log-info-file options. See Section 6.1.3, “Replication Options and Variables”.

The two status files contain information like that shown in the output of the SHOW SLAVE STATUS statement, which is discussed in Section 13.6.2, “SQL Statements for Controlling Slave Servers”. Because the status files are stored on disk, they survive a slave server's shutdown. The next time the slave starts up, it reads the two files to determine how far it has proceeded in reading binary logs from the master and in processing its own relay logs.

The I/O thread updates the master.info file. The following table shows the correspondence between the lines in the file and the columns displayed by SHOW SLAVE STATUS.

Line Status Column Description
1   Number of lines in the file
2 Master_Log_File The name of the master binary log currently being read from the master.
3 Read_Master_Log_Pos The current position within the master binary log that have been read from the master.
4 Master_Host The hostname of the master.
5 Master_User The username used to connect to the master.
6 Password (not shown by SHOW SLAVE STATUS) The password used to connect to the master.
7 Master_Port The network port used to connect to the master.
8 Connect_Retry The period (in seconds) that the slave will wait before trying to reconnect to the master.
9 Master_SSL_Allowed Indicates whether the server supports SSL connections.
10 Master_SSL_CA_File The file used for the Certificate Authority (CA) certificate.
11 Master_SSL_CA_Path The path to the Certificate Authority (CA) certificates.
12 Master_SSL_Cert The name of the SSL certificate file.
13 Master_SSL_Cipher The name of the cipher in use for the SSL connection.
14 Master_SSL_Key The name of the SSL key file.
15 Master_SSL_Verify_Server_Cert Whether to verify the server certificate.

Master_SSL_Verify_Server_Cert is present in master.info as of MySQL 5.1.18. It is used as described for the --ssl-verify-server-cert option in Section 5.8.7.3, “SSL Command Options”.

The SQL thread updates the relay-log.info file. The following table shows the correspondence between the lines in the file and the columns displayed by SHOW SLAVE STATUS.

Line Status Column Description
1 Relay_Log_File The name of the current relay log file.
2 Relay_Log_Pos The current position within the relay log file. Events up to this position have been executed on the slave database.
3 Relay_Master_Log_File The name of the master binary log file from which the events in the relay log file were read.
4 Exec_Master_Log_Pos The equivalent position within the master's binary log file of events that have already been executed.

The contents of the relay-log.info file and the states shown by the SHOW SLAVE STATES command may not match if the relay-log.info file has not been flushed to disk. Ideally, you should only view relay-log.info on a slave that is offline (i.e. mysqld is not running). For a running system, SHOW SLAVE STATUS should be used.