{"id":2685,"date":"2024-10-31T06:27:26","date_gmt":"2024-10-31T06:27:26","guid":{"rendered":"https:\/\/bynatree.com\/?p=2685"},"modified":"2024-10-31T06:27:26","modified_gmt":"2024-10-31T06:27:26","slug":"mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08","status":"publish","type":"post","link":"https:\/\/divaind.com\/ie1\/2024\/10\/31\/mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08\/","title":{"rendered":"Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08"},"content":{"rendered":"

Overview of Changes from MySQL 5.7.44 to 8.0.39 Version<\/span><\/h1>\n

The upgrade from MySQL 5.7.44 to 8.0.39 includes major additions and changes which affect safety, performance, and functionality. Below are the key fields of changes<\/span><\/p>\n

New Default Authentication Plugin<\/h4>\n

MySQL 8.0 uses caching_sha2_passwor<\/strong>d as the default authentication method instead of mysql_native_password<\/strong>. This change enhances security but requires updates to connection strings and client applications.<\/span><\/p>\n

Transactional Data Dictionary<\/h4>\n

MySQL 8.0 introduces a transactional data dictionary, which improves reliability by storing metadata in a single InnoDB tablespace, ensuring atomic DDL operations.<\/span><\/p>\n

In Data Dictionary (DD) support is introduced in MySQL 8.0 for which several new DD tables are created in the mysql schema. Hence user tables with the conflicting names in the mysql schema should be dropped or renamed prior to upgrade. The DD table names are mentioned below: \u2018catalogs\u2019, \u2018character_sets\u2019, \u2018collations\u2019, \u2018column_statistics\u2019, \u2018column_type_elements\u2019, \u2018columns\u2019, \u2018dd_properties\u2019, \u2018events\u2019, \u2018foreign_key_column_usage\u2019, \u2018foreign_keys\u2019, \u2018index_column_usage\u2019, \u2018index_partitions\u2019, \u2018index_stats\u2019, \u2018indexes\u2019, \u2018parameter_type_elements\u2019, \u2018parameters\u2019, \u2018resource_groups\u2019, \u2018routines\u2019, \u2018schemata\u2019, \u2018st_spatial_reference_systems\u2019, \u2018table_partition_values\u2019, \u2018table_partitions\u2019, \u2018table_stats\u2019, \u2018tables\u2019, \u2018tablespace_files\u2019, \u2018tablespaces\u2019, \u2018triggers\u2019, \u2018view_routine_usage\u2019, \u2018view_table_usage\u2019<\/strong>.\u00a0\u00a0<\/span><\/p>\n

Default Character Set<\/h4>\n

The default character set has shifted from latin1 in MySQL 5.7 to utf8mb4 in MySQL 8.0, which supports a wider range of characters, including emojis.<\/span><\/p>\n

Default Collation<\/h4>\n

The default collation is now utf8mb4_0900_ai_ci, aligning with Unicode 9.0 standards, improving character comparison and sorting capabilities.<\/span><\/p>\n

Stricter SQL Modes<\/h4>\n

The default SQL mode in MySQL 8.0 includes ONLY_FULL_GROUP_BY, which enforces stricter rules on GROUP BY clauses, potentially affecting existing queries.<\/span><\/p>\n

Obsolete Data Types<\/h4>\n

Several data types and features have been deprecated or removed, including old-style decimal types and non-native partitioning. Users are encouraged to transition to newer alternatives like VARCHAR or TEXT for string storage.<\/span><\/p>\n

Optimizations<\/h4>\n

MySQL 8.0 is designed for better performance, particularly in read\/write workloads, with various internal optimizations.<\/span><\/p>\n

Role-Based Access Control<\/h4>\n

MySQL 8.0 supports roles, allowing for easier management of user privileges and enhancing security2.<\/span><\/p>\n

Common Table Expressions (CTEs) and Window Functions<\/h4>\n

These features allow for more complex queries and better performance by simplifying code and enabling advanced data manipulations.
\n<\/span><\/p>\n

Checklist for MySQL Upgrade<\/span><\/h2>\n
    \n
  • Make sure to take backup before upgrading.<\/span><\/li>\n
  • Check with the mysql utility for ERROR before upgrading.<\/span><\/li>\n
  • Make sure there is no ERROR before going to the next step.<\/span><\/li>\n<\/ul>\n

    Following Step by Step process for Upgrade<\/span><\/h3>\n

    Verify the existing MySQL version and databases<\/span><\/h4>\n

     <\/p>\n

    [root@Slave ~]# mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or g.\nYour MySQL connection id is 17\nServer version: 5.7.44 MySQL Community Server (GPL)\nCopyright (c) 2000, 2023, Oracle and\/or its affiliates.\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\nmysql> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| employees          |\n| mysql              |\n| performance_schema |\n| sys                |\n+--------------------+\n5 rows in set (0.01 sec)<\/pre>\n
    Take backup before upgradation<\/span><\/h4>\n
     <\/p>\n
    [root@Slave centos]# xtrabackup --backup --target-dir=\/home\/centos\/full_bkp\/ -uroot -p\nxtrabackup: recognized server arguments: --datadir=\/var\/lib\/mysql\nxtrabackup: recognized client arguments: --backup=1 --target-dir=\/home\/centos\/full_bkp\/ --user=root --password\nEnter password:\n241018 18:00:37\u00a0 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'\u00a0 (using password: YES).\n241018 18:00:37\u00a0 version_check Connected to MySQL server\n241018 18:00:37\u00a0 version_check Executing a version check against the server...\n# A software update is available:\n241018 18:00:44\u00a0 version_check Done.\n241018 18:00:44 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set\n................\n................\nxtrabackup: Transaction log of lsn (589277859) to (589277868) was copied.\n241018 18:01:10 completed OK!<\/pre>\n
    Verify the backup on directory<\/span>
    \n<\/span><\/h4>\n
     <\/p>\n
    [root@Slave centos]# cd full_bkp\n[root@Slave full_bkp]# ls -lh\ntotal 77M\n-rw-r-----. 1 root root\u00a0 487 Oct 18 18:01 backup-my.cnf\ndrwxr-x---. 2 root root 4.0K Oct 18 18:01 employees\n-rw-r-----. 1 root root\u00a0 436 Oct 18 18:01 ib_buffer_pool\n-rw-r-----. 1 root root\u00a0 76M Oct 18 18:00 ibdata1\ndrwxr-x---. 2 root root 4.0K Oct 18 18:01 mysql\ndrwxr-x---. 2 root root 8.0K Oct 18 18:01 performance_schema\ndrwxr-x---. 2 root root 8.0K Oct 18 18:01 sys\n-rw-r-----. 1 root root\u00a0 141 Oct 18 18:01 xtrabackup_checkpoints\n-rw-r-----. 1 root root\u00a0 441 Oct 18 18:01 xtrabackup_info\n-rw-r-----. 1 root root 2.5K Oct 18 18:01 xtrabackup_logfile<\/pre>\n
    Check compatibility before upgrade<\/h3>\n
    Using mysql shell and mysql shell utility checking for Server upgrade util.checkForServerUpgrade.<\/span><\/p>\n
    [root@Slave full_bkp]# mysqlsh\nMySQL Shell 8.4.1\nCopyright (c) 2016, 2024, Oracle and\/or its affiliates.\nOracle is a registered trademark of Oracle Corporation and\/or its affiliates.\nOther names may be trademarks of their respective owners.\nType 'help' or '?' for help; 'quit' to exit.\nMySQL\u00a0 SQL > connect root@localhost\nCreating a session to 'root@localhost'\nFetching global names for auto-completion... Press ^C to stop.\nYour MySQL connection id is 21\nServer version: 5.7.44 MySQL Community Server (GPL)\nNo default schema selected; type use <schema> to set one.<\/pre>\n
    Checking for error before upgrade using <\/span>util.checkForServerUpgrade<\/b> make sure to correct these Errors before upgrade for smooth operations.<\/span><\/p>\n
    MySQL\u00a0 localhost:3306 ssl\u00a0 JS > util.checkForServerUpgrade('root@localhost', {configPath: '\/etc\/my.cnf', targetVersion: '8.0'});\nThe MySQL server at localhost:3306, version 5.7.44 - MySQL Community Server\n(GPL), will now be checked for compatibility issues for upgrade to MySQL 8.0.38.\n\n1) Usage of old temporal type (oldTemporal)\n\u00a0 No issues found\n\n2) MySQL syntax check for routine-like objects (routineSyntax)\n\u00a0 No issues found\n.........................\n.........................\nErrors: \u00a0 0\nWarnings: 32\nNotices:\u00a0 1\n\nNOTE: No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.\nMySQL\u00a0 localhost:3306 ssl\u00a0 JS > q\nBye!<\/pre>\n
    Install package “<\/span>mysql80-community-release-el8-3.noarch” using Yum repository.<\/span><\/h3>\n
    [root@Slave centos]# yum install mysql80-community-release-el8-3.noarch.rpm\nLast metadata expiration check: 0:28:34 ago on Fri 18 Oct 2024 05:57:27 PM EDT.\nDependencies resolved.\n==============================================================================================================================================================\nPackage \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Architecture \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Version\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Repository\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Size\n==============================================================================================================================================================\nInstalling:\nmysql80-community-release \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 noarch \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 el8-3\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @commandline\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 14 k\n\nTransaction Summary\n==============================================================================================================================================================\nInstall\u00a0 1 Package\n\nTotal size: 14 k\nInstalled size: 7.5 k\nIs this ok [y\/N]: y\nDownloading Packages:\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n\u00a0 Preparing\u00a0 \u00a0 \u00a0 \u00a0 :\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1\/1\n\u00a0 Installing \u00a0 \u00a0 \u00a0 : mysql80-community-release-el8-3.noarch \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1\/1\n\u00a0 Verifying\u00a0 \u00a0 \u00a0 \u00a0 : mysql80-community-release-el8-3.noarch \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1\/1\n\nInstalled:\n\u00a0 Mysql80-community-release-el8-3.noarch\n\nComplete!<\/pre>\n
    Verifying Installed Package.<\/span><\/p>\n
    [root@Slave centos]# yum list installed |grep -i mysql\nmysql-community-client.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.7.44-1.el7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @mysql57-community\nmysql-community-common.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.7.44-1.el7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @mysql57-community\nmysql-community-libs.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.7.44-1.el7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @mysql57-community\nmysql-community-server.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.7.44-1.el7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @mysql57-community\nmysql-shell.x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.4.1-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @mysql-tools-8.4-lts-community\nmysql80-community-release.noarch \u00a0 \u00a0 \u00a0 \u00a0 el8-3 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 @@commandline\nperl-DBD-MySQL.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4.046-3.module_el8+353+7103df35 \u00a0 \u00a0 @appstream<\/pre>\n
    Stop the MySQL Service<\/span>
    \n<\/span><\/h4>\n
    [root@Slave centos]# systemctl stop mysqld.service\n[root@Slave centos]# systemctl status mysqld.service\n\u25cf mysqld.service - MySQL Server\n\u00a0 Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)\n\u00a0 Active: inactive (dead) since Fri 2024-10-18 18:27:12 EDT; 13s ago\n\u00a0 \u00a0 Docs: man:mysqld(8)\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html\nMain PID: 16549 (code=exited, status=0\/SUCCESS)\n\nOct 18 15:41:07 Slave systemd[1]: Starting MySQL Server...\nOct 18 15:41:49 Slave systemd[1]: Started MySQL Server.\nOct 18 18:27:09 Slave systemd[1]: Stopping MySQL Server...\nOct 18 18:27:12 Slave systemd[1]: mysqld.service: Succeeded.\nOct 18 18:27:12 Slave systemd[1]: Stopped MySQL Server.<\/pre>\n
    Update the mysql server<\/span><\/h3>\n
    update the MySQL server using yum command, it will clear the existing <\/span>mysql-community-server-5.7.44-1.el7.x86_64, mysql-community-client-5.7.44-1.el7.x86_64, mysql-community-common-5.7.44-1.el7.x86_64\u00a0<\/span><\/p>\n
    [root@Slave centos]# yum update mysql-server\nMySQL Connectors Community\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 555 kB\/s | 143 kB \u00a0 \u00a0 00:00\nMySQL Tools Community \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.5 MB\/s | 1.2 MB \u00a0 \u00a0 00:00\nLast metadata expiration check: 0:00:01 ago on Fri 18 Oct 2024 06:27:54 PM EDT.\nDependencies resolved.\n==============================================================================================================================================================\nPackage\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Architecture \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Version\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Repository \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Size\n==============================================================================================================================================================\nUpgrading:\nmysql-community-client \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 16 M\nmysql-community-common \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 668 k\nmysql-community-libs \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.5 M\nmysql-community-server \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 65 M\nInstalling dependencies:\nmysql-community-client-plugins \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.6 M\nmysql-community-icu-data-files \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 8.0.40-1.el8 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql80-community \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.2 M\n\nTransaction Summary\n==============================================================================================================================================================\nInstall\u00a0 2 Packages\nUpgrade\u00a0 4 Packages\n\nTotal download size: 89 M\nIs this ok [y\/N]: y\nDownloading Packages:\n(1\/6): mysql-community-icu-data-files-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.2 MB\/s | 2.2 MB \u00a0 \u00a0 00:01\n(2\/6): mysql-community-common-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.0 MB\/s | 668 kB \u00a0 \u00a0 00:00\n(3\/6): mysql-community-client-plugins-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.0 MB\/s | 3.6 MB \u00a0 \u00a0 00:03\n(4\/6): mysql-community-libs-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.1 MB\/s | 1.5 MB \u00a0 \u00a0 00:01\n(5\/6): mysql-community-client-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.8 MB\/s |\u00a0 16 MB \u00a0 \u00a0 00:09\n(6\/6): mysql-community-server-8.0.40-1.el8.x86_64.rpm \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.0 MB\/s |\u00a0 65 MB \u00a0 \u00a0 00:21\n--------------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.5 MB\/s |\u00a0 89 MB \u00a0 \u00a0 00:25\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n\u00a0 Preparing\u00a0 \u00a0 \u00a0 \u00a0 :\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1\/1\n..........................\n..........................\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 10\/10\n\nUpgraded:\n\u00a0 mysql-community-client-8.0.40-1.el8.x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql-community-common-8.0.40-1.el8.x86_64 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql-community-libs-8.0.40-1.el8.x86_64\n\u00a0 mysql-community-server-8.0.40-1.el8.x86_64\nInstalled:\n\u00a0 mysql-community-client-plugins-8.0.40-1.el8.x86_64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql-community-icu-data-files-8.0.40-1.el8.x86_64\n\nComplete!<\/pre>\n
    Start MySQL service<\/span>
    \n<\/span><\/h4>\n
    Start the MySQL service using new binaries<\/p>\n
    [root@Slave centos]# systemctl start mysqld.service\n[root@Slave centos]# systemctl status mysqld.service\n\u25cf mysqld.service - MySQL Server\n\u00a0 Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)\n\u00a0 Active: active (running) since Fri 2024-10-18 18:32:11 EDT; 5s ago\n\u00a0 \u00a0 Docs: man:mysqld(8)\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html\n\u00a0 Process: 76080 ExecStartPre=\/usr\/bin\/mysqld_pre_systemd (code=exited, status=0\/SUCCESS)\nMain PID: 76171 (mysqld)\n\u00a0 Status: \"Server is operational\"\n\u00a0 \u00a0 Tasks: 38 (limit: 10938)\n\u00a0 Memory: 688.2M\n\u00a0 CGroup: \/system.slice\/mysqld.service\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u2514\u250076171 \/usr\/sbin\/mysqld\n\nOct 18 18:31:10 Slave systemd[1]: Starting MySQL Server...\nOct 18 18:32:11 Slave systemd[1]: Started MySQL Server.<\/pre>\n
    Verify the upgradation<\/span><\/h4>\n
    Verify the MySQL upgradation by connecting to the new database version<\/p>\n
    [root@Slave centos]# mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.\u00a0 Commands end with ; or g.\nYour MySQL connection id is 11\nServer version: 8.0.40 MySQL Community Server - GPL\n\nCopyright (c) 2000, 2024, Oracle and\/or its affiliates.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nmysql> s\n--------------\nmysql\u00a0 Ver 8.0.40 for Linux on x86_64 (MySQL Community Server - GPL)\n\nConnection id:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 11\nCurrent database:\nCurrent user: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 root@localhost\nSSL:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Not in use\nCurrent pager:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 stdout\nUsing outfile:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ''\nUsing delimiter:\u00a0 \u00a0 \u00a0 \u00a0 ;\nServer version: \u00a0 \u00a0 \u00a0 \u00a0 8.0.40 MySQL Community Server - GPL\nProtocol version: \u00a0 \u00a0 \u00a0 10\nConnection: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Localhost via UNIX socket\nServer characterset:\u00a0 \u00a0 utf8mb4\nDb \u00a0 \u00a0 characterset:\u00a0 \u00a0 utf8mb4\nClient characterset:\u00a0 \u00a0 utf8mb4\nConn.\u00a0 characterset:\u00a0 \u00a0 utf8mb4\nUNIX socket:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/var\/lib\/mysql\/mysql.sock\nBinary data as: \u00a0 \u00a0 \u00a0 \u00a0 Hexadecimal\nUptime: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1 min 27 sec\nThreads: 2\u00a0 Questions: 11\u00a0 Slow queries: 0\u00a0 Opens: 668\u00a0 Flush tables: 4\u00a0 Open tables: 35\u00a0 Queries per second avg: 0.126\n--------------\nmysql> show databases;\n+--------------------+\n| Database \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+--------------------+\n| employees\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| information_schema |\n| mysql\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| performance_schema |\n| sys\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+--------------------+\n5 rows in set (0.01 sec)\nmysql> q<\/pre>\n
    Verify the compatibility of the tables<\/span><\/h4>\n
    Checks tables for any compatibility issues<\/p>\n
    [root@Slave centos]# mysqlcheck --user=root --all-databases --check-upgrade -p\nEnter password:\nemployees.departments\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Table is already up to date\nemployees.dept_emp \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Table is already up to date\n..................................\n..................................<\/pre>\n
    <\/h3>\n","protected":false},"excerpt":{"rendered":"
    Overview of Changes from MySQL 5.7.44 to 8.0.39 Version The upgrade from MySQL 5.7.44 to 8.0.39 includes major additions and changes which affect safety, performance, and functionality. Below are the key fields of changes New Default Authentication Plugin MySQL 8.0 uses caching_sha2_password as the default authentication method instead of mysql_native_password. This change enhances security but…<\/p>\n","protected":false},"author":1,"featured_media":2687,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[91,113,203,204,208,212,217,219,335],"class_list":["post-2685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-centos-mysql-upgrade","tag-database-migration","tag-mysql-5-7-to-8-0","tag-mysql-8-0-installation","tag-mysql-best-practices","tag-mysql-performance-tuning","tag-mysql-upgrade","tag-mysql-version-upgrade","tag-tech-blog","category-24","description-off"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/posts\/2685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/comments?post=2685"}],"version-history":[{"count":0,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/posts\/2685\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/media\/2687"}],"wp:attachment":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/media?parent=2685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/categories?post=2685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/tags?post=2685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}