MySQL 8.0 Terminology Updates
汪成仁
MySQL/Percona
Variables
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
group_replication_ip_whitelist group_replication_ip_allowlist 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_ip_whitelist
skip_slave_start skip_replica_start 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#option_mysqld_skip-slave-start
log_slow_slave_statements log_slow_replica_statements 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_log_slow_slave_statements
log_slave_updates log_replica_updates 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_log_slave_updates
slave_parallel_type replica_parallel_type 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_slave_parallel_type
slave_parallel_workers replica_parallel_workers 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_slave_parallel_workers
slave_preserve_commit_order replica_preserve_commit_order 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_slave_preserve_commit_order
master_verify_checksum source_verify_checksum 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_master_verify_checksum
rpl_semi_sync_master=semisync_master.so rpl_semi_sync_source=semisync_source.so 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
rpl_semi_sync_slave=semisync_slave.so rpl_semi_sync_replica=semisync_replica.so 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
rpl_semi_sync_master_enabled rpl_semi_sync_source_enabled 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html#sysvar_rpl_semi_sync_master_enabled
rpl_semi_sync_slave_enabled rpl_semi_sync_replica_enabled 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html#sysvar_rpl_semi_sync_slave_enabled
...
Status
1.
Com_xxx 同 SQL 改动，如 Com_slave_start --> Com_replica_start
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html#statvar_Com_xxx
2.
Rpl_semi_sync_* 同 Varialbes 改动
Rpl_semi_sync_slave_* --> Rpl_semi_sync_replica_*
Rpl_semi_sync_master_* --> Rpl_semi_sync_source_*
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html#statvar_Rpl_semi_sync_master_clients
3.
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
Slave_open_temp_tables Replica_open_temp_tables 8.0.26 弃用 https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html#statvar_Replica_open_temp_tables
4.
Innodb_master_thread_active_loops
Innodb_master_thread_idle_loops
Percona Extented Status 没有改动
https://www.percona.com/doc/percona-server/8.0/diagnostics/innodb_show_status.html
...
SQL
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
SHOW SLAVE STATUS SHOW REPLICA STATUS (返回字段名称也有改动) 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/show-slave-status.html
START SLAVE START REPLICA 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/start-slave.html
STOP SLAVE STOP REPLICA 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/stop-slave.html
RESET SLAVE RESET REPLICA 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/reset-slave.html
SHOW SLAVE HOSTS SHOW REPLICAS (返回字段名称也有改动) 8.0.22 弃用 https://dev.mysql.com/doc/refman/8.0/en/show-slave-hosts.html
CHANGE MASTER TO MASTER_HOST... CHANGE REPLICATION SOURCE TO SOURCE_HOST... 8.0.23 弃用 https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
SHOW MASTER STATUS SHOW MASTER STATUS (不变) - https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
RESET MASTER RESET MASTER (不变) - https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
...
Privileges
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
REPLICATION SLAVE REPLICATION SLAVE (不变) - https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave
mysql.user.Repl_slave_priv mysql.user.Repl_slave_priv (不变) - https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#privileges-provided-summary
...
Event
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
SHOW EVENTS>Status>SLAVESIDE_DISABLED SHOW EVENTS>Status>SLAVESIDE_DISABLED (不变) - https://dev.mysql.com/doc/refman/8.0/en/show-events.html
...
MariaDB
目前改动很少，只有 10.5.1 在 SQL 语法中添加了 SLAVE 单词的同义词 REPLICA(见参考 #8)
SQL
旧术语 新术语 弃用/删除的版本 参考
------ ------ ---- ----
START SLAVE START REPLICA 10.5.1 弃用 https://mariadb.com/kb/en/start-replica/
STOP SLAVE STOP REPLICA 10.5.1 弃用 https://mariadb.com/kb/en/stop-replica/
RESET SLAVE RESET REPLICA 10.5.1 弃用 https://mariadb.com/kb/en/reset-replica/
SHOW SLAVE STATUS SHOW REPLICA STATUS (返回字段名称没有改动) 10.5.1 弃用 https://mariadb.com/kb/en/show-replica-status/
SHOW SLAVE HOSTS SHOW REPLICA HOSTS (返回字段名称没有改动) 10.5.1 弃用 https://mariadb.com/kb/en/show-replica-hosts/
SHOW MASTER STATUS SHOW MASTER STATUS (不变) - https://mariadb.com/kb/en/show-binlog-status/
RESET MASTER RESET MASTER (不变) - https://mariadb.com/kb/en/reset-master/
CHANGE MASTER TO CHANGE MASTER TO (不变) - https://mariadb.com/kb/en/change-master-to/
...
参考
- MySQL Terminology Updates 2020-07-01
- Changes in MySQL 8.0.22 (2020-10-19, General Availability) 2020-10-19
- Changes in MySQL 8.0.23 (2021-01-18, General Availability) 2021-01-18
- Changes in MySQL 8.0.26 (2021-07-20, General Availability) 2021-07-20
- 故障分析 | MySQL 设置 terminology_use_previous 参数导致数据库 Crash 2022-01-13
- MariaDB Replication
- Rename or alias slave-related statements, options, status variables 2019-03-01
- Make REPLICA a synonym for SLAVE in SQL statements 2019-09-16
- MariaDB versus MySQL: Compatibility
- Differences between MariaDB and MySQL — MariaDB 10.3 vs. MySQL 8.0 2018-07-18
.eof.
类似资料：