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 |