8021开始master/slave开始演变为source/replica
In the documentation for MySQL 8.0.21, we have started changing the term “master” to “source”, the term “slave” to “replica”, the term “whitelist” to “allowlist”, and the term “blacklist” to “blocklist”. There are currently no changes to the product's syntax, so these terms are still present in the documentation where the current code requires their use.
8023开始change master to演变为change replication source to
From MySQL 8.0.23, the statement CHANGE MASTER TO
is deprecated. The alias CHANGE REPLICATION SOURCE TO
should be used instead. The parameters for the statement also have aliases that replace the term MASTER
with the term SOURCE
. For example, MASTER_HOST
and MASTER_PORT
can now be entered as SOURCE_HOST
and SOURCE_PORT
. The START REPLICA | SLAVE
statement’s parameters MASTER_LOG_POS
and MASTER_LOG_FILE
now have aliases SOURCE_LOG_POS
and SOURCE_LOG_FILE. The statements work in the same way as before, only the terminology used for each statement has changed. A deprecation warning is issued if the old versions are used.
曾走进去的坑，如下，再次记录
mysql_config_editor incorrectly treated #
in password values as a comment character. (Bug #29861961, Bug #95597)
8024开始，audit log 可以轮询复写
Audit Log File Pruning
The audit log plugin supports pruning of rotated JSON-format audit log files
Set audit_log_format
to JSON
.
Set
audit_log_rotate_on_size
greater than 0 to specify the size in bytes at which automatic log file rotation occurs.
By default, no pruning of automatically rotated JSON-format log files occurs. To enable pruning, set one of these system variables to a value greater than 0:
Set
audit_log_max_size
greater than 0 to specify the limit in bytes on the combined size of rotated log files above which the files become subject to pruning.audit_log_max_size
is available as of MySQL 8.0.26.Set
audit_log_prune_seconds
greater than 0 to specify the number of seconds after which rotated log files become subject to pruning.audit_log_prune_seconds
is available as of MySQL 8.0.24.
再次记录
The --skip-slave-start
command line parameter is used to prevent the replication I/O thread and replication SQL thread from starting when a replica server restarts.
Open SSL 的增强（当前使用域证书，已测试通过，8024）
OpenSSL 1.1.1 supports the TLS v1.3 protocol for encrypted connections, and MySQL now supports TLSv1.3 as well, if both the server and client are compiled using OpenSSL 1.1.1 or higher.
