slave_master_info
Table comments: Master Information
| Column | Type | Null | Default | Comments |
|---|
| Number_of_lines
| int(10) | No | | Number of lines in the file. |
| Master_log_name
| text | No | | The name of the master binary log currently being read from the master. |
| Master_log_pos
| bigint(20) | No | | The master log position of the last read event. |
| Host
| char(64) | No | | The host name of the master. |
| User_name
| text | Yes | NULL | The user name used to connect to the master. |
| User_password
| text | Yes | NULL | The password used to connect to the master. |
| Port
| int(10) | No | | The network port used to connect to the master. |
| Connect_retry
| int(10) | No | | The period (in seconds) that the slave will wait before trying to reconnect to the master. |
| Enabled_ssl
| tinyint(1) | No | | Indicates whether the server supports SSL connections. |
| Ssl_ca
| text | Yes | NULL | The file used for the Certificate Authority (CA) certificate. |
| Ssl_capath
| text | Yes | NULL | The path to the Certificate Authority (CA) certificates. |
| Ssl_cert
| text | Yes | NULL | The name of the SSL certificate file. |
| Ssl_cipher
| text | Yes | NULL | The name of the cipher in use for the SSL connection. |
| Ssl_key
| text | Yes | NULL | The name of the SSL key file. |
| Ssl_verify_server_cert
| tinyint(1) | No | | Whether to verify the server certificate. |
| Heartbeat
| float | No | | |
| Bind
| text | Yes | NULL | Displays which interface is employed when connecting to the MySQL server |
| Ignored_server_ids
| text | Yes | NULL | The number of server IDs to be ignored, followed by the actual server IDs |
| Uuid
| text | Yes | NULL | The master server uuid. |
| Retry_count
| bigint(20) | No | | Number of reconnect attempts, to the master, before giving up. |
| Ssl_crl
| text | Yes | NULL | The file used for the Certificate Revocation List (CRL) |
| Ssl_crlpath
| text | Yes | NULL | The path used for Certificate Revocation List (CRL) files |
| Enabled_auto_position
| tinyint(1) | No | | Indicates whether GTIDs will be used to retrieve events from the master. |
Indexes
No index defined!
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|
| PRIMARY | BTREE | Yes | No | Host | 0 | A | No | |
| Port | 0 | A | No |