Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Number_of_lines | INT UNSIGNED | 10 | null |
|
|
Number of lines in the file. |
||
| Master_log_name | TEXT | 65535 | null |
|
|
The name of the master binary log currently being read from the master. |
||
| Master_log_pos | BIGINT UNSIGNED | 20 | null |
|
|
The master log position of the last read event. |
||
| Host | VARCHAR | 255 | √ | null |
|
|
The host name of the source. |
|
| User_name | TEXT | 65535 | √ | null |
|
|
The user name used to connect to the master. |
|
| User_password | TEXT | 65535 | √ | null |
|
|
The password used to connect to the master. |
|
| Port | INT UNSIGNED | 10 | null |
|
|
The network port used to connect to the master. |
||
| Connect_retry | INT UNSIGNED | 10 | null |
|
|
The period (in seconds) that the slave will wait before trying to reconnect to the master. |
||
| Enabled_ssl | BIT | 1 | null |
|
|
Indicates whether the server supports SSL connections. |
||
| Ssl_ca | TEXT | 65535 | √ | null |
|
|
The file used for the Certificate Authority (CA) certificate. |
|
| Ssl_capath | TEXT | 65535 | √ | null |
|
|
The path to the Certificate Authority (CA) certificates. |
|
| Ssl_cert | TEXT | 65535 | √ | null |
|
|
The name of the SSL certificate file. |
|
| Ssl_cipher | TEXT | 65535 | √ | null |
|
|
The name of the cipher in use for the SSL connection. |
|
| Ssl_key | TEXT | 65535 | √ | null |
|
|
The name of the SSL key file. |
|
| Ssl_verify_server_cert | BIT | 1 | null |
|
|
Whether to verify the server certificate. |
||
| Heartbeat | FLOAT | 12 | null |
|
|
|||
| Bind | TEXT | 65535 | √ | null |
|
|
Displays which interface is employed when connecting to the MySQL server |
|
| Ignored_server_ids | TEXT | 65535 | √ | null |
|
|
The number of server IDs to be ignored, followed by the actual server IDs |
|
| Uuid | TEXT | 65535 | √ | null |
|
|
The master server uuid. |
|
| Retry_count | BIGINT UNSIGNED | 20 | null |
|
|
Number of reconnect attempts, to the master, before giving up. |
||
| Ssl_crl | TEXT | 65535 | √ | null |
|
|
The file used for the Certificate Revocation List (CRL) |
|
| Ssl_crlpath | TEXT | 65535 | √ | null |
|
|
The path used for Certificate Revocation List (CRL) files |
|
| Enabled_auto_position | BIT | 1 | null |
|
|
Indicates whether GTIDs will be used to retrieve events from the master. |
||
| Channel_name | VARCHAR | 64 | null |
|
|
The channel on which the replica is connected to a source. Used in Multisource Replication |
||
| Tls_version | TEXT | 65535 | √ | null |
|
|
Tls version |
|
| Public_key_path | TEXT | 65535 | √ | null |
|
|
The file containing public key of master server. |
|
| Get_public_key | BIT | 1 | null |
|
|
Preference to get public key from master. |
||
| Network_namespace | TEXT | 65535 | √ | null |
|
|
Network namespace used for communication with the master server. |
|
| Master_compression_algorithm | VARCHAR | 64 | null |
|
|
Compression algorithm supported for data transfer between source and replica. |
||
| Master_zstd_compression_level | INT UNSIGNED | 10 | null |
|
|
Compression level associated with zstd compression algorithm. |
||
| Tls_ciphersuites | TEXT | 65535 | √ | null |
|
|
Ciphersuites used for TLS 1.3 communication with the master server. |
|
| Source_connection_auto_failover | BIT | 1 | 0 |
|
|
Indicates whether the channel connection failover is enabled. |
||
| Gtid_only | BIT | 1 | 0 |
|
|
Indicates if this channel only uses GTIDs and does not persist positions. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | Channel_name |
Relationships
Close relationships within degrees of separation
