| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
include/stop_slave.inc |
| 7 |
SHOW CREATE TABLE mysql.slave_relay_log_info; |
| 8 |
Table Create Table |
| 9 |
slave_relay_log_info CREATE TABLE `slave_relay_log_info` ( |
| 10 |
`Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.', |
| 11 |
`Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.', |
| 12 |
`Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.', |
| 13 |
`Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.', |
| 14 |
`Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.', |
| 15 |
`Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.', |
| 16 |
`Number_of_workers` int unsigned DEFAULT NULL, |
| 17 |
`Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.', |
| 18 |
`Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication', |
| 19 |
`Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.', |
| 20 |
`Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.', |
| 21 |
`Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.', |
| 22 |
`Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries', |
| 23 |
`Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value', |
| 24 |
`Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions', |
| 25 |
PRIMARY KEY (`Channel_name`) |
| 26 |
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information' |
| 27 |
ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb; |
| 28 |
SHOW CREATE TABLE mysql.slave_relay_log_info; |
| 29 |
Table Create Table |
| 30 |
slave_relay_log_info CREATE TABLE `slave_relay_log_info` ( |
| 31 |
`Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.', |
| 32 |
`Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.', |
| 33 |
`Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.', |
| 34 |
`Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.', |
| 35 |
`Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.', |
| 36 |
`Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.', |
| 37 |
`Number_of_workers` int unsigned DEFAULT NULL, |
| 38 |
`Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.', |
| 39 |
`Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication', |
| 40 |
`Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.', |
| 41 |
`Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.', |
| 42 |
`Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.', |
| 43 |
`Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries', |
| 44 |
`Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value', |
| 45 |
`Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions', |
| 46 |
PRIMARY KEY (`Channel_name`) |
| 47 |
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information' |
| 48 |
SET @@global.relay_log_info_repository="TABLE"; |
| 49 |
Warnings: |
| 50 |
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release. |
| 51 |
SET @@global.master_info_repository="TABLE"; |
| 52 |
Warnings: |
| 53 |
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. |
| 54 |
SET @@global.sync_source_info= 1; |
| 55 |
include/start_slave.inc |
| 56 |
CREATE TABLE t_innodb (id INTEGER) engine= Innodb; |
| 57 |
call mtr.add_suppression("Error writing relay log configuration."); |
| 58 |
call mtr.add_suppression("Column count of mysql.slave_relay_log_info is wrong."); |
| 59 |
call mtr.add_suppression("Error running query, replica SQL thread aborted."); |
| 60 |
call mtr.add_suppression("Info table is not ready to be used."); |
| 61 |
call mtr.add_suppression("Error writing source configuration."); |
| 62 |
call mtr.add_suppression("Failed to flush connection metadata."); |
| 63 |
call mtr.add_suppression(" Error while checking replication metadata."); |
| 64 |
call mtr.add_suppression("Failed to create or recover replication info repository."); |
| 65 |
call mtr.add_suppression("Error in checking.* repository info type of"); |
| 66 |
call mtr.add_suppression("Error creating.*: Error checking repositories"); |
| 67 |
call mtr.add_suppression("Failed to create or recover replication info repositories."); |
| 68 |
call mtr.add_suppression("An unexpected event sequence was detected by the IO thread"); |
| 69 |
call mtr.add_suppression("GTID_LOG_EVENT .* is not expected in an event stream"); |
| 70 |
call mtr.add_suppression("Failed to initialize the connection metadata structure for channel ''"); |
| 71 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 72 |
include/sync_slave_sql_with_master.inc |
| 73 |
ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Number_of_workers; |
| 74 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 75 |
include/wait_for_slave_sql_error.inc [errno=1805] |
| 76 |
Last_SQL_Error = 'Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted' |
| 77 |
include/stop_slave_io.inc |
| 78 |
include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE] |
| 79 |
START SLAVE SQL_THREAD; |
| 80 |
ERROR HY000: Replica is not configured or failed to initialize properly. You must at least set --server-id to enable either a source or a replica. Additional error messages can be found in the MySQL error log. |
| 81 |
ALTER TABLE mysql.slave_relay_log_info ADD COLUMN Number_of_workers INTEGER UNSIGNED AFTER Sql_delay; |
| 82 |
UPDATE mysql.slave_relay_log_info SET Number_of_workers= 0; |
| 83 |
include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE] |
| 84 |
include/start_slave.inc |
| 85 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 86 |
include/sync_slave_sql_with_master.inc |
| 87 |
ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Number_of_workers; |
| 88 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 89 |
include/wait_for_slave_sql_error.inc [errno=1805] |
| 90 |
Last_SQL_Error = 'Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted' |
| 91 |
include/stop_slave_io.inc |
| 92 |
START SLAVE SQL_THREAD; |
| 93 |
ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted |
| 94 |
RESET SLAVE ALL; |
| 95 |
ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted |
| 96 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS; |
| 97 |
ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted |
| 98 |
ALTER TABLE mysql.slave_relay_log_info ADD COLUMN Number_of_workers INTEGER UNSIGNED AFTER Sql_delay; |
| 99 |
UPDATE mysql.slave_relay_log_info SET Number_of_workers= 0; |
| 100 |
RESET SLAVE ALL; |
| 101 |
Warnings: |
| 102 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 103 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS; |
| 104 |
Warnings: |
| 105 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 106 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 107 |
include/start_slave.inc |
| 108 |
include/sync_slave_sql_with_master.inc |
| 109 |
ALTER TABLE mysql.slave_master_info DROP COLUMN Enabled_auto_position; |
| 110 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 111 |
include/wait_for_slave_io_error.inc [errno=13117] |
| 112 |
Last_IO_Error = 'Fatal error: Failed to flush connection metadata.' |
| 113 |
include/stop_slave_sql.inc |
| 114 |
include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE] |
| 115 |
START SLAVE SQL_THREAD; |
| 116 |
ERROR HY000: Replica is not configured or failed to initialize properly. You must at least set --server-id to enable either a source or a replica. Additional error messages can be found in the MySQL error log. |
| 117 |
ALTER TABLE mysql.slave_master_info ADD COLUMN Enabled_auto_position BOOLEAN NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.' AFTER Ssl_crlpath; |
| 118 |
UPDATE mysql.slave_master_info SET Enabled_auto_position= 0; |
| 119 |
include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE] |
| 120 |
include/start_slave.inc |
| 121 |
ALTER TABLE mysql.slave_master_info DROP COLUMN Enabled_auto_position; |
| 122 |
INSERT INTO t_innodb VALUES (1), (2), (3); |
| 123 |
include/wait_for_slave_io_error.inc [errno=13117] |
| 124 |
Last_IO_Error = 'Fatal error: Failed to flush connection metadata.' |
| 125 |
include/stop_slave_sql.inc |
| 126 |
START SLAVE SQL_THREAD; |
| 127 |
ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted |
| 128 |
RESET SLAVE ALL; |
| 129 |
ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted |
| 130 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS; |
| 131 |
ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted |
| 132 |
ALTER TABLE mysql.slave_master_info ADD COLUMN Enabled_auto_position BOOLEAN NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.' AFTER Ssl_crlpath; |
| 133 |
UPDATE mysql.slave_master_info SET Enabled_auto_position= 0; |
| 134 |
RESET SLAVE ALL; |
| 135 |
Warnings: |
| 136 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 137 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS; |
| 138 |
Warnings: |
| 139 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 140 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 141 |
include/start_slave.inc |
| 142 |
include/sync_slave_sql_with_master.inc |
| 143 |
ANALYZE TABLE mysql.slave_master_info, mysql.slave_relay_log_info; |
| 144 |
Table Op Msg_type Msg_text |
| 145 |
mysql.slave_master_info analyze status OK |
| 146 |
mysql.slave_relay_log_info analyze status OK |
| 147 |
CHECK TABLE mysql.slave_master_info, mysql.slave_relay_log_info EXTENDED; |
| 148 |
Table Op Msg_type Msg_text |
| 149 |
mysql.slave_master_info check status OK |
| 150 |
mysql.slave_relay_log_info check status OK |
| 151 |
OPTIMIZE TABLE mysql.slave_master_info, mysql.slave_relay_log_info; |
| 152 |
Table Op Msg_type Msg_text |
| 153 |
mysql.slave_master_info optimize note Table does not support optimize, doing recreate + analyze instead |
| 154 |
mysql.slave_master_info optimize status OK |
| 155 |
mysql.slave_relay_log_info optimize note Table does not support optimize, doing recreate + analyze instead |
| 156 |
mysql.slave_relay_log_info optimize status OK |
| 157 |
REPAIR TABLE mysql.slave_master_info, mysql.slave_relay_log_info EXTENDED; |
| 158 |
Table Op Msg_type Msg_text |
| 159 |
mysql.slave_master_info repair note The storage engine for the table doesn't support repair |
| 160 |
mysql.slave_relay_log_info repair note The storage engine for the table doesn't support repair |
| 161 |
SHOW CREATE TABLE mysql.slave_master_info; |
| 162 |
Table Create Table |
| 163 |
slave_master_info CREATE TABLE `slave_master_info` ( |
| 164 |
`Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.', |
| 165 |
`Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.', |
| 166 |
`Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.', |
| 167 |
`Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.', |
| 168 |
`User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.', |
| 169 |
`User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.', |
| 170 |
`Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.', |
| 171 |
`Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.', |
| 172 |
`Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.', |
| 173 |
`Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.', |
| 174 |
`Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.', |
| 175 |
`Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.', |
| 176 |
`Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.', |
| 177 |
`Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.', |
| 178 |
`Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.', |
| 179 |
`Heartbeat` float NOT NULL, |
| 180 |
`Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server', |
| 181 |
`Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs', |
| 182 |
`Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.', |
| 183 |
`Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.', |
| 184 |
`Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)', |
| 185 |
`Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files', |
| 186 |
`Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.', |
| 187 |
`Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication', |
| 188 |
`Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version', |
| 189 |
`Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.', |
| 190 |
`Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.', |
| 191 |
`Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.', |
| 192 |
`Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.', |
| 193 |
`Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.', |
| 194 |
`Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.', |
| 195 |
`Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.', |
| 196 |
`Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.', |
| 197 |
PRIMARY KEY (`Channel_name`) |
| 198 |
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information' |
| 199 |
SHOW CREATE TABLE mysql.slave_relay_log_info; |
| 200 |
Table Create Table |
| 201 |
slave_relay_log_info CREATE TABLE `slave_relay_log_info` ( |
| 202 |
`Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.', |
| 203 |
`Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.', |
| 204 |
`Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.', |
| 205 |
`Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.', |
| 206 |
`Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.', |
| 207 |
`Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.', |
| 208 |
`Number_of_workers` int unsigned DEFAULT NULL, |
| 209 |
`Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.', |
| 210 |
`Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication', |
| 211 |
`Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.', |
| 212 |
`Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.', |
| 213 |
`Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.', |
| 214 |
`Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries', |
| 215 |
`Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value', |
| 216 |
`Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions', |
| 217 |
PRIMARY KEY (`Channel_name`) |
| 218 |
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information' |
| 219 |
# Search for occurrences of slave_master_info in the output from mysqldump |
| 220 |
- Occurrences: 1 |
| 221 |
DROP TABLE t_innodb; |
| 222 |
include/sync_slave_sql_with_master.inc |
| 223 |
include/stop_slave.inc |
| 224 |
Warnings: |
| 225 |
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release. |
| 226 |
Warnings: |
| 227 |
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. |
| 228 |
SELECT * FROM mysql.slave_master_info; |
| 229 |
SELECT * FROM mysql.slave_relay_log_info; |
| 230 |
include/rpl_restart_server.inc [server_number=2] |
| 231 |
include/start_slave.inc |
| 232 |
include/rpl_end.inc |