MySQL 8.4编译安装及小技巧备份中提取单表恢复

复制的SQL语句更改

Removed Replacements
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
SHOW MASTER LOGS SHOW BINARY LOGS

SQL语句选项

CHANGE REPLICATION SOURCE TO 语句的选项,也发生了移除、替换变更,清单如下:

Removed Replacements
MASTER_AUTO_POSITION SOURCE_AUTO_POSITION
MASTER_HOST SOURCE_HOST
MASTER_BIND SOURCE_BIND
MASTER_USER SOURCE_USER
MASTER_PASSWORD SOURCE_PASSWORD
MASTER_PORT SOURCE_PORT
MASTER_CONNECT_RETRY SOURCE_CONNECT_RETRY
MASTER_RETRY_COUNT SOURCE_RETRY_COUNT
MASTER_DELAY SOURCE_DELAY
MASTER_SSL SOURCE_SSL
MASTER_SSL_CA SOURCE_SSL_CA
MASTER_SSL_CAPATH SOURCE_SSL_CAPATH
MASTER_SSL_CIPHER SOURCE_SSL_CIPHER
MASTER_SSL_CRL SOURCE_SSL_CRL
MASTER_SSL_CRLPATH SOURCE_SSL_CRLPATH
MASTER_SSL_KEY SOURCE_SSL_KEY
MASTER_SSL_VERIFY_SERVER_CERT SOURCE_SSL_VERIFY_SERVER_CERT
MASTER_TLS_VERSION SOURCE_TLS_VERSION
MASTER_TLS_CIPHERSUITES SOURCE_TLS_CIPHERSUITES
MASTER_SSL_CERT SOURCE_SSL_CERT
MASTER_PUBLIC_KEY_PATH SOURCE_PUBLIC_KEY_PATH
GET_MASTER_PUBLIC_KEY GET_SOURCE_PUBLIC_KEY
MASTER_HEARTBEAT_PERIOD SOURCE_HEARTBEAT_PERIOD
MASTER_COMPRESSION_ALGORITHMS SOURCE_COMPRESSION_ALGORITHMS
MASTER_ZSTD_COMPRESSION_LEVEL SOURCE_ZSTD_COMPRESSION_LEVEL
MASTER_LOG_FILE SOURCE_LOG_FILE
MASTER_LOG_POS SOURCE_LOG_POS

主要是将 MASTER 改为了 SOURCE。

发表评论

error: Content is protected !!