{"id":1010,"date":"2021-07-23T12:43:22","date_gmt":"2021-07-23T12:43:22","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/mysql-mariadb-upgrade\/"},"modified":"2021-07-23T12:43:22","modified_gmt":"2021-07-23T12:43:22","slug":"mysql-mariadb-upgrade","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/mysql-mariadb-upgrade\/","title":{"rendered":"MySQL\/MariaDB Upgrade"},"content":{"rendered":"<\/p>\n
\n
\n
\n

Valid for versions 98 through the latest version<\/em><\/p>\n<\/div>\n

\n

Version:<\/h4>\n

82<\/h4>\n

88<\/h4>\n

90<\/h4>\n

92<\/h4>\n

96<\/h4>\n

98<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to manage MySQL\u00ae or MariaDB\u00ae version upgrades (for example, when you upgrade from MySQL 5.7 to 8.0). After you select your MySQL or MariaDB version, WHM automatically keeps your database engine up-to-date. This means, for example, that whenever the vendor releases a new patch for your version of MySQL or MariaDB, WHM automatically applies the patch to your installation.<\/p>\n

\n
Warning:<\/div>\n
\n
    \n
  • \n

    We strongly<\/strong> recommend that you back up your database before you upgrade your database or change to MariaDB.<\/p>\n<\/li>\n

  • \n

    This feature does not support downgrades of database engine versions. We strongly<\/strong> recommend that you do not attempt to downgrade MySQL or MariaDB.<\/p>\n<\/li>\n

  • \n

    The system considers MariaDB to be an upgrade from MySQL. If you change the database engine to MariaDB, you cannot<\/strong> change back to MySQL.<\/p>\n<\/li>\n

  • \n

    You cannot<\/strong> upgrade MySQL 8 to MariaDB 10.x due to incompatibilities between these versions. For more information, read MariaDB\u2019s documentation. However, system administrators can change databases from MySQL 8 to MariaDB 10.3 during the cPanel & WHM version 92 installation process. For more information, read our Installation Guide.<\/p>\n<\/li>\n

  • \n

    If CloudLinux\u2019s\u2122 MySQL Governor exists on your server, MySQL upgrades will not<\/strong> work via this interface. If you wish to remove MySQL Governor, read CloudLinux\u2019s MySQL Governor documentation and research how this affects you.<\/p>\n<\/li>\n

  • \n

    We do not<\/strong> support the use of MySQL\u2019s sha256_password plugin for MySQL 5.7, MySQL 8, MariaDB 10.2, or MariaDB 10.3.<\/p>\n<\/li>\n

  • \n

    The phpinfo<\/code> file may display a different version of MySQL than the version that you select.<\/p>\n

      \n
    • \n

      The API version that you see in the phpinfo<\/code> file is the built-in MySQL API that PHP includes.<\/p>\n<\/li>\n

    • \n

      If the buildapache<\/code> application uses the MySQL libraries and headers on the server itself, and you change the MySQL version, Apache cannot function correctly. Because cPanel & WHM updates MySQL RPMs whenever Red Hat releases updates, this could automatically break thousands of servers within a few hours. For this reason, cPanel, L.L.C. always builds Apache and PHP with the -builtin<\/code> option.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n

    • \n

      You can use MySQL version 5.7 or 8.0 on Amazon Relational Database\u2122 Service (RDS) servers. We do not<\/strong> support MariaDB on Amazon RDS servers.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

      Available versions<\/h2>\n

      The following versions of MySQL are available:<\/p>\n

        \n
      • \n

        MySQL 5.7<\/p>\n<\/li>\n

      • \n

        MySQL 8.0<\/p>\n<\/li>\n<\/ul>\n

        \n
        Note:<\/div>\n
        \n

        If you currently run MySQL 5.6 or earlier and you wish to upgrade to MySQL 8.0, you must<\/strong> first upgrade to MySQL 5.7.<\/p>\n<\/p><\/div>\n<\/div>\n

        \n
        Important:<\/div>\n
        \n
          \n
        • \n

          MySQL 8.0 is the only<\/strong> database service and version that cPanel & WHM version 98 supports for Ubuntu\u00ae 20.04.<\/p>\n<\/li>\n

        • \n

          cPanel & WHM version 98 for Ubuntu 20.04 LTS is experimental<\/strong> software and we do not<\/strong> recommend using it in production environments. For more information, read our cPanel & WHM version 98 for Ubuntu 20.04 LTS documentation.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

          The following versions of MariaDB are available:<\/p>\n

            \n
          • \n

            MariaDB 10.2<\/p>\n<\/li>\n

          • \n

            MariaDB 10.3<\/p>\n<\/li>\n

          • \n

            MariaDB 10.5<\/p>\n<\/li>\n<\/ul>\n

            \n
            Warning:<\/div>\n
            \n

            On CloudLinux 6, MariaDB 10.5 is only available using the MySQL Governor packages. For more information, read the CloudLinux documentation.<\/p>\n<\/p><\/div>\n<\/div>\n

            Upgrade or reinstall MySQL or MariaDB<\/h2>\n

            To upgrade or reinstall your server\u2019s version of MySQL or MariaDB, perform the following steps:<\/p>\n

              \n
            1. \n

              Select the version of MySQL or MariaDB that you wish to upgrade. <\/p>\n

              \n
              Note:<\/div>\n
              \n To reinstall your database, select your current version of MySQL or MariaDB.\n <\/div>\n<\/div>\n
              \n
              Warning:<\/div>\n
              \n

              You cannot<\/strong> upgrade MySQL 8 to MariaDB 10.x due to incompatibilities between these versions. For more information, read MariaDB\u2019s documentation.<\/p>\n

              However, system administrators can change databases from MySQL 8 to MariaDB 10.3 during the cPanel & WHM version 92 installation process. For more information, read our Installation Guide.<\/p>\n<\/p><\/div>\n<\/div>\n<\/li>\n

            2. \n

              Click Continue<\/em>. A new interface will appear with warning messages about the upgrade process. <\/p>\n

              \n
              Note:<\/div>\n
              \n The system validates the \/etc\/my.cnf<\/code> file during the upgrade.\n <\/div>\n<\/div>\n<\/li>\n
            3. \n

              If you are upgrading your database server from MySQL version 5.7 to 8, the Upgrade Checker via MySQLShell (optional)<\/em> section will appear. This utility checks whether the upgrade will work on the MySQL configuration file and table engine. To run the MySQL Upgrade Checker<\/em> utility, click Install and Run Checker<\/em>. A progress window will appear, and it will display the results of the upgrade check.<\/p>\n

                \n
              • You can resolve any issues that appear in the results and click Re-Run Checker<\/em> to run the MySQL Upgrade Checker<\/em> utility again.<\/li>\n<\/ul>\n<\/li>\n
              • \n

                Select the checkbox next to each warning to acknowledge that you are aware of the potential consequences of the upgrade.<\/p>\n<\/li>\n

              • \n

                Click Continue<\/em>.<\/p>\n<\/li>\n

              • \n

                Select the type of upgrade that you wish to perform:<\/p>\n

                  \n
                • \n

                  Unattended Upgrade<\/em> \u2014 This option automatically upgrades MySQL or MariaDB.<\/p>\n<\/li>\n

                • \n

                  Interactive Upgrade<\/em> \u2014 This option steps you through the MySQL or MariaDB upgrade process.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n

                • \n

                  Click Continue<\/em>. The upgrade process interface will appear.<\/p>\n

                    \n
                  • \n

                    Select or deselect the Autoscroll output<\/em> checkbox to change whether the output display scrolls as the upgrade runs.<\/p>\n<\/li>\n

                  • \n

                    If you selected the Interactive Upgrade<\/em> type on the previous screen, the interface will prompt you to continue through each step as the upgrade progresses. The interface may also provide instructions for additional tasks that you may need to complete before continuing through the upgrade.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n

                  • \n

                    When the upgrade finishes, the interface will display a message. The message will say whether the upgrade succeeded or errors exist that you will need to address to complete the upgrade.<\/p>\n<\/li>\n<\/ol>\n

                    MySQL upgrade log<\/h2>\n

                    The system stores the MySQL and MariaDB log files in the \/var\/cpanel\/logs<\/code> directory. The log files use the mysql_upgrade_log.YYYYMMDD-hhmmss<\/code> naming convention with the following designators:<\/p>\n

                      \n
                    • \n

                      YYYY<\/code> \u2014 Four-digit year.<\/p>\n<\/li>\n

                    • \n

                      MM<\/code> \u2014 Two-digit month.<\/p>\n<\/li>\n

                    • \n

                      DD<\/code> \u2014 Two-digit day.<\/p>\n<\/li>\n

                    • \n

                      hh<\/code> \u2014 Two-digit hour.<\/p>\n<\/li>\n

                    • \n

                      mm<\/code> \u2014 Two-digit minute.<\/p>\n<\/li>\n

                    • \n

                      ss<\/code> \u2014 Two-digit second.<\/p>\n<\/li>\n<\/ul><\/div>\n","protected":false},"excerpt":{"rendered":"

                      Valid for versions 98 through the latest version Version: 82 88 90 92 96 98 Overview This interface allows you to manage MySQL\u00ae or MariaDB\u00ae version upgrades (for example, when you upgrade from MySQL 5.7 to 8.0). After you select your MySQL or MariaDB version, WHM automatically keeps your database engine up-to-date. This means, for …<\/p>\n","protected":false},"author":1,"featured_media":1011,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1010"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=1010"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/1011"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}