{"id":2853,"date":"2025-04-18T15:49:47","date_gmt":"2025-04-18T15:49:47","guid":{"rendered":"https:\/\/bynatree.com\/?p=2853"},"modified":"2025-04-18T15:49:47","modified_gmt":"2025-04-18T15:49:47","slug":"enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8","status":"publish","type":"post","link":"https:\/\/divaind.com\/ie1\/2025\/04\/18\/enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8\/","title":{"rendered":"Enhance Performance: Upgrade MySQL 8.0.40 to 8.4.4 on CentOS 8"},"content":{"rendered":"

Upgrading from MySQL 8.0.40 to 8.4.4 is critical for gaining increased performance, security, and new capabilities. This version includes expanded replication options, greater support for JSON functions, and increased scalability, ensuring that your database maintains effective, secure, and up to date with the latest breakthroughs.<\/span><\/p><\/blockquote>\n

Earlier checks:<\/span><\/h2>\n

Elimination of old data types or functions in tables.<\/span><\/h3>\n
    \n
  • Removal of orphan.frm files.<\/span><\/li>\n
  • Elimination of triggers with missing or empty definers or improper creation contexts.<\/span><\/li>\n
  • Emptying and reinstating triggers to resolve issues.<\/span><\/li>\n<\/ul>\n
    [root@mysql-01 centos]# mysqlcheck -u root -p --all-databases --check-upgrade\nEnter password:\nemployees.departments                              Table is already up to date\nemployees.dept_emp                                 Table is already up to date\nemployees.dept_manager                             Table is already up to date\nemployees.employees                                Table is already up to date\n\u2014-\n\n<\/pre>\n
    Storage Engines and Native Partitioning<\/span><\/h3>\n
      \n
    •  Ensure no partitioned tables.<\/span><\/li>\n
    •  Use a query to discover such tables.<\/span><\/li>\n<\/ul>\n
      mysql> SELECT TABLE_SCHEMA, TABLE_NAME\n    ->     FROM INFORMATION_SCHEMA.TABLES\n    ->     WHERE ENGINE NOT IN ('innodb', 'ndbcluster')\n    ->         AND CREATE_OPTIONS LIKE '%partitioned%';\nEmpty set (0.16 sec)\n\n<\/pre>\n
      Avoid tables with identical names as MySQL 8.4 data dictionary.<\/span><\/h3>\n
      Use query to locate such tables.<\/span><\/p>\n
      mysql> SELECT TABLE_SCHEMA, TABLE_NAME\n    'table_partitions',\n    'table_stats',\n    'tables',\n    'tablespace_files',\n    'tablespaces',\n    'triggers',\n    'view_routine_usage',\n    'view_table_usage'\n    );    -> FROM INFORMATION_SCHEMA.TABLES\n    -> WHERE\n    ->     LOWER(TABLE_SCHEMA) = 'mysql'\n    ->     AND\n    ->     LOWER(TABLE_NAME) IN\n    ->     (\n    ->     'catalogs',\n    ->     'character_sets',\n    ->     'check_constraints',\n    ->     'collations',\n    ->     'column_statistics',\n    ->     'column_type_elements',\n    ->     'columns',\n    ->     'dd_properties',\n    ->     'events',\n    ->     'foreign_key_column_usage',\n    ->     'foreign_keys',\n    ->     'index_column_usage',\n    ->     'index_partitions',\n    ->     'index_stats',\n    ->     'indexes',\n    ->     'parameter_type_elements',\n    ->     'parameters',\n    ->     'resource_groups',\n    ->     'routines',\n    ->     'schemata',\n    ->     'st_spatial_reference_systems',\n    ->     'table_partition_values',\n    ->     'table_partitions',\n    ->     'table_stats',\n    ->     'tables',\n    ->     'tablespace_files',\n    ->     'tablespaces',\n    ->     'triggers',\n    ->     'view_routine_usage',\n    ->     'view_table_usage'\n    ->     );\nEmpty set (0.16 sec)<\/pre>\n
      Finding Longest Foreign Key Constraint Names<\/span><\/h3>\n
        \n
      •  Avoid tables with foreign key constraints over 64 characters.<\/span><\/li>\n
      •  Use query for lengthy constraint names.<\/span><\/li>\n<\/ul>\n
        mysql> SELECT TABLE_SCHEMA, TABLE_NAME\n    -> FROM INFORMATION_SCHEMA.TABLES\n    -> WHERE TABLE_NAME IN\n    ->   (SELECT DISTINCT TABLE_NAME\n    ->    FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE\n    ->    WHERE REFERENCED_TABLE_SCHEMA IS NOT NULL);\n+-------------------------------+-----------------------+\n| TABLE_SCHEMA                  | TABLE_NAME            |\n+-------------------------------+-----------------------+\n| employees                     | dept_emp              |\n| employees                     | dept_manager          |\n| mysql_innodb_cluster_metadata | async_cluster_members |\n| mysql_innodb_cluster_metadata | async_cluster_views   |\n| mysql_innodb_cluster_metadata | clusterset_members    |\n| mysql_innodb_cluster_metadata | clusterset_views      |\n| mysql_innodb_cluster_metadata | instances             |\n| employees                     | employees             |\n| public                        | employees             |\n+-------------------------------+-----------------------+\n9 rows in set (0.96 sec)<\/pre>\n
        Updating Lower_Case_Table_Names<\/span><\/h3>\n
          \n
        •  Ensure schema and table names are lowercase before upgrading.<\/span><\/li>\n
        •  Check for capital letters in schema and table names.<\/span><\/li>\n
        •  If lower_case_table_names=1, the process checks for all lowercase names.<\/span><\/li>\n
        •  If table or schema names contain capital characters, the update procedure will fail.<\/span><\/li>\n<\/ul>\n
          mysql> select TABLE_NAME, if(sha(TABLE_NAME) !=sha(lower(TABLE_NAME)),'Yes','No') as UpperCase from information_schema.tables;\n+------------------------------------------------------+-----------+\n| TABLE_NAME                                           | UpperCase |\n+------------------------------------------------------+-----------+\n| Information                                          | Yes       |\n| friends                                              | No        |\n| students                                             | No        |\n| titles                                               | No        |\n| ADMINISTRABLE_ROLE_AUTHORIZATIONS                    | Yes       |\n| APPLICABLE_ROLES                                     | Yes       |\n| CHARACTER_SETS                                       | Yes       |\n| CHECK_CONSTRAINTS                                    | Yes       |\n| COLLATIONS                                           | Yes       |\n| COLLATION_CHARACTER_SET_APPLICABILITY                | Yes       |\n\u2014-----------------------------------------------------------------------\n| test_data                                            | No        |\n| users                                                | No        |\n| test_table                                           | No        |\n+------------------------------------------------------+-----------+\n399 rows in set (0.29 sec)<\/pre>\n
          Following Step by Step process for Upgrade<\/span><\/h2>\n
          Step 01: Take backup before upgradation:<\/span><\/h3>\n
          Before beginning the upgrading procedure, create a backup of your MySQL files and folders using mysqldump or xtrabackup.\u00a0 In this situation, we used the xtrabackup utility to perform a backup.<\/span><\/p>\n
          [root@mysql-01 centos]# xtrabackup --backup --compress=lz4 --compress-threads=4 \\\n> --target-dir=\/home\/centos\/030225 \\\n> --user=root --password\n2025-02-03T11:22:18.965560-05:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_buffer_pool_size=2147483648 --server-id=1 --log_bin=mysql-bin\n2025-02-03T11:22:18.969764-05:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --backup=1 --compress=lz4 --compress-threads=4 --target-dir=\/home\/centos\/030225 --user=root --password\nEnter password:\nxtrabackup version 8.0.35-31 based on MySQL server 8.0.35 Linux (x86_64) (revision id: 55ec21d7)\n250203 11:22:30  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).\n250203 11:22:31  version_check Connected to MySQL server\n250203 11:22:31  version_check Executing a version check against the server...\n\nxtrabackup version 8.0.35-31 based on MySQL server 8.0.35 Linux (x86_64) (revision id: 55ec21d7)<\/pre>\n
          Step 02: checking the current version of mysql.\u00a0<\/span><\/h3>\n
          We have MySQL 8.0.40 installed and are checking the databases.<\/span><\/p>\n
          [root@mysql-01 030225]# mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 30\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> show databases;\n+-------------------------------+\n| Database                      |\n+-------------------------------+\n| Audit_Storage                 |\n| Dictionary                    |\n| Students                      |\n| dummy                         |\n| employees                     |\n| information_schema            |\n| mysql                         |\n| mysql_innodb_cluster_metadata |\n| mysqlslap                     |\n| performance_schema            |\n+-------------------------------+\n16 rows in set (0.79 sec)\n\nmysql> \\q<\/pre>\n
          Step 03: Stopping MySQL services and removing the installed MySQL version.<\/span><\/p>\n
          [root@mysql-01 ~]# systemctl stop mysqld.service\n[root@mysql-01 ~]# systemctl status mysqld.service\n\u25cf mysqld.service - MySQL Server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)\n   Active: inactive (dead) since Mon 2025-02-03 13:19:43 EST; 12s ago\n     Docs: man:mysqld(8)\n           http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html\n  Process: 1846 ExecStart=\/usr\/sbin\/mysqld $MYSQLD_OPTS (code=exited, status=0\/SUCCESS)\n  Process: 1323 ExecStartPre=\/usr\/bin\/mysqld_pre_systemd (code=exited, status=0\/SUCCESS)\n Main PID: 1846 (code=exited, status=0\/SUCCESS)\n   Status: \"Server shutdown complete\"\nFeb 03 13:19:43 mysql-01.sys1 systemd[1]: mysqld.service: Succeeded.\nFeb 03 13:19:44 mysql-01.sys1 systemd[1]: Stopped MySQL Server.<\/pre>\n
          Removing mysql packages <\/span>
          \n<\/span>mysql-community-common-8.0.40-1.el8.x86_64 mysql-community-icu-data-files-8.0.40-1.el8.x86_64 mysql-community-server-8.0.40-1.el8.x86_64 mysql-community-client-8.0.40-1.el8.x86_64 mysql-community-libs-8.0.40-1.el8.x86_64<\/span><\/p>\n
          [root@mysql-01 ~]# sudo yum remove mysql-community-common-8.0.40-1.el8.x86_64 mysql-community-icu-data-files-8.0.40-1.el8.x86_64 mysql-community-server-8.0.40-1.el8.x86_64 mysql-community-client-8.0.40-1.el8.x86_64 mysql-community-libs-8.0.40-1.el8.x86_64\nDependencies resolved.\n==============================================================================================================================================================================================================\n Package                                                 Architecture                    Version                                                       Repository                                        Size\n==============================================================================================================================================================================================================\nRemoving:\n mysql-community-client                                  x86_64                          8.0.40-1.el8                                                  @mysql80-community                                79 M\n mysql-community-common                                  x86_64                          8.0.40-1.el8                                                  @System                                           10 M\n mysql-community-icu-data-files                          x86_64                          8.0.40-1.el8                                                  @System                                          3.8 M\n mysql-community-libs                                    x86_64                          8.0.40-1.el8                                                  @mysql80-community                               7.4 M\n mysql-community-server                                  x86_64                          8.0.40-1.el8                                                  @mysql80-community                               296 M\nRemoving dependent packages:\n innotop                                                 noarch                          1.13.0-1.el8                                                  @epel                                            499 k\n mysql-errmsg                                            x86_64                          8.0.26-1.module_el8.4.0+915+de215114                          @appstream                                       8.8 M\n percona-xtrabackup-80                                   x86_64                          8.0.35-31.1.el8                                               @tools-release-x86_64                            219 M\n sysbench                                                x86_64                          1.0.20-6.el8                                                  @percona-release-x86_64                          1.5 M\nRemoving unused dependencies:\n libev                                                   x86_64                          4.24-6.el8                                                    @appstream                                        99 k\n mariadb-connector-c                                     x86_64                          3.1.11-2.el8_3                                                @appstream                                       509 k\n  rsync                                                   x86_64                          3.1.3-19.el8.1                                                @baseos                                          825 k\n\nTransaction Summary\n==============================================================================================================================================================================================================\nRemove  17 Packages\n\nFreed space: 631 M\nIs this ok [y\/N]: y\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n  Preparing        :                                                                                                                                                                                      1\/1\n  Running scriptlet: innotop-1.13.0-1.el8.noarch                                                                                                                                                          1\/1\n  Erasing          : innotop-1.13.0-1.el8.noarch                                                                                                                                                         1\/17\n  Erasing          : mysql-errmsg-8.0.26-1.module_el8.4.0+915+de215114.x86_64                                                                                                                            2\/17\n  Erasing          : percona-xtrabackup-80-8.0.35-31.1.el8.x86_64                                                                                                                                        3\/17\n  Erasing          : perl-DBD-MySQL-4.046-3.module_el8+353+7103df35.x86_64  \n\u2014----------------------                                                                                                                                                                                                                                                                      \nRemoved:\n  innotop-1.13.0-1.el8.noarch                                              libev-4.24-6.el8.x86_64                                      mariadb-connector-c-3.1.11-2.el8_3.x86_64\n  mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64                 mysql-community-client-8.0.40-1.el8.x86_64                   mysql-community-common-8.0.40-1.el8.x86_64\n  mysql-community-icu-data-files-8.0.40-1.el8.x86_64                       mysql-community-libs-8.0.40-1.el8.x86_64                     mysql-community-server-8.0.40-1.el8.x86_64\n  mysql-errmsg-8.0.26-1.module_el8.4.0+915+de215114.x86_64                 percona-xtrabackup-80-8.0.35-31.1.el8.x86_64                 perl-DBD-MySQL-4.046-3.module_el8+353+7103df35.x86_64\n  perl-DBI-1.641-4.module_el8+332+132e4365.x86_64                          perl-Math-BigInt-1:1.9998.11-7.el8.noarch                    perl-Math-Complex-1.59-422.el8.noarch\n  rsync-3.1.3-19.el8.1.x86_64                                              sysbench-1.0.20-6.el8.x86_64\n\nComplete!<\/pre>\n
          Step 04: Downloading the latest released package from the official site based on Linux distributions.<\/span><\/p>\n
          [root@mysql-01 ~]# wget https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-8.4\/mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar\n--2025-02-03 13:55:51--  https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-8.4\/mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar\nResolving dev.mysql.com (dev.mysql.com)... 104.108.236.131, 2600:1417:75:495::2e31, 2600:1417:75:49d::2e31\nConnecting to dev.mysql.com (dev.mysql.com)|104.108.236.131|:443... connected.\nHTTP request sent, awaiting response... 302 Moved Temporarily\nLocation: https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-8.4\/mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar [following]\n--2025-02-03 13:55:55--  https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-8.4\/mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar\nResolving cdn.mysql.com (cdn.mysql.com)... 23.203.203.187, 2600:1417:75:499::1d68, 2600:1417:75:489::1d68\nConnecting to cdn.mysql.com (cdn.mysql.com)|23.203.203.187|:443... connected.\nHTTP request sent, awaiting response... 200 OK\nLength: 1046353920 (998M) [application\/x-tar]\nSaving to: 'mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar'\n\nmysql-8.4.4-1.el8.x86_64.rpm-bundle.tar             100%[=================================================================================================================>] 997.88M  1.93MB\/s    in 10m 12s\n\n2025-02-03 14:06:10 (1.63 MB\/s) - 'mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar' saved [1046353920\/1046353920]<\/pre>\n
          Unzipping tar files using below commands.<\/span><\/p>\n
          [root@mysql-01 ~]# tar -xvf mysql-8.4.4-1.el8.x86_64.rpm-bundle.tar\nmysql-community-client-8.4.4-1.el8.x86_64.rpm\nmysql-community-client-debuginfo-8.4.4-1.el8.x86_64.rpm\nmysql-community-client-plugins-8.4.4-1.el8.x86_64.rpm\n\u2014------------------\nmysql-community-test-debuginfo-8.4.4-1.el8.x86_64.rpm<\/pre>\n
          Step 05:\u00a0 Install a new RPM package on a Linux system, specifically a package for the MySQL 8.4 community release.<\/span><\/p>\n
          [root@mysql-01 ~]# sudo rpm -ivh mysql84-community-release-el8-1.noarch.rpm\nwarning: mysql84-community-release-el8-1.noarch.rpm: Header V4 RSA\/SHA256 Signature, key ID a8d3785c: NOKEY\nVerifying...                          ################################# [100%]\nPreparing...                          ################################# [100%]\n        package mysql84-community-release-el8-1.noarch is already installed<\/pre>\n
          To display a list of enabled repositories that contain “mysql” in their names.<\/span><\/p>\n
          [root@mysql-01 ~]# yum repolist enabled | grep mysql\nmysql-connectors-community    MySQL Connectors Community\nmysql-tools-8.4-lts-community MySQL Tools 8.4 LTS Community\nmysql80-community             MySQL 8.0 Community Server<\/pre>\n
          Step 05: Install 8.4.4 latest packages using Yum repository.<\/span><\/p>\n
          [root@mysql-01 ~]# sudo yum install mysql-community-client-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-client-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-client-plugins-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-client-plugins-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-common-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-debugsource-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-devel-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-icu-data-files-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-libs-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-libs-compat-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-libs-compat-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-libs-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-server-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-server-debug-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-server-debug-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-server-debuginfo-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-test-8.4.4-1.el8.x86_64.rpm \\\n>                 mysql-community-test-debuginfo-8.4.4-1.el8.x86_64.rpm\nakopytov_sysbench                                                                                                                                                             398  B\/s | 1.0 kB     00:02\nakopytov_sysbench-source                                                                                                                                                      463  B\/s | 1.0 kB     00:02\nPackage mysql-community-common-8.4.4-1.el8.x86_64 is already installed.\nPackage mysql-community-icu-data-files-8.4.4-1.el8.x86_64 is already installed.\nDependencies resolved.\n==============================================================================================================================================================================================================\n Package                                                                Architecture                         Version                                         Repository                                  Size\n==============================================================================================================================================================================================================\nInstalling:\n mysql-community-client                                                 x86_64                               8.4.4-1.el8                                     @commandline                                15 M\n mysql-community-client-debuginfo                                       x86_64                               8.4.4-1.el8                                     @commandline                                28 M\n mysql-community-client-plugins                                         x86_64                               8.4.4-1.el8                                     @commandline                               4.6 M\n mysql-community-client-plugins-debuginfo                               x86_64                               8.4.4-1.el8                                     @commandline                               4.6 M\n mysql-community-debuginfo                                              x86_64                               8.4.4-1.el8                                     @commandline                               4.4 M\n------\n perl-JSON                                                              noarch                               2.97.001-2.el8                                  appstream                                   96 k\n perl-Memoize                                                           noarch                               1.03-422.el8                                    appstream                                  119 k\n\nTransaction Summary\n==============================================================================================================================================================================================================\nInstall  19 Packages\n\nTotal size: 995 M\nTotal download size: 214 k\nInstalled size: 3.9 G\nIs this ok [y\/N]: y\nDownloading Packages:\n(1\/2): perl-JSON-2.97.001-2.el8.noarch.rpm                                                                                                                                    274 kB\/s |  96 kB     00:00\n(2\/2): perl-Memoize-1.03-422.el8.noarch.rpm                                                                                                                                    71 kB\/s | 119 kB     00:01\n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal                                                                                                                                                                         123 kB\/s | 214 kB     00:01\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n  Preparing        :                                                                                                                                                                              \n  Installing       : mysql-community-client-plugins-8.4.4-1.el8.x86_64                                                                                                                                   1\/16\n  Installing       : mysql-community-libs-8.4.4-1.el8.x86_64                                                                                                                                             2\/16\n  Running scriptlet: mysql-community-libs-8.4.4-1.el8.x86_64                                                                                                                                             3\/16\n-------\nInstalled:\n  mysql-community-client-8.4.4-1.el8.x86_64                                             mysql-community-client-plugins-8.4.4-1.el8.x86_64          \n  mysql-community-devel-8.4.4-1.el8.x86_64                               mysql-community-libs-8.4.4-1.el8.x86_64                              mysql-community-libs-compat-8.4.4-1.el8.x86_64\n  mysql-community-libs-compat-debuginfo-8.4.4-1.el8.x86_64                                  mysql-community-server-8.4.4-1.el8.x86_64\n  mysql-community-server-debug-8.4.4-1.el8.x86_64                        mysql-community-server-debug-debuginfo-8.4.4-1.el8.x86_64            mysql-community-server-debuginfo-8.4.4-1.el8.x86_64                                           perl-JSON-2.97.001-2.el8.noarch\n  perl-Memoize-1.03-422.el8.noarch\n\nComplete!<\/pre>\n
          Step 06: Starting and enabling mysql services:<\/span><\/p>\n
          [root@mysql-01 ~]# systemctl start mysqld.service\n[root@mysql-01 ~]# systemctl status mysqld.service\n\u25cf mysqld.service - MySQL Server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)\n   Active: active (running) since Mon 2025-02-03 14:39:34 EST; 17s ago\n     Docs: man:mysqld(8)\n           http:\/\/dev.mysql.com\/doc\/refman\/en\/using-systemd.html\n  Process: 133083 ExecStartPre=\/usr\/bin\/mysqld_pre_systemd (code=exited, status=0\/SUCCESS)\n Main PID: 133257 (mysqld)\n   Status: \"Server is operational\"\n    Tasks: 51 (limit: 10936)\n   Memory: 761.1M\n   CGroup: \/system.slice\/mysqld.service\n           \u2514\u2500133257 \/usr\/sbin\/mysqld\n\nFeb 03 14:37:59 mysql-01.sys1 systemd[1]: Starting MySQL Server...\nFeb 03 14:39:34 mysql-01.sys1 systemd[1]: Started MySQL Server.<\/pre>\n
          \u00a0Step 07: Verifying installed mysql version:<\/span><\/p>\n
          [root@mysql-01 ~]# mysql --version\nmysql  Ver 8.4.4 for Linux on x86_64 (MySQL Community Server - GPL)<\/pre>\n
          Step 08: Verify the upgradation<\/span><\/h3>\n
          Verify the MySQL upgradation by connecting to the new database version<\/span><\/p>\n
          [root@mysql-01 etc]# mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 21\nServer version: 8.4.4 MySQL Community Server - GPL\n\nCopyright (c) 2000, 2025, 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> show databases;\n+-------------------------------+\n| Database                      |\n+-------------------------------+\n| Audit_Storage                 |\n| Dictionary                    |\n| Students                      |\n| dummy                         |\n| employees                     |\n| information_schema            |\n| mysql                         |\n| mysql_innodb_cluster_metadata |\n| mysqlslap                     |\n| performance_schema            |\n+-------------------------------+\n16 rows in set (0.49 sec)\nmysql> \\q<\/pre>\n
           <\/p>\n","protected":false},"excerpt":{"rendered":"
          Upgrading from MySQL 8.0.40 to 8.4.4 is critical for gaining increased performance, security, and new capabilities. This version includes expanded replication options, greater support for JSON functions, and increased scalability, ensuring that your database maintains effective, secure, and up to date with the latest breakthroughs. Earlier checks: Elimination of old data types or functions in…<\/p>\n","protected":false},"author":1,"featured_media":2854,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[34,41,53,59,93,127,129,130,137,186,202,225,241,306,336],"class_list":["post-2853","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-databaseperformance","tag-itinfrastructure","tag-scalability","tag-techblog","tag-centos8","tag-databasemanagement","tag-databasetips","tag-databaseupgrade","tag-datasecurity","tag-jsonfunctions","tag-mysql","tag-mysqlupgrade","tag-performanceenhancement","tag-replicationoptions","tag-techsolutions","category-24","description-off"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/posts\/2853","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=2853"}],"version-history":[{"count":0,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/posts\/2853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/media\/2854"}],"wp:attachment":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/media?parent=2853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/categories?post=2853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/tags?post=2853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}