Description:
In 8.0.23, mysql deprecated the SLAVE and MASTER keywords and deprecated related commands like SHOW SLAVE STATUS, etc. These commands are removed in 8.4 release.
"SQL statements removed. The following SQL statements have been removed (replacements in brackets): START SLAVE (START REPLICA); STOP SLAVE (STOP REPLICA); SHOW SLAVE STATUS (SHOW REPLICA STATUS); SHOW SLAVE HOSTS (SHOW REPLICAS); RESET SLAVE (RESET REPLICA); CHANGE MASTER TO (CHANGE REPLICATION SOURCE TO); RESET MASTER (RESET BINARY LOGS AND GTIDS); SHOW MASTER STATUS (SHOW BINARY LOG STATUS); PURGE MASTER LOGS (PURGE BINARY LOGS); and SHOW MASTER LOGS (SHOW BINARY LOGS). "
There are three internal tables, which are highly important for replication consistency are still using the keyword "slave".
slave_relay_log_info
slave_worker_info
slave_worker_info
How to repeat:
mysql> \s
--------------
/home/mysql80/mysql8028/bin/mysql Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)
Connection id: 110
Current database: mysql
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.4.0-debug MySQL Community Server - GPL - Debug
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /tmp/mysql_sandbox8400.sock
Binary data as: Hexadecimal
Uptime: 53 min 1 sec
Threads: 30 Questions: 1620 Slow queries: 10 Opens: 197 Flush tables: 3 Open tables: 216 Queries per second avg: 0.44
--------------
mysql> use mysql
Database changed
mysql> show tables like '%info%';
+--------------------------+
| Tables_in_mysql (%info%) |
+--------------------------+
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
+--------------------------+
3 rows in set (0.00 sec)
mysql> show tables like '%slave%';
+---------------------------+
| Tables_in_mysql (%slave%) |
+---------------------------+
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
+---------------------------+
3 rows in set (0.00 sec)
mysql>
Suggested fix:
Consider to rename these tables to
replica_relay_log_info
replica_worker_info
replica_worker_info
https://dev.mysql.com/blog-archive/mysql-terminology-updates/
