# 安装 1. 下载检查工具 https://dev.mysql.com/downloads/shell/  选择所需要的系统版本 2. 检查工具安装 ```shell rpm -ivh mysql-shell-8.0.33-1.el7.x86_64.rpm ``` 3. 检查mysqlsh版本，确定指向无误 ```shell mysqlsh --version ``` # 升级检查 进行升级检查，使用如下命令 ```shell mysqlsh -- util checkForServerUpgrade root@localhost:3306 --target-version=8.0.32 --config-path=/etc/my.cnf Please provide the password for 'root@localhost:3306': ******* Save password for 'root@localhost:3306'? [Y]es/[N]o/Ne[v]er (default No): The MySQL server at localhost:3306, version 5.7.41-log - MySQL Community Server (GPL), will now be checked for compatibility issues for upgrade to MySQL 8.0.32... ``` 或 ```shell [root@itdev2 ~]# mysqlsh -uroot -p Please provide the password for 'root@localhost': ******* Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): MySQL Shell 8.0.33 Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. Creating a session to 'root@localhost' Fetching schema names for auto-completion... Press ^C to stop. Your MySQL connection id is 2885 Server version: 5.7.41-log MySQL Community Server (GPL) No default schema selected; type \use <schema> to set one. MySQL localhost:3306 JS > util.checkForServerUpgrade('root@localhost:3306', {"password":"root123","targetVersion":"8.0.32","configPath":"/etc/my.cnf"}) ``` 显示如下日志 ``` 1) Usage of old temporal type No issues found 2) MySQL 8.0 syntax check for routine-like objects No issues found ... ... Errors: 5 Warnings: 31313 Notices: 1649 ``` 一共检查如下 27 项 1. Usage of old temporal type 2. MySQL 8.0 syntax check for routine-like objects 3. Usage of db objects with names conflicting with new reserved keywords 4. Usage of utf8mb3 charset 5. Table names in the mysql schema conflicting with new tables in 8.0 6. Partitioned tables using engines with non native partitioning 7. Foreign key constraint names longer than 64 characters 8. Usage of obsolete MAXDB sql_mode flag 9. Usage of obsolete sql_mode flags 10. ENUM/SET column definitions containing elements longer than 255 characters 11. Usage of partitioned tables in shared tablespaces 12. Circular directory references in tablespace data file paths 13. Usage of removed functions 14. Usage of removed GROUP BY ASC/DESC syntax 15. Removed system variables for error logging to the system log configuration 16. Removed system variables 17. System variables with new default values 18. Zero Date, Datetime, and Timestamp values 19. Schema inconsistencies resulting from file removal or corruption 20. Tables recognized by InnoDB that belong to a different engine 21. Issues reported by 'check table x for upgrade' command 22. New default authentication plugin considerations 23. Columns which cannot have default values 24. Check for invalid table names and schema names used in 5.7 25. Check for orphaned routines in 5.7 26. Check for deprecated usage of single dollar signs in object names 27. Check for indexes that are too large to work on higher versions of MySQL 我这套数据库需要解决五处错误，才可以升级，所以从稳定性考虑，先不做升级处理 # 升级检查帮助 ```shell [root@itdev2 ~]# mysqlsh -uroot -p Please provide the password for 'root@localhost': ******* Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): MySQL Shell 8.0.33 Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. Creating a session to 'root@localhost' Fetching schema names for auto-completion... Press ^C to stop. Your MySQL connection id is 2895 Server version: 5.7.41-log MySQL Community Server (GPL) No default schema selected; type \use <schema> to set one. MySQL localhost:3306 JS > util.help("checkForServerUpgrade") NAME checkForServerUpgrade - Performs series of tests on specified MySQL server to check if the upgrade process will succeed. SYNTAX util.checkForServerUpgrade([connectionData][, options]) WHERE connectionData: The connection data to server to be checked options: Dictionary of options to modify tool behaviour. DESCRIPTION If no connectionData is specified tool will try to establish connection using data from current session. Tool behaviour can be modified with following options: - configPath - full path to MySQL server configuration file. - outputFormat - value can be either TEXT (default) or JSON. - targetVersion - version to which upgrade will be checked (default=8.0.33) - password - password for connection. The connection data may be specified in the following formats: - A URI string - A dictionary with the connection options A basic URI string has the following format: [scheme://][user[:password]@]<host[:port]|socket>[/schema][?option=value&option=value...] Connection Options The following options are valid for use either in a URI or in a dictionary: - ssl-mode: The SSL mode to be used in the connection. - ssl-ca: The path to the X509 certificate authority file in PEM format. - ssl-capath: The path to the directory that contains the X509 certificate authority files in PEM format. - ssl-cert: The path to the SSL public key certificate file in PEM format. - ssl-key: The path to the SSL private key file in PEM format. - ssl-crl: The path to file that contains certificate revocation lists. - ssl-crlpath: The path of directory that contains certificate revocation list files. - ssl-cipher: The list of permissible encryption ciphers for connections that use TLS protocols up through TLSv1.2. - tls-version: List of protocols permitted for secure connections. - tls-ciphers: List of TLS v1.3 ciphers to use. - auth-method: Authentication method. - get-server-public-key: Request public key from the server required for RSA key pair-based password exchange. Use when connecting to MySQL 8.0 servers with classic MySQL sessions with SSL mode DISABLED. - server-public-key-path: The path name to a file containing a client-side copy of the public key required by the server for RSA key pair-based password exchange. Use when connecting to MySQL 8.0 servers with classic MySQL sessions with SSL mode DISABLED. - connect-timeout: The connection timeout in milliseconds. If not provided a default timeout of 10 seconds will be used. Specifying a value of 0 disables the connection timeout. - compression: Enable compression in client/server protocol. - compression-algorithms: Use compression algorithm in server/client protocol. - compression-level: Use this compression level in the client/server protocol. - connection-attributes: List of connection attributes to be registered at the PERFORMANCE_SCHEMA connection attributes tables. - local-infile: Enable/disable LOAD DATA LOCAL INFILE. - net-buffer-length: The buffer size for TCP/IP and socket communication. When these options are defined in a URI, their values must be URL encoded. The following options are also valid when a dictionary is used: Base Connection Options - uri: a URI string. - scheme: the protocol to be used on the connection. - user: the MySQL user name to be used on the connection. - dbUser: alias for user. - password: the password to be used on the connection. - dbPassword: same as password. - host: the hostname or IP address to be used on the connection. - port: the port to be used in a TCP connection. - socket: the socket file name to be used on a connection through unix sockets. - schema: the schema to be selected once the connection is done. SSH Tunnel Connection Options - ssh: a SSHURI string used when SSH tunnel is required. - ssh-password: the password the be used on the SSH connection. - ssh-identity-file: the key file to be used on the SSH connection. - ssh-identity-file-password: the SSH key file password. - ssh-config-file: the SSH configuration file, default is the value of shell.options['ssh.configFile'] ATTENTION: The dbUser and dbPassword options are will be removed in a future release. ATTENTION: The connection options have precedence over options specified in the connection options uri The connection options are case insensitive and can only be defined once. If an option is defined more than once, an error will be generated. For additional information on connection data use \? connection. MySQL localhost:3306 JS > ```