复制的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。